1.What are characteristics of a constraint filter? A. It is defined during the design time on a table. B. It is applied on a table before the query execution. C. It is applied on the result set of an SQL query. D. It is defined during the runtime in the SQL query.
2.Which of the following are direct outputs of an analytic view? A. Hierarchies B. Private attributes C. Restricted attributes D. Measures E. Attribute views.
3.When you activate an analytic view, a column view is created. In which schema is this column view stored? A. _SYS_BIC B. _SYS_BI C. _SYS_REPO D. _SYS.
4.Which of the following SAP data provisioning methods provide complex transformations? A. SAP Data Services B. SAP HANA smart data access C. SAP Replication Server D. SAP HANA smart data quality.
5.Which of the following are restrictions of the SAP HANA fat file upload? A. A table must have the same column order as the fat file when you append data. B. The upload does not allow to change the column names of new tables. C. A new table must have a 1:1 mapping between the fat file columns and the table columns. D. The upload prevents data type changes when appending data.
6.In an analytic view, you need two different logical joins from the data foundation to an Attribute view. The analytic view already contains the Attribute view but you have to use the Attribute view again.
To which of the following do you connect the second join?
A. To a shared Attribute view B. To a derived Attribute view C. To a new instance of the Attribute view D. To a copy of the Attribute view.
7.What must you do to enable currency conversions with a fixed currency in an analytic view? A. Set the Enable for Conversion option B. Create a measure with the measure type Simple C. Base the target currency on a currency column D. Create the target currency using an input parameter.
8.You create a graphical calculation view that is based on analytic views.
What do you use to combine the data from the analytic views?
A. Referential join B. Projection node C. Aggregation node D. Union.
9.You want to model customer master data.
Which of the following must you select?
A. Filter B. Table C. Hierarchy D. Key Attribute.
10.You modified an active analytic view in the SAP HANA studio and saved it without activating it.
What is the consequence?
A. The inactive view is not available. B. The inactive view is in "Read Only" mode. C. The active view is not available. D. The active view is in "Read Only" mode.
11.When you activate a procedure, in which schema is the procedure stored? A. SYSTEM B. _SYS_BIC C. SYS_REPL D. _SYS_BI.
12.You want to create a graphical calculation view using the SAP HANA studio. Which steps are mandatory for this task? A. Define a Projection. B. Write an SQL script. C. Save and activate the view. D. Define output fields. E. Choose a data source.
13.You have a Web Intelligence report that requires data from SAP HANA filtered for a specific year. Where do you apply the filter for optimal performance? A. In the universe B. In the Web Intelligence report C. In the analytic view D. In the calculation view using an Attribute value variable.
14.What is the lowest level of granularity you can use in an analytic privilege? A. An Attribute B. A view C. An Attribute value D. A column.
15.What must you configure to directly access an SAP HANA analytic view using SAP BusinessObjects Analysis edition for Microsoft Office? A. RFC connection B. SAP HANA Direct Extractor Connection (DXC) C. Pre-delivered MODELING role D. System DSN.
16.Which of the following are characteristics of an operational data mart based on SAP HANA? A. It is based on analytic denormalized data models B. It uses real-time Replication of time-critical data C. It runs directly on top of the operational data D. It persists transformed data.
17.You have created an MS Excel report on SAP HANA data.
On which of the following could you store the Excel file and make it available for other users?
A. Shared network drive B. SAP BusinessObjects Information Design Tool C. SAP HANA database D. SAP HANA studio Content node.
18.How can you improve the performance of a report that is based on SAP HANA data? A. Ensure that all SAP HANA tables are in the same schema. B. Maintain appropriate constraint filters in SAP HANA. C. Ensure that all calculations are pushed down to the SAP HANA database. D. Gather new database statistics.
19.What is an example of a selective data load using SAP Landscape Transformation? A. Selected data field values are randomized and loaded into SAP HANA. B. Selected units or currencies are converted into recalculated amounts or values and loaded into SAP HANA. C. Selected data for transformation is split into portions. D. Selected data for a range of years is loaded into SAP HANA.
20.Which connection type is required from the SAP ERP System to SAP HANA to enable CO-PA side by side scenario? A. HTTP connection B. JDBC C. Secondary database connection D. Remote Function Call.
21.You need to create an SAP HANA data model based on a star schema.
Which SAP HANA engine is recommended for analytical purposes?
A. Calculation engine B. OLAP engine C. Row store engine D. Join engine.
22.Which of the following actions must you perform in an SAP HANA System to transport content to another SAP HANA System? A. Generate and save an export file to a shared directory. B. Assign the content repository to a transport request. C. Mass copy the content repository into the other SAP HANA System. D. Assign the package to a delivery unit.
23.How can you restrict SAP HANA modeling users from viewing sensitive data? A. Use scrambled source data. B. Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users. C. Use the pre-delivered MODELER role. D. Remove ALTER SYSTEM in the System privileges for the modeling users.
24.You model hierarchies in Attribute views. Which of the following technologies do you use to make these hierarchies available for reporting Tools? A. JDBC B. BICS C. ODBO D. ODBC.
25.Which of the following can you use as sources for the vocabulary in a decision table? A. Calculation views B. Table types C. OData models D. Procedures E. Physical tables.
26.Which of the following must an analytic view contain? A. A measure B. A calculated measure C. A hierarchy D. An Attribute view.
27.You have a table of transactional data with different transaction types. You want to create an analytic view for Only one of the transaction types.
How can you ensure that Only rows with the required transaction type are displayed in the analytic view?
A. Create an input parameter B. Create a filter on the table C. Create a calculated column D. Create a restricted column.
28.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. All active and inactive versions C. All active versions D. The last active and inactive version.
29.You want to load a large amount of source data (more than one billion rows) into SAP HANA for read-intensive Information models.
Which table type is recommended for this scenario?
A. Global temporary table B. Decision table C. Row table D. Column table.
30.Which of the following can you set up to enable the extraction of data from SAP Business Warehouse (BW) into SAP HANA? A. SAP System Landscape Directory (SLD) B. SAP BusinessObjects Data Services C. SAP Landscape Transformation (SLT) D. Open hub E. SAP HANA Direct Extractor Connection (DXC).