EMT Practice Test

1. Question Content...

---

Question1: You want to control parallelization in a calculation view. Which action is mandatory when you define the parallelization block?

Question2: What does SAP HANA provide to support native application development
Note: There are 3 correct answers.

Question3: What are the components of a graph workspace?
Note: There are 2 correct answers to this question.

Question4: Why do you use a hierarchy function node in a calculation view?

Question5: In text processing, where do you use the Term Document Matrix?

Question6: You have a calculation view which includes nodes as shown in the graphic. You decide to select the "Ignore Multiple Output for Filters" check box on Projection Node 3. What might the effects of this be?
Note: There are 2 correct answers to this question.

Question7: Which types of data are used to represent spatial information?
Note: There are 2correct answers to this question.

Question8: When you create a full text index, why do you specify FAST_PREPROCESS OFF?

Question9: How can you optimize performance when writing SQL for use with calculation views?
Note: There are 2 correct answers to this question.

Question10: In SAP HANA Series Data, which of the following methods do you use to convert finer interval readings to a coarser interval?

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

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: Which of the following results are generated when you query this temporal hierarchy using a time-validity period interval of March to May?

Question14: Which is the correct syntax when you refer to an input parameter in a calculation view expression?

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

Question16: Why do you use the debug query mode in a calculation view?

Question17: Why might you use SAP HANA Graph with text analysis?

Question18: Which of the following approaches improve the performance of joins in a cube calculation view? Note: There are 2 correct answers to this question.

Question19: 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 one table located in an external schema. Which of the following items must you build?
Note: There are 2 correct answers to this question.

Question20: You are querying a calculation view based on the union node, as shown in the graphic. When would the value of the Empty Union Behavior property take effect?
Note: There are 2 correct answers to this question.

Question21: What can you extract using the standard text analysis configuration: Voice of the Customer? Note: There are 2 correct answers to this question.

Question22: What does a graph neighborhood search reveal?

Question23: When using the CONTAINS predicate, what are the restrictions you must keep in mind? Note: There are 2 correct answers to this question.

Question24: When would you develop an SQL procedure instead of a function?

Question25: In SAP Web IDE for SAP HANA, what can a flowgraph generate in a predictive analysis scenario?
Note: There are 2 correct answers to this question.

Question26: You created a table function to remove previous records, sum the current total weekly working hours for each employee, and updated the personnel table. The build of the table function fails.
Which of the following could be a valid reason?

Question27: In which of the following scenarios would you benefit from enabling table partitioning in SAP HANA?

Question28: You are a data analyst working with medical records that contain confidential patient information. Why do you use the anonymization node in a calculation view?
Note: There are 2 correct answers to this question.