QUESTION: 51
You want to create a sales analysis by combining your customer master data with your transactional sales data. How do you model your data to ensure best performance?
A. Model the transactional data in the data foundation of an analytic view - Model the master data in the data foundation of an attribute view - Join both in the logical join of analytic view
B. Model the transactional data in the projection node of an calculation view - Model the master data in the data foundation of an attribute view - Combine both in the union node of the calculation view
C. Model the transactional data in the data foundation of an analytic view - Model the master data in the projection node of a calculation view - Combine both in the union node of the calculation view
D. Model the transactional data in the projection node of an calculation view - Model the master data in the data foundation of an attribute view - Combine both in the join node of the calculation view
A. Model the transactional data in the data foundation of an analytic view - Model the master data in the data foundation of an attribute view - Join both in the logical join of analytic view
B. Model the transactional data in the projection node of an calculation view - Model the master data in the data foundation of an attribute view - Combine both in the union node of the calculation view
C. Model the transactional data in the data foundation of an analytic view - Model the master data in the projection node of a calculation view - Combine both in the union node of the calculation view
D. Model the transactional data in the projection node of an calculation view - Model the master data in the data foundation of an attribute view - Combine both in the join node of the calculation view
Answer: A
QUESTION: 52
What must you do to enable currency conversions with a fixed currency in an analytic view?
A. Set the Enable for Conversion option
B. Create a measure with the measure type Simple
C. Base the target currency on a currency column
D. Create the target currency using an input parameter
A. Set the Enable for Conversion option
B. Create a measure with the measure type Simple
C. Base the target currency on a currency column
D. Create the target currency using an input parameter
Answer: A
QUESTION: 53
You have created two analytic views for actual and planned financial data each. The data covers multiple years. You want to display the actual data, planned data, and their difference in three separate columns in a report. The difference column is a calculated column. How can you model this?
A. Create a calculation view - Combine the analytic views in the calculation view using a UNION WITH CONSTANT VALUES
B. Create restricted columns for each year for the actual and planned columns in each analytic view - Combine the analytic views in a new calculation view using a UNION
C. Create an analytic view - Combine the analytic views in the new analytic view using a referential join
D. Create a calculation view - Combine the analytic views in the calculation view using a UNION
A. Create a calculation view - Combine the analytic views in the calculation view using a UNION WITH CONSTANT VALUES
B. Create restricted columns for each year for the actual and planned columns in each analytic view - Combine the analytic views in a new calculation view using a UNION
C. Create an analytic view - Combine the analytic views in the new analytic view using a referential join
D. Create a calculation view - Combine the analytic views in the calculation view using a UNION
Answer: A
QUESTION: 54
In a fuzzy search, when would you perform a freestyle search?
A. When you want to search with a low fuzziness threshold
B. When you want to search in only one column
C. When you want to search in multiple columns
D. When you want to search with a high fuzziness threshold
A. When you want to search with a low fuzziness threshold
B. When you want to search in only one column
C. When you want to search in multiple columns
D. When you want to search with a high fuzziness threshold
Answer: C
QUESTION: 55
Which tasks can you perform with the data provisioning view in the SAP HANA studio?
Note: There are multiple correct answers to the question
A. Start replication of tables
B. Filter replicated data
C. Apply data transformations
D. Suspend replication of tables
Note: There are multiple correct answers to the question
A. Start replication of tables
B. Filter replicated data
C. Apply data transformations
D. Suspend replication of tables
Answer: A, D
QUESTION: 56
Which of the following are characteristics of an operational data mart based on SAP HANA?
Note: There are multiple correct answers to the question
A. It is based on analytic denormalized data models
B. It uses real-time replication of time-critical data
C. It runs directly on top of the operational data
D. It persists transformed data
Note: There are multiple correct answers to the question
A. It is based on analytic denormalized data models
B. It uses real-time replication of time-critical data
C. It runs directly on top of the operational data
D. It persists transformed data
Answer: B, C
QUESTION: 57
You would like to authorize a user to select and delete data from a specific column table. The user should also be able to grant this authorization to other users. Which privilege do you need to implement?
A. Analytic privilege
B. System privilege
C. Package privilege
D. Object privilege
A. Analytic privilege
B. System privilege
C. Package privilege
D. Object privilege
Answer: D
QUESTION: 58
You want to investigate the runtime of a SELECT statement against an analytic view. Which of the following tools do you use to analyze the model performance, including transferred data?
A. Plan visualizer
B. Load graph
C. SQL Editor
D. SQL Debugger
Answer: A
QUESTION: 59
What is the minimum requirement for a valid analytic view?
A. One fact table and one attribute view
B. One attribute view
C. One fact table and two attribute views
D. One fact table
Answer: D
QUESTION: 60
In a fuzzy search, when would you perform a freestyle search?
A. When you want to search with a high fuzziness threshold
B. When you want to search in multiple columns
C. When you want to search in only one column
D. When you want to search with a low fuzziness threshold
Answer: B
No comments:
Post a Comment