SAP C-HANAIMP-17 Practice Test Pdf Exam Material
C-HANAIMP-17 Answers C-HANAIMP-17 Free Demo Are Based On The Real Exam
NEW QUESTION 45
In a calculation view, what should you consider when you create an input parameter that derives its value from a user-defined function?
There are 2 correct answers to this question.
Response:
- A. The function can return multiple values.
- B. The input parameter must be set to mandatory.
- C. The generated value can be overwritten at runtime.
- D. The function must be of the type scalar.
Answer: C,D
NEW QUESTION 46
A column table definition includes a spatial column that has the VALIDATION FULL property. You execute an SQL statement to insert a geometry into this column. The statement fails.
Which of the following are possible reasons for the failure?
There are 2 correct answers to this question.
Response:
- A. The geometry is an ST_POLYGON that has an inner ring that is completely inside the outer ring.
- B. The geometry is an ST_POLYGON where the last defined point is not the same as the first one.
- C. The geometry is an ST_MULTIPOLYGON that specifies only one polygon.
- D. The geometry is an ST_MULTIPOLYGON where the second polygon is completely contained in the first one.
Answer: B,D
NEW QUESTION 47
Which technologies does SAP HANA use to load more data into memory?
There are 3 correct answers to this question.
Response:
- A. Use dictionary compression
- B. Eliminate indices
- C. Use multicore CPU parallelism
- D. Use ZIP compression
- E. Store data in column tables
Answer: A,B,E
NEW QUESTION 48
You want to map an input parameter of the calculation view A to the input parameter of calculation view B using the parameter mapping feature in the calculation view editor. However, the input parameter of the calculation view B is not proposed to you as a source parameter.
What might be the reason for this?
- A. Your source calculation view is of the type SQL Access Only.
- B. You selected the wrong parameter mapping TYPE.
- C. You already mapped the input parameters in another calculation view.
- D. The names of the input parameters do not match.
Answer: C
NEW QUESTION 49
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?
- A. Combine the transaction tables using a join node in a calculation view of type cube with star join.
Use a star join node to join the dimensions to the fact table. - B. Combine the transaction tables using a join node in a calculation view of type cube.
Use the multi-join capability of the join node to connect the transactional tables with the dimension calculation views. - C. Combine the transaction tables using a star join node in a calculation view of type cube with star join.
Use a join node to join the dimensions to the fact table. - D. Combine the transaction tables using an aggregation node in a calculation view of type cube with star join.
Use a star join node to join the dimensions to the fact table.
Answer: A
NEW QUESTION 50
How should you create a procedure?
Please choose the correct answer.
Response:
- A. Create a design-time object in a SQL console
- B. Create a runtime object in a HANA project
- C. Create a runtime object in the SQL console.
- D. Create a design-time object in a HANA project.
Answer: D
NEW QUESTION 51
Which sentence best describes SAP HANA Live?
Please choose the correct answer.
Response:
- A. Operational reporting moving back to the OLTP system
- B. Operational reporting moving back to the OLAP system
- C. Analytical reporting moving back to the OLTP system
- D. Analytical reporting moving back to the OLAP system
Answer: A
NEW QUESTION 52
In SAP HANA Studio, what would you find in a Package?
There are 3 correct answers to this question.
Response:
- A. Analytic Privileges
- B. Calculation Views
- C. Procedures
- D. Tables
Answer: A,B,C
NEW QUESTION 53
Why did SAP move from XS to XSA?
There are 2 correct answers to this question.
Response:
- A. To provide better source code management tools inside SAP HANA
- B. To include ABAP as a key development language for native SAP HANA applications
- C. To move to Cloud Foundry architecture to allow flexible application deployment options
- D. To implement micro-services architecture
Answer: C,D
NEW QUESTION 54
Using a calculation view containing the projections shown in the graphic, how would you identify which companies sold products in January 2018 AND February 2018?
Please choose the correct answer.
Projection Sales January 2018
Projection Sales February 2018
Company Product Quantity Company Product Quantity
Response:
- A. Use a left outer join
- B. User an intersect node
- C. Use a union node
- D. Use a full outer join
Answer: C
NEW QUESTION 55
In which of the following scenarios would you benefit from enabling table partitioning in SAP HANA?
- A. You have a large row store table that is consumed in a view with a variable on COUNTRY column.
- B. You have a large column store table that is consumed in a view with a variable on COUNTRY column.
- C. You have a dedicated table lo generate the lists of help values for an input parameter.
- D. Your stacked model consists of multiple calculation views.
Answer: B
NEW QUESTION 56
When do you use the hidden attribute in a dimension calculation view?
Please choose the correct answer.
Response:
- A. When you want to hide an attribute that is not required for client consumption.
- B. When you need to include the attribute in your calculation view to define a join.
- C. When you want to include an attribute that is not required for cube consumption.
- D. When you want to hide the attribute in your cube calculation view.
Answer: A
NEW QUESTION 57
Which of the following are no longer required in the architecture of SAP S/4HANA?
There are 2 correct answers to this question.
Response:
- A. Indexes
- B. Synonyms
- C. Column tables
- D. Aggregates
Answer: B,D
NEW QUESTION 58
What spatial data type would you use to store multiple shop locations?
Please choose the correct answer.
Response:
- A. ST_Polygon
- B. ST_Point
- C. ST_MultiPoint
- D. ST_MultiLineString
Answer: C
NEW QUESTION 59
In SAP Web IDE for SAP HANA, which of the following tasks do you need to complete before you can build the SAP HANA database (HDB) module successfully?
There are 2 correct answers to this question.
Response:
- A. Explicitly build the HDB module instead of the project
- B. Assign the project to a space to which you have developer authorizations
- C. Ensure that the name of your HDB module is included in the corresponding schema names
- D. Ensure that you have only one HDB module in your project
Answer: B,C
NEW QUESTION 60
In a calculation view, what is the purpose of a variable?
Please choose the correct answer.
Response:
- A. To capture the interim result of a calculation in an expression
- B. To provide a run-time attribute filter based on a user input
- C. To pass values between procedures and calculation views
- D. To break up complex SQL into smaller steps
Answer: B
NEW QUESTION 61
You create a hierarchy in a dimension calculation view. You then consume this dimension calculation view with star join in a cube calculation view. How do you allow SQL access to the hierarchy?
Response:
- A. 1.Enable SQL access in the view properties of the dimension calculation view.
2.Obtain generated node names in shared hierarchies. - B. 1.Enable SQL access in the view properties of the dimension calculation view.
2.Obtain generated node names in local hierarchies. - C. 1.Enable SQL access in the view properties of the cube calculation view with star join.
2.Obtain generated node names in local hierarchies. - D. 1.Enable SQL access in the view properties of the cube calculation view with star join.
2.Obtain generated node names in shared hierarchies.
Answer: D
NEW QUESTION 62
To maintain good read performance in a constantly changing database, which two components are used?
There are 2 correct answers to this question.
Response:
- A. Delta storage
- B. Column store
- C. Memory store
- D. Main storage
Answer: A,D
NEW QUESTION 63
What are features of Business Suite on SAP HANA?
There are 2 correct answers to this question.
Response:
- A. Combine operational analytics and transaction processin
- B. Massive performance improvement
- C. Embedded Analytics
- D. ABAP is replaced with JAVA
Answer: A,B
NEW QUESTION 64
In a calculation view of type cube with star join, you want to join three dimensions to the facts. Two of the dimensions use full outer joins and one dimension uses a left outer join. You did NOT set cardinality of the data sources. Why will this NOT work?
- A. Full outer joins require cardinality to beset.
- B. Full outer joins CANNOT be mixed in the same star join node with other join types.
- C. Full outer joins are NOT available in the star join node.
- D. Full outer joins are restricted to one dimension in a star join node.
Answer: D
NEW QUESTION 65
......
C-HANAIMP-17 [Sep-2022] Newly Released] Exam Questions For You To Pass: https://www.prep4surereview.com/C-HANAIMP-17-latest-braindumps.html
