QUESTION: 391
How can you restrict SAP HANA modeling users from viewing sensitive data?
A. Use scrambled source data
B. Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users
C. Use the pre-delivered MODELER role
D. Remove ALTER SYSTEM in the system privileges for the modeling users
QUESTION: 392
An analytic view has two columns, SHIP_TO_COUNTRY and SHIP_FROM_COUNTRY, that contain ISO country codes. You must replace these codes with the English country names by joining to the same country attribute view twice. What must you create to achieve this?
A. A derived attribute view
B. A shared attribute view
C. Two data foundations
D. An attribute view using the Copy From method
QUESTION: 393
How can you improve the performance of an information model?
Note: There are multiple correct answers to the question
Note: There are multiple correct answers to the question
A. Use generated columns
B. Use analytic views wherever possible
C. Use indexes on all measure
D. Use attribute views wherever possible
E. Use constraint filters
E. Use constraint filters
QUESTION: 394
You want to add a column to a calculation view that displays the year-to-date revenue of the current fiscal year. How can you achieve this?
Note: There are multiple correct answers to the question
Note: There are multiple correct answers to the question
A. Use a calculated attribute
B. Use a calculated measure
C. Use a variable
D. Use a CE function
QUESTION: 395
Which of the following are required to create an attribute view?
Note: There are multiple correct answers to the question
Note: There are multiple correct answers to the question
A. Data Foundation
B. Default Schema
C. Join
D. Key Attribute
QUESTION: 396
You are running an SAP BusinessObjects Web Intelligence report that fetches data from an analytic view. Which of the following 4 components is used by SAP HANA to provide data for this report?
A. SAP host agent
B. Delivery unit
C. XS engine
D. OLAP engine
QUESTION: 397
Which of the following are required to build a SQLScript calculation view?
Note: There are multiple correct answers to the question
Note: There are multiple correct answers to the question
A. Define a data foundation
B. Define a measure
C. Set the Multi-dimensional Reporting property to false
D. Add columns to the var_out output parameter
QUESTION: 398
A company needs to load external data from a flat file into SAP HANA. How can you do this?
Note: There are multiple correct answers to the question
Note: There are multiple correct answers to the question
A. SAP HANA Direct Extractor Connection (DXC)
B. SAP System Landscape Transformation (SLT)
C. SAP HANA SQL Import statement
D. SAP BusinessObjects Data Services
QUESTION: 399
How can you create a computed column in an information model?
Note: There are multiple correct answers to the question
Note: There are multiple correct answers to the question
A. Create a calculated attribute within a calculation view
B. Create a counter in an analytic view
C. Create a restricted measure in a calculation view
D. Create a restricted measure in an analytic view
QUESTION: 400
You have loaded data into SAP HANA using SAP BusinessObjects Data Services. Where can you view that data?
Note: There are multiple correct answers to the question
Note: There are multiple correct answers to the question
A. In the Catalog node of SAP HANA studio
B. In the SAP BusinessObjects Data Services job monitor
C. In the Content node of SAP HANA studio
D. In the SAP BusinessObjects Data Services table preview
No comments:
Post a Comment