問題1
How can you analyze a performance issue in the execution of an SQL statement using the SQL Console? (Choose two)
How can you analyze a performance issue in the execution of an SQL statement using the SQL Console? (Choose two)
正確答案: A,D
問題2
What is the purpose of a template table in SAP BusinessObjects Data Services?
What is the purpose of a template table in SAP BusinessObjects Data Services?
正確答案: A
問題3
Which of the following properties of a derived attribute view can you modify?
Which of the following properties of a derived attribute view can you modify?
正確答案: D
問題4
Which of the following must an analytic view contain?
Which of the following must an analytic view contain?
正確答案: D
問題5
You need to create an SAP HANA data model based on a star schema. Which SAP HANA engine is recommended for analytical purposes?
You need to create an SAP HANA data model based on a star schema. Which SAP HANA engine is recommended for analytical purposes?
正確答案: D
問題6
You have 2 SAP HANA systems. You are working in 1 of these systems.
Which of the following do you use to read data from and write data to the other, remote SAP HANA system? (Choose two)
You have 2 SAP HANA systems. You are working in 1 of these systems.
Which of the following do you use to read data from and write data to the other, remote SAP HANA system? (Choose two)
正確答案: A,B
問題7
Which CE function do you use to implement the following SQL statement?
SELECT DATE, SHOPJD, PRODUCTJD, QUANTITY * COST AS "PRICE" FROM SALES_DATA;
Which CE function do you use to implement the following SQL statement?
SELECT DATE, SHOPJD, PRODUCTJD, QUANTITY * COST AS "PRICE" FROM SALES_DATA;
正確答案: A
問題8
What is the lowest level of granularity you can use in an analytic privilege?
What is the lowest level of granularity you can use in an analytic privilege?
正確答案: A
問題9
Which of the following nodes can you use when you create a calculation view with the SAP HANA studio graphical interface?
Which of the following nodes can you use when you create a calculation view with the SAP HANA studio graphical interface?
正確答案: C,D
問題10
You want to load a large amount of source data (more than one billion rows) into SAP HANA for read-intensive information models. Which table type is recommended for this scenario?
You want to load a large amount of source data (more than one billion rows) into SAP HANA for read-intensive information models. Which table type is recommended for this scenario?
正確答案: C
問題11
Which of the following tools can you use to monitor the query time from SAP HANA?
Which of the following tools can you use to monitor the query time from SAP HANA?
正確答案: B
問題12
Which of the following SAP HANA schemas contains the runtime objects of activated views?
Which of the following SAP HANA schemas contains the runtime objects of activated views?
正確答案: A
問題13
You have created two analytic views for actual and planned financial data. 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?
You have created two analytic views for actual and planned financial data. 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
問題14
Which of the following are mandatory to create a decision table? (Choose two)
Which of the following are mandatory to create a decision table? (Choose two)
正確答案: C,D
問題15
Which tasks can you perform with the data provisioning view in the SAP HANA studio?
Which tasks can you perform with the data provisioning view in the SAP HANA studio?
正確答案: C,D