SAP HANA: Certification Questions 361 through 370

QUESTION: 361

A customer complains about the performance of an analytic view. During your analysis you find out that there are calculated measures based on multiple restricted measures.  
How can you improve the performance?

A. 

• Create a calculation view 
• Add multiple analytic views 
• Use filters on attributes 
• Provide the output via an inner join operation in the calculation view  

B. 

• Create a calculation view 
• Add multiple analytic views 
• Create calculated measures on the analytic views 
• Provide the output via union operation in the calculation view  

C. 

• Create a calculation view 
• Add multiple analytic views 
• Use filters on attributes 
• Provide the output via a union operation in the calculation view

D. 

• Create multiple analytic views 
• Use filters on the attributes 
• Create calculated measures on the analytic view 
• Use a Universe to join the data  

Answer: C

QUESTION: 362

Which of the following SQL statements deletes the user HANADEMO including all dependent objects?

A. REVOKE USER HANADEMO CASCADE 

B. DROP USER HANADEMO RESTRICT

C. DROP USER HANADEMO CASCADE

D. REVOKE USER HANADEMO RESTRICT

Answer: C

QUESTION: 363

You have a table of transactional data with different transaction types. You want to create an analytic view for only one of the transaction types. How can you ensure that only rows with the required transaction type are displayed in the analytic view?

A. Create an input parameter

B. Create a filter on the table

C. Create a calculated column

D. Create a restricted column

Answer: B

QUESTION: 364

Which of the following nodes can you use when you create a calculation view with the SAP HANA studio graphical interface?
Note: There are multiple correct answers to the question

A. Data Foundation

B. Aggregation

C. Join

D. Analytic Privilege

Answer: B, C

QUESTION: 365

When table replication is suspended, what does the SAP Landscape Transformation (SLT) server do?

A. It prevents the RFC connection from reading the source system logging tables

B. It deletes the database triggers and the logging tables in the source system

C. It stops the RFC connection and deletes the target tables in SAP HANA

D. It keeps reading via the RFC connection from the source system but does not load the data into SAP HANA

Answer: A

QUESTION: 366

You have set up replication from SAP ERP using SAP Landscape Transformation (SLT). You notice that the information models do not show the latest data from ERP. What do you check to investigate this?
Note: There are multiple correct answers to the question

A. Activation status of the information models 

B. Transaction SAP ERP Data Modeler (SD11)

C. Transaction LTR on SLT

D. Data Provisioning view in SAP HANA studio

Answer: C, D

QUESTION: 367

You create a business layer in the SAP BusinessObjects Information Design Tool (IDT). Which of the following could you add to the data foundation?
Note: There are multiple correct answers to the question

A. Packages 

B. Column Tables

C. Synonyms

D. Information Models

Answer: B, D

QUESTION: 368

You implemented SAP-delivered business content on SAP HANA. When you try to activate the business content the activation fails. What could be a reason for this?

A. You have not created a calculation view to expose the data to the users

B. The data has not been loaded into SAP HANA memory yet

C. The schema mapping was not set up correctly

D. The import of business content was performed with the _SYS_REPO user

Answer: C

QUESTION: 369

You want to allow another developer to access the information models in one of your packages. What privilege do you have to assign to this user to allow access?

A. SELECT on _SYS_REPO

B. SELECT on _SYS_REPO with the grant option

C. REPO.READ for the package

D. REPO.MAINTAIN_NATIVE_PACKAGES for the package

Answer: C

QUESTION: 370

Which data provisioning method can you use to load data from SAP business content DataSources into SAP HANA?
Note: There are multiple correct answers to the question

A. SAP Landscape Transformation (SLT) 

B. SAP Landscape Directory (SLD)

C. SAP Direct Extractor Connection (DXC)

D. SAP BusinessObjects Data Services

Answer: C, D