SAP C-HANAIMP-17 Practice Verified Answers - Pass Your Exams For Sure! [2021]
Valid Way To Pass SAP Certified Application Associate's C-HANAIMP-17 Exam
NEW QUESTION 20
Why do you create a time dimension calculation view?
Please choose the correct answer.
Response:
- A. To enable time dependency on parent-child hierarchies
- B. To support temporal joins in a cube calculation view with star schema
- C. To provide date-based help values for a DIRECT type input parameter
- D. To enhance a calculation view with a drilldown on a time hierarchy
Answer: D
NEW QUESTION 21
Referring to the diagram which privileges would a user require to view United States data when querying the CUBE Calculation view?
Please choose the correct answer.
Response:
- A. ASELECT privilege and an analytic privilege (Country = United States) on the DIMENSION calculation view
- B. A SELECT privilege on the CUBE and an analytic privilege (Country = United States) on the DIMENSION calculation view
- C. SELECT privileges and Analytic Privileges on both views
- D. Analytic Privilege and SELECT privilege on the CUBE calculation view
Answer: B
NEW QUESTION 22
Which of the following data provisioning tools can provide a delta load of a table from the source system?
Please choose the correct answer.
Response:
- A. SAP Landscape Transformation Replication Server
- B. Flat files
- C. SAP HANA streaming analytics
- D. SDA
Answer: A
NEW QUESTION 23
You have a table with two columns, CUSTOMER NAME and COUNTRY NAME, In which Italian customers are stored. You have an identical table in which you store French customers.
What type of calculation view should you create to combine the customers in to two columns that mirror the structure of the sources tables?
Please choose the correct answer.
Response:
- A. Calculation view of cube type with a join node
- B. Calculation view of cube type with a union node
- C. Calculation view of dimension type with a union node
- D. Calculation view of dimension type with a join node
Answer: C
NEW QUESTION 24
What should you keep in mind when using dynamic SQL?
There are 2 correct answers to this question.
Response:
- A. It could be used for SQL injection.
- B. It delivers the best possible performance.
- C. You can dynamically change your data sources.
- D. It's always bad for security.
Answer: A,C
NEW QUESTION 25
What node can you use for sorting results, for example, to show the top 100?
Please choose the correct answer.
Response:
- A. Rank node
- B. Aggregation node
- C. Projection node
- D. Union node
Answer: A
NEW QUESTION 26
How many tiers do you usually find in an SAP HANA application?
There are 2 correct answers to this question.
Response:
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B,D
NEW QUESTION 27
You're given an old government paper form with lines, blocks, and fields. You're asked to create a report that looks like this form.
Which business intelligence tools do you use?
Please choose the correct answer.
Response:
- A. SAP Crystal Reports for Enterprise
- B. SAP Lumira, designer edition
- C. SAP Lumira, discovery edition
- D. SAP BusinessObjects Web Intelligence
Answer: A
NEW QUESTION 28
What performance techniques should you implement to improve the performance of SAP HANA information views?
There are 3 correct answers to this question.
Response:
- A. Apply filters as late as possible.
- B. Investigate partitioning of large tables.
- C. Minimize the transfer of data between the execution engines.
- D. Perform calculation before aggregation in your analytic views.
- E. Push down aggregations to SAP HANA.
Answer: B,C,E
NEW QUESTION 29
In a text-type fuzzy search I enter 'SAP' as the search word. Against term 'SAPPHIRE' will I get a high or low score?
Please choose the correct answer.
Response:
- A. High
- B. Low
- C. Medium
- D. Normal
Answer: B
NEW QUESTION 30
What are features of SDA?
There are 2 correct answers to this question.
Response:
- A. Data cleansing
- B. Evaluation and execution of push down possibilities to remote sources
- C. Merging data from multiple sources
- D. Automatic data type translation
Answer: B,D
NEW QUESTION 31
In SAP Web IDE for SAP HANA, what can a flow graph generate in a predictive analysis scenario?
There are 2 correct answers to this question
Response:
- A. Task
- B. Container
- C. Procedure
- D. Function
Answer: C,D
NEW QUESTION 32
Which interface client is used for XSA application development?
Please choose the correct answer.
Response:
- A. SAP Web IDE for SAP HANA
- B. SAP HANA Web-based Workbench
- C. SAP Web IDE
- D. SAP HANA Studio
Answer: A
NEW QUESTION 33
What information can you find in the SAP HANA Cockpit?
There are 2 correct answers to this question.
Response:
- A. List of operators
- B. Trace and log files
- C. SQL Plan Cache
- D. SQL generated in each step
Answer: B,C
NEW QUESTION 34
Which recent technology advances have made SAP HANA possible?
There are 2 correct answers to this question.
Response:
- A. Larger and cheaper memory
- B. Faster internet speeds
- C. Faster disk speeds
- D. Multicore processors
Answer: A,D
NEW QUESTION 35
What enables the delta buffer technique to speed up both reads and inserts in SAP HANA?
Please choose the correct answer.
Response:
- A. Using column-based tables only
- B. Using both row-based and column-based tables
- C. Using only the insert-only technique
- D. Using row-based tables only
Answer: B
NEW QUESTION 36
Which of the following approaches can be used to implement union pruning?
There are 2 correct answers to this question.
Response:
- A. Define a constant value for each data source in the Union node.
- B. Define a restricted column and include it in both data sources of a union.
- C. Define the cardinality between the data sources.
- D. Define union pruning conditions in a pruning configuration table.
Answer: A,D
NEW QUESTION 37
Where do you use SQLScript outside of the development environment discussed in this chapter?
There are 3 correct answers to this question.
Response:
- A. Creating tables
- B. Calculation views
- C. Text analytics
- D. Security
- E. Reporting tools
Answer: B,C,D
NEW QUESTION 38
What are components of SAP HANA EIM?
There are 2 correct answers to this question.
Response:
- A. SDI
- B. SDS
- C. SDQ
- D. SDA
Answer: A,C
NEW QUESTION 39
How does SQL Script extend SQL?
There are 3 correct answers to this question.
Response:
- A. It allows an alternative syntax to simplify expressions.
- B. It provides the data definition language (DDL) to create column tables.
- C. It adds imperative expressions to control data flow.
- D. It improves push-down opportunities.
- E. It enables usage of variables to break up complex code.
Answer: B,C,E
NEW QUESTION 40
What should you use to create tables in an HDI container?
There are 2 correct answers to this question.
Response:
- A. Core Data Services (CDS)
- B. Database Explorer
- C. SAP Enterprise Architecture Designer
- D. SQL Console
Answer: A,C
NEW QUESTION 41
......
SAP C-HANAIMP-17 Pre-Exam Practice Tests | Actual4Labs: https://www.actual4labs.com/SAP/C-HANAIMP-17-actual-exam-dumps.html