121. You have 2 SAP HANA Systems. You are working in 1 of these Systems.
Which of the following do you use to read data from and write data to the other, Remote SAP HANA System? (Choose two)
A. SAP HANA smart data access B. Remote providers C. Virtual column D. Virtual table.
122. What is the minimum requirement for a valid analytic view? A. One fact table and one Attribute view B. One Attribute view C. One fact table and two Attribute views D. One fact table.
123 . Which type of connection does SAP HANA Direct Extractor Connection (DXC) use to transfer data to SAP HANA? A. Secondary database connection B. RFC connection C. ODBC connection D. HTTP connection.
124. When you use SLT Replication, which of the following determines the name of the SAP HANA schema where replicated data is stored? A. The name of the RFC connection B. The name of the secondary database connection C. The name of the source System schema D. The name of the Replication configuration.
125. You want to run a report on data with multiple currencies. You want to allow end users to select the target currency at runtime.
Which options does SAP recommend for defining the currency conversion? (Choose two)
A. Currency conversion during data load B. A CE_CONVERSION Function in a calculation view C. Measures enabled for conversion in an analytic view D. A calculated column in an analytic view.
126. Your data models use hierarchies.
In which of the following front end Tools can you access these hierarchies? (Choose three)
A. SAP Lumira B. SAP BusinessObjects Analysis, edition for Microsoft Office C. SAP BusinessObjects Dashboards D. SAP Crystal Reports 2011 E. SAP BusinessObjects Analysis, edition for OLAP.
127. Which of the following Remote data sources can you access with SAP HANA smart data access? (Choose three) A. XML file B. SAP Adaptive Server Enterprise C. SAP NetWeaver Business Warehouse D. Apache Hadoop E. Teradata Database.
128. Which of the following selection types are available when creating a variable in an analytic view? (Choose three) A. Single value B. Direct C. Interval D. Range E. Column.
129. Where can you reactivate a user after too many Invalid logon attempts? (Choose two) A. In the INVALID_CONNECT_ATTEMPS view B. In the user-specific schema C. In the user properties in the SAP HANA studio D. In the SQL Console.
130 Which versions of your Information models are visible on the History tab of the Modeler perspective in the SAP HANA studio? A. Only the last active version B. The last active and inactive versions C. All active and inactive versions D. All active versions.
131 You would like to authorize a user to see data in an analytic view Only for company code 1000 and fiscal year 2000 or for company code 1005 and fiscal year 2005.
Which of the following achieves this requirement?
A. • One analytic privilege: company code = 1000, fiscal year = 2000
• One analytic privilege: company code = 1005, fiscal year = 2005
B. • One analytic privilege: company codes = 1000 and 1005
• One analytic privilege: fiscal years = 2000 and 2005
C. One analytic privilege: the combination of company code = 1000 and fiscal year = 2000, and the combination of company code = 1005 and fiscal year = 2005 D. One analytic privilege: company codes = 1000 and 1005, and fiscal years = 2000 and 2005.
132 Which of the following can be grouped inside a Single schema in an SAP HANA database? A. Information models B. Packages C. Users D. Database tables.
133 You want to implement an SAP HANA data model based on tables in a new schema that you just created.
Which technical user requires select rights on your new schema?
A. _SYS_BI B. _SYS_SECURITY C. _SYS_BIC D. _SYS_REPO.
134. What does SAP recommend to improve performance of data models in SAP HANA? A. Move intensive calculations to the front-end application B. Perform calculation before Aggregation C. Utilize as many different engines as possible D. Minimize data transfer between the engines.
135 What are the advantages of implementing SAP HANA using an SAP rapid-deployment solution over a traditional implementation project? (Choose three) A. Preconfigured content B. Fixed-scope implementation C. No need for consultants D. Customized content E. Lower risk.
136 What is the lowest level of granularity you can use in an analytic privilege? A. A view B. A column C. An Attribute value D. An Attribute.
137 How can you analyze a performance issue in the execution of an SQL statement using the SQL Consoler (Choose two) A. Use the Prepare Statement command from the right-click menu in the SQL Console. B. Query the table "SYS"."CACHE_P_QUERIES_"' after the execution of the SQL statement. C. Use the Explain Plan command from the right-click menu in the SQL Console. D. Use EXPLAIN PLAN in the SQL statement and query the EXPLAIN_PLAN_TABLE.
138 You have two analytic views: one contains actual data and the other contains plan data. You want to combine the two
result sets and keep actual and plan data on separate records.
In the SAP HANA studio, which of the following can you use to achieve this?
A. JOIN in an analytic view B. UNION in a calculation view C. PROJECTION in a calculation view D. JOIN in a graphical calculation view.
139 Which of the following SAP HANA schemas contains the runtime objects of activated views? A. _SYS_STATISTICS B. _SYS_REPO C. _SYS_BI D. _SYS_BIC.
140 Which of the following should you try to implement as best practices for data modeling? (Choose two) A. Perform Aggregation in an Attribute view. B. Use filters to restrict the number of rows on the tables that make up the analytic views. C. Execute calculated columns before any Aggregation is performed. D. Use a UNION when Combining analytic views in a calculation view.
141 Which of the following actions must you perform in an SAP HANA System to transport content to another SAP HANA System? (Choose two) A. Generate and save an export file. B. Mass copy the content repository into the other SAP HANA System. C. Assign the package to a delivery unit. D. Assign the content repository to a transport request.
142 Which of the following modeling objects can you use with a Star Join node? (Choose two) A. Aggregation node before the Star Join node B. Aggregation node after the Star Join node C. Calculation views of type dimension D. Projection node after the Star Join node.
143 Table SALES_TABLE contains the columns COUNTRY and SALES. Function calc_tax calculates sales tax based on input parameter SALES.
Using a scripted calculation view, how can you call the calc_tax Function?
A. v_tax = CE_PROJECTION(SALES_TABLE, ["COUNTRY","calc_tax(SALES)"]); B. :v_tax = CE_PROJECTION(SALES_TABLE, ["COUNTRY","CALL :calc_tax(SALES)"]); C. :v_tax = SELECT COUNTRY, CALL :calc_tax(SALES) AS TAX FROM :SALES_TABLE; D. v_tax = SELECT COUNTRY, calc_tax(SALES) AS TAX FROM SALES_TABLE;.
144 In a graphical calculation view, you specify the default Client to be dynamic.
How is the Client value determined when the view is used?
A. By checking the session Client of the user accessing the view. B. By executing a procedure in the user's own schema. C. By applying the filtering Conditions on the Client field. D. By reading the Client of the tables in the view.
145 What is an advantage of using CE Functions over regular SQL? A. CE Functions offer row store operations. B. CE Functions enforce parallel execution. C. CE Functions Include more Functions than regular SQL. D. CE Functions can be used in any other database.
146 In a fuzzy search, when would you perform a freestyle search? A. When you want to search with a high fuzziness threshold B. When you want to search in multiple columns C. When you want to search in Only one column D. When you want to search with a low fuzziness threshold.
147 Which SAP HANA privileges are used for Administration tasks, such as creating schemas? A. Analytic privileges B. Application privileges C. Package privileges D. System privileges.
148 You have created several Information models. A colleague of yours needs to be able to work on your Information models.
Which privileges do you give your colleague?
A. Analytic privileges B. Package privileges C. Dynamic analytic privileges D. Object privileges.
149 Which of the following criteria indicate that you should store data in row tables? (Choose two) A. The tables have a large number of columns B. The Information models search the table based on the values of a few columns. C. The Information models frequently need to access all columns. D. The tables require frequent write access.
150 Which programming language do you use for SAP Landscape Transformation based transformation rules? A. JavaScript B. SQLScript C. ABAP D. Java.
|
