[Oct 22, 2021] C-HANAIMP-17 Dumps Full Questions - Exam Study Guide
SAP Certified Application Associate Free Certification Exam Material from PassLeaderVCE with 82 Questions
NEW QUESTION 46
What do you have to assign to users to allow Single Sign-On (SSO)?
Please choose the correct answer.
Response:
- A. SQL analytic privileges
- B. Kerberos authentication
- C. Application privileges
- D. TRUST ADMIN system privilege
Answer: B
NEW QUESTION 47
You want to call a procedure in a SELECT statement (e.g., a table function). Which clauses do you have to specify?
There are 2 correct answers to this question.
Response:
- A. LANGUAGE SQLSCRIPT
- B. READS SQL DATA
- C. WITH RESULTS VIEW
- D. SEQUENTIAL EXECUTION
Answer: B,C
NEW QUESTION 48
In which programming languages can you create procedures in SAP HANA?
There are 2 correct answers to this question.
Response:
- A. SQLScript
- B. L
- C. JavaScript
- D. R
Answer: A,D
NEW QUESTION 49
What spatial data type would you use to store multiple shop locations?
Please choose the correct answer.
Response:
- A. ST_Polygon
- B. ST_MultiPoint
- C. ST_MultiLineString
- D. ST_Point
Answer: B
NEW QUESTION 50
What are features of Business Suite on SAP HANA?
There are 2 correct answers to this question.
Response:
- A. Embedded Analytics
- B. ABAP is replaced with JAVA
- C. Massive performance improvement
- D. Combine operational analytics and transaction processin
Answer: C,D
NEW QUESTION 51
When modeling in the Web ID for SAP HANA, which object do you build to provide access to tables in external schemas?
Please choose the correct answer.
Response:
- A. Role
- B. Analytic privilege
- C. Container
- D. Synonym
Answer: D
NEW QUESTION 52
What is the recommended way to create full-text indexes?
Please choose the correct answer.
Response:
- A. Procedures
- B. Core Data Services
- C. SQL statements in the SQL console
- D. User-defined functions
Answer: B
NEW QUESTION 53
Which business intelligence tool can publish storyboards?
Please choose the correct answer.
Response:
- A. SAP BusinessObjects Analysis, edition for Microsoft Office
- B. SAP Analysis for Microsoft Office
- C. SAP Lumira, designer edition
- D. SAP BusinessObjects Web Intelligence
Answer: B
NEW QUESTION 54
What is a multistore table?
Please choose the correct answer.
Response:
- A. A table that can hold data in row and column orientation
- B. A table that can distribute its partitions across memory and extended storage tiers
- C. A table that can be shared across multiple instances of HANA
- D. A table that can be shared across multiple instances of SAP HANA Cockpit
Answer: B
NEW QUESTION 55
What can you extract using the standard text analysis configuration: Voice of the Customer?
There are 2 correct answers to this question.
Response:
- A. Sentiments
- B. Suggestions
- C. Recommendations
- D. Requests
Answer: A,D
NEW QUESTION 56
You created a user-defined function with a return type of BIGINT. What type of function have you created?
Please choose the correct answer.
Response:
- A. SQL function
- B. Table function
- C. Scalar function
- D. Window function
Answer: C
NEW QUESTION 57
What are features of SAP S/4HANA?
There are 2 correct answers to this question.
Response:
- A. Embedded Analytics
- B. SAP HANA Live provides real time operational analytics
- C. Optimized for SAP HANA but maintains compatibility with other platforms
- D. Rewritten ABAP code optimized for SAP HANA
Answer: A,D
NEW QUESTION 58
Which deployment scenarios feature security staying in the application server and end users not logging in to the SAP HANA system?
There are 2 correct answers to this question.
Response:
- A. SAP HANA as a side-by-side accelerator
- B. SAP HANA as a database
- C. SAP HANA as a platform with an SAP HANA XS application
- D. SAP HANA as a reporting server
Answer: B,D
NEW QUESTION 59
Which join type makes use of date ranges?
Please choose the correct answer.
Response:
- A. Spatial join
- B. Temporal join
- C. Text join
- D. Inner join
Answer: B
NEW QUESTION 60
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 61
The company asks you to get data from IoT sensors. Which SAP tools could you use?
There are 3 correct answers to this question.
Response:
- A. SAP Landscape Transformation Replication Server
- B. SAP HANA Remote Data Sync (RDSync)
- C. SAP SQL Anywhere
- D. SAP HANA smart data access (SDA)
- E. SAP HANA streaming analytics
Answer: B,C,E
NEW QUESTION 62
Which of the following techniques can you use to improve the performance of calculation views?
There are 2 correct answers to this question.
Response:
- A. Partition large tables
- B. Minimize layering of calculation views
- C. Avoid aggregating data early in the data flow
- D. Implement union pruning
Answer: B,D
NEW QUESTION 63
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 64
In a calculation view, what is the purpose of a variable?
Please choose the correct answer.
Response:
- A. To provide a run-time attribute filter based on a user input
- B. To break up complex SQL into smaller steps
- C. To capture the interim result of a calculation in an expression
- D. To pass values between procedures and calculation views
Answer: A
NEW QUESTION 65
Which storage is required if you implement multistore tables for SAP HANA?
Please choose the correct answer.
Response:
- A. Remote storage
- B. Nearline storage
- C. Extended storage
- D. Delta storage
Answer: C
NEW QUESTION 66
To what subset of SQL does the SELECT statement belong?
Please choose the correct answer.
Response:
- A. DCL
- B. DQL
- C. DDL
- D. DML
Answer: B
NEW QUESTION 67
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 68
What do you create to find the number of unique items sold per shop?
Please choose the correct answer.
Response:
- A. A calculation view with a counter in a Projection node
- B. A calculation view with a counter in an Aggregation node
- C. An analytic view with a calculated column in a Star Join node
- D. A calculation view with a restricted column in an Aggregation node
Answer: B
NEW QUESTION 69
Which of the following database terms are used when providing OLAP data with hierarchies?
There are 3 correct answers to this question.
Response:
- A. ODBC
- B. JDBC
- C. MDX
- D. BICS
- E. ODBO
Answer: C,D,E
NEW QUESTION 70
......
Dumps Brief Outline Of The C-HANAIMP-17 Exam: https://www.passleadervce.com/SAP-Certified-Application-Associate/reliable-C-HANAIMP-17-exam-learning-guide.html