EMT Practice Test

1. Question Content...

Previous Submit Next
Was this helpful? Upvote!
Question List

Question1: Why would you partition a table in an SAP HANA database? Note: There are 2 correct answers to this question.

Question2: You are deploying a new calculation view, A, that uses calculation view B, as shown in the diagram. When you preview calculation view A, the account number is not masked.
What could be the reason?

Question3: Which type of join supports a temporal condition in a calculation view?

Question4: What are some of the restrictions that apply when defining parallelization blocks in calculation views? Note: There are 2 correct answers to this question.

Question5: What is the purpose of a remote subscription?

Question6: You are creating a procedure to be consumed in a DYNAMIC analytic privilege. What must you consider? Note: There are 2 correct answers to this question.

Question7: When you build/deploy a flowgraph, what can be generated? Note: There are 3 correct answers to this question.

Question8: Referring to the diagram, which privileges would a user require to view United States data when querying the CUBE calculation view?

Question9: Your calculation view consumes one data source, which includes the following columns: SALES_ORDER_ID, PRODUCT_ID, QUANTITY and PRICE.
In the output, you want to see summarized data by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY PRICE. In which type of node do you define the calculation to display the correct result?

Question10: What are the characteristics of a SHARED replica table? Note: There are 3 correct answers to this question.

Question11: Why would you use the Transparent Filter property in a calculation view?

Question12: Which of the following techniques can you use to improve the performance of calculation views? Note: There are 2 correct answers to this question.

Question13: Why might you use the Keep Flag property in an aggregation node?

Question14: You import a project that includes an SAP HANA database (HDB) module to your workspace. You need to create a calculation view that uses data from a table located in an external schema within the same local database.
Which of the following items do you need? Note: There are 2 correct answers to this question.

Question15: What privileges do you need to create a virtual table referencing a remote SAP HANA table? Note: There are 2 correct answers to this question.

Question16: You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deployment of the table function fails.
Which of the following could be a valid reason?

Question17: Why would you use an anonymous block when writing SQLScript?

Question18: In a calculated column, which object do you use to process a dynamic value in an expression?

Question19: Why do you use parameter mapping in a calculation view? Note: There are 2 correct answers to this question.

Question20: In a data source node of a flowgraph, in addition to tables and views, which other objects can you define as the data source? Note: There are 3 correct answers to this question.

Question21: What are the limitations of using a full outer join in a star join node? Note: There are 2 correct answers to this question.

Question22: Which of the following are characteristics of the OPTIMIZED linked database feature? Note: There are 2 correct answers to this question.

Question23: How can you define a variable that presents its value help hierarchically? Note: There are 2 correct answers to this question.

Question24: In a calculation view, why would you implement an SQL expression? Note: There are 3 correct answers to this question.

Question25: In a flowgraph, which node do you use to select only the required columns from a data source and to filter specific rows?

Question26: You create a user-provided service to access tables in external schemas.
In which file type do you assign the user-provided service to your database module?

Question27: Why would you implement SQL in calculation views? Note: There are 2 correct answers to this question.

Question28: What is a calculation view query snapshot?

Question29: In a calculation view, your table function node executes a table function that requires input parameters.
How can you fill the input parameters of the table function? Note: There are 3 correct answers to this question.

Question30: Why do you nest flowgraphs? Note: There are 2 correct answers to this question.

Question31: You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. DIMENSION calculation views provide the attributes.What is the correct approach?

Question32: What are the limitations of using a full outer join in a star join node? Note: There are 2 correct answers to this question.

Question33: You have products that appear in table A and sometimes also in table B. What would you use to find products only appearing in table A?

Question34: Your flowgraphs defines a template table as a data target. What triggers the generation of the template table?

Question35: Which project structure object corresponds to a unique HDI container?

Question36: What is a restricted measure?