SAP HANA: Certification Questions 341 through 350

QUESTION: 341

You want to broadcast reports that use data from SAP HANA. Which SAP BusinessObjects tool do you use? 

A. Analysis, edition for OLAP

B. Dashboards 

C. Crystal Reports

D. Explorer 

Answer: C

QUESTION: 342

What can be used as a source for the data foundation of an analytic view? 
Note: There are multiple correct answers to the question

A. A table that contains surrogate IDs referring to primary keys in the attribute views

B. A table that contains foreign keys referring to primary keys in the attribute views

C. A table that contains business facts or measures

D. A table that contains only descriptive attributes 

Answer: B, C

QUESTION: 343

If you want to create or drop tables in a schema, which privilege type do you need?

A. SYSTEM 

B. ANALYTIC 

C. PACKAGE 

D. SQL 

Answer: D

QUESTION: 344

Which SAP BusinessObjects reporting tool should you use to answer ad-hoc questions and interact with shared information? 

A. Crystal Reports

B. Dashboards 

C. Explorer 

D. WebIntelligence 

Answer: D

QUESTION: 345

How can you assess the quality of the loaded data in SAP HANA?

A. Configure the SAP Landscape Transformation tool to implement the data quality process

B. Compare data from reports in SAP BusinessObjects against the SAP HANA _SYS_STATISTICS table

C. Perform master data quality checks in SAP ERP prior to replication in SAP HANA

D. Compare reports in SAP BusinessObjects against source data for specific selections

Answer: C, D

QUESTION: 346

What are the advantages of using SAP BusinessObjects Data Services to load data into SAP HANA?
Note: There are multiple correct answers to the question

A. You can load unstructured data into SAP HANA

B. You can merge data streams

C. You can use the same hardware

D. You can perform real-time data replication
E. You can use BI Content extractors or function modules

Answer: A, B, E

QUESTION: 347

In the SAP HANA studio, which of the following SQL thread details can you monitor by using the Threads sub-tab of the Performance tab of the Administration editor?
Note: There are multiple correct answers to the question

A. The SQL statement

B. The generated data

C. The service name

D. The blocking status
E. The visual execution plan

Answer: B, C, D

QUESTION: 348

Which of the following can you determine using the Backup catalog report?
Note: There are multiple correct answers to the question

A. The path for the backup files

B. Whether a recovery is possible

C. Which backup files are obsolete

D. When to execute the net backup

Answer: B, C

QUESTION: 349

Your SAP HANA database performs slowly. Which of the following might be reasons for the performance decrease?
Note: There are multiple correct answers to the question

A. Many replication jobs are running

B. Backup jobs are running

C. Too many information models have been created

D. Large tables are updated with frequent delta merges

Answer: A, D

QUESTION: 350

Which column do you use to identify long-running SQL statements within the SQL Plan Cache view?

A. TOTAL_EXECUTION_OPEN_TIME

B. AVG_EXECUTION_OPEN_TIME

C. TOTAL_EXECUTION _TIME

D. AVG_EXECUTION_TIME

Answer: D