C_HANAIMP_12 Exam Questions
197 real C_HANAIMP_12 exam questions with expert-verified answers and explanations. Page 2 of 4.
- Question #51
You build a financial report for the company's board members that allows them to choose if they want the report to be in euros or dollars. What do you use? Please choose the correc...
- Question #52
What statement do you have to run before you can return table results from a procedure? Please choose the correct answer.
- Question #53
In which subfolder of the _SYS_BIC schema do you find activated information models? Please choose the correct answer. Response:
- Question #54
You execute the performance validations for a calculation view. Which columns are checked by the 'Calculation in filter expression' rule? Please choose the correct answer. Response...
- Question #55
What is the preferred way to create a procedure? Please choose the correct answer. Response:
- Question #56
What does the migration tool allow you to migrate? Please choose the correct answer.
- Question #57
Which type of cloud solution is Amazon Web Services (AWS) an example of? Please choose the correct answer. Response:
- Question #58
The Data Provisioning Monitor provides a browser based interface to monitor agents, tasks, design time objects (flowgraphs and replication tasks), and remote subscriptions created...
- Question #59
Which SAP HANA studio function displays the views that will be affected when you rename an attribute view? Please choose the correct answer.
- Question #60
You have to build a parent璫hild hierarchy. What type of join do you expect to use? Please choose the correct answer.Response:
- Question #61
Which types of calculation views can you create? There are 2 correct answers to this question.
- Question #62
What performance technique should you implement to improve join performance? Please choose the correct answer. Response:
- Question #63
What can a variable be used for? Please choose the correct answer. Response:
- Question #64
Which business intelligence tools use BICS connectivity to SAP HANA? There are 2 correct answers to this question. Response:
- Question #65
What is the correct sequence for loading data with SAP Data Services? Please choose the correct answer. Response:
- Question #66
Which of the following are reasons you should use Core Data Services (CDS) to create a schema? There are 2 correct answers to this question. Response:
- Question #67
You have logs from a website. How do you show the total number of website visitors that used a mobile phone? There are 2 correct answers to this question. Response:
- Question #68
You want to reuse a decision table on multiple tables with a similar data structure. You design the decision table that passes a specific table name as an input parameter when you...
- Question #69
Which actions does refactoring typically use? There are 2 correct answers to this question. Response:
- Question #70
When do you always have both an active and an inactive version of an infor- mation model available in the SAP HANA development system? Please choose the correct answer. Response:
- Question #71
What information can you find in the Visualize Plan tool? There are 2 correct answers to this question. Response:
- Question #72
What happens when you activate an information model? ? There are 2 correct answers to this question. Response:
- Question #73
You want to use a web-based transport system on your Apple iPad. What tool do you use? Please choose the correct answer. Response:
- Question #74
You are writing SQLScript code for handling sensitive data. What statement is prone to the SQL injection? Please choose the correct answer. Response:
- Question #75
Which spatial data formats can you import into SAP HANA? There are 2 correct answers to this question. Response:
- Question #76
What technique is used to convert record updates into insert statements in the delta buffer? Please choose the correct answer.
- Question #77
Which of the following SAP data provisioning tools can provide real-time data provisioning? There are 3 correct answers to this question.
- Question #78
Which deployment scenario can you use to accelerate reporting from an old SAP R/3 4.6C system? Please choose the correct answer. Response:
- Question #79
What should you keep in mind when using dynamic SQL? There are 2 correct answers to this question. Response:
- Question #80
What system privilege do you need to create a delivery unit? Please choose the correct answer. Response:
- Question #81
Which of the following statements describe a standard SAP system land- scape used for transports? Please choose the correct answer.
- Question #82
Which of the following data provisioning tools can you use to read data directly from Twitter? There are 3 correct answers to this question.
- Question #83
What can you use to limit users to see only 2016 data? There are 2 correct answers to this question. Response:
- Question #84
What can you use to limit the number of records produced by a calculation view? There are 3 correct answers to this question. Response:
- Question #85
In which sequence is SAP ERP data exposed to a reporting tool using SAP HANA Live? Please choose the correct answer. Response:
- Question #86
What type of load does SAP HANA perform when starting up? Please choose the correct answer. Response:
- Question #87
What is the recommended way to create full-text indexes going forward? Please choose the correct answer. Response:
- Question #88
You want to retrieve data from a web application. Which of the following could you use? There are 3 correct answers to this question.
- Question #89
A referential join gives the same results as which other join type? Please choose the correct answer. Response:
- Question #90
You need a business intelligence tool that is Microsoft Excel-based and can use parent- child hierarchies. Which tool do you use? Please choose the correct answer. Response:
- Question #91
In which SAP HANA deployment scenarios will end users be created as users in the SAP HANA system? There are 2 correct answers to this question. Response:
- Question #92
Look at Figure You are selling books that have been translated into various languages. What join type should you use? Please choose the correct answer. Response:
- Question #93
What do you use a Transient Provider for? Please choose the correct answer. Response:
- Question #94
What do you have to assign to users to allow single sign-on? Please choose the correct answer. Response:
- Question #95
What SELECT statement is not recommended for use with column tables? Please choose the correct answer. Response:
- Question #96
You want to call a procedure in a SELECT statement (like a table function). Which clauses do you have to specify? There are 2 correct answers to this question. Response:
- Question #97
Which of the following are features of a data warehouse? There are 3 correct answers to this question. Response:
- Question #98
Prior to modeling in SAP HANA, you want to check whether a table is row-based or column- based. How can you do this in the SAP HANA studio? There are 2 correct answers to this ques...
- Question #99
What does the C in ACID-compliant stand for? Please choose the correct answer. Response:
- Question #100
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: