151 Which of the following deployment scenarios of SAP HANA can be side-car scenarios? (Choose two) A. SAP CO-PA Accelerator B. SAP HANA Live C. SAP CRM powered by SAP HANA D. SAP Business Sumte powered by SAP HANA.
152 When do you set the Calculation Before Aggregation fag in a calculated column? A. To calculate on line item level B. To filter columns C. To improve the overall runtime D. To aggregate measures.
153 Which of the following are advantages of running SAP HANA Live embedded in the SAP Business Sumter (Choose three) A. It provides real-time Replication. B. It allows use of generic virtual data models. C. It runs in older versions of the SAP Business Sumte. D. It uses the built-in capabilities of SAP HANA, such as the SAP HANA extended application services. E. It provides real-time operational reporting.
154 Where can you create a restricted column in a graphical calculation view? A. Aggregation node B. Join node C. Union node D. Projection node.
155 You have created a graphical calculation view with a large number of columns.
Which of the following do you use to ensure that Only required columns are shown when querying the created view? (Choose two)
A. Function CE_PROJECTION B. The Type selection in the semantics area C. Projection nodes D. The Hidden checkbox in the semantics area.
156 What must you do to enable currency conversions with a fixed currency in an analytic view? A. Create the target currency using an input parameter. B. Create a measure with the measure type Simple. C. Base the target currency on a currency column. D. Set the Enable for Conversion option.
157 You would like to authorize a user to select and delete data from a specific column table. The user should also be able to grant this Authorization to other users.
Which privilege do you need to implement?
A. System privilege B. Object privilege C. Package privilege D. Analytic privilege.
158 When loading data into SAP HANA, which of the following tasks can you perform using SAP Data Services? (Choose two) A. Data filtering B. Real-time Replication C. Data transformations D. Upload data via the SAP HANA studio.
159 How can you Import Information models into SAP HANA using the Quick Launch view? A. Choose the Redeploy button. B. Choose Import -> SAP HANA Content -> Delivery Unit. C. Choose Data Provisioning -> Load. D. Choose Import -> SAP HANA Content -> Import Data From Local File.
160 Which of the following Tools use SQL to communicate with SAP HANA? (Choose three) A. SAP BusinessObjects Information Design Tool B. SAP BusinessObjects Analysis, edition for OLAP C. SAP BusinessObjects Dashboards D. SAP Lumira E. SAP BusinessObjects Web Intelligence.
161 When you use SAP Landscape Transformation (SLT) Replication, which of the following can you do in the advanced Replication settings? (Choose two) A. Add a field to a table. B. Change the target table for specific records of a table. C. Assign a specific mass transfer ID to a table. D. Change the length of a character field of a table.
162 Which Information model can you use with measures from multiple fact tables? A. Analytic privilege B. Calculation view C. Attribute view D. Analytic view.
163 You need real-time profitability reporting from an SAP ECC System running on a non-SAP database.
Which of the following steps must you perform to implement the SAP CO-PA Accelerator? (Choose two)
A. Configure an ABAP datafow in SAP Data Services. B. Create an SAP Landscape Transformation configuration. C. Build Attribute and analytic views in SAP HANA. D. Install SAP HANA as a secondary database.
164 Which of the following are Included in a rapid-deployment solution (RDS) implemented on SAP HANA? (Choose three) A. A step-by-step Configuration Guide B. Packages with views and procedures C. The SAP HANA database license D. A fixed-price consulting project E. Conversion of all SAP BEx queries to analytic views.
165 You plan to migrate your existing SAP NetWeaver landscape with a non-SAP HANA database.
Which of the following are key considerations for the migration of your database to SAP HANA? (Choose three)
A. Reuse existing SAP NetWeaver application servers. B. Plan Downtime for the migration of the oid database to SAP HANA. C. Provision hardware that runs SUSE Linux (SLES) for SAP HANA. D. Upgrade all end-user front-end workstations to SUSE Linux (SLES). E. Resize application servers to handle incremental data volumes.
166 You want to create a sales Analysis by Combining your customer master data with your transactional sales data.
How do you model your data to ensure best performance?
A. • Model the transactional data in the data foundation of an analytic view.
• Model the master data in the Projection node of a calculation view.
• Combine them in the union node of the calculation view.
B. • Model the transactional data in the data foundation of an analytic view.
• Model the master data in the data foundation of an Attribute view.
• Join them in the logical join of the analytic view.
C. • Model the transactional data in the Projection node of a calculation view.
• Model the master data in the data foundation of an Attribute view.
• Combine them in the join node of the calculation view.
D. • Model the transactional data in the Projection node of a calculation view.
• Model the master data in the data foundation of an Attribute view.
• Combine them in the union node of the calculation view.
.
167 You want to aggregate the grand total sales amount into 1 currency.
In which of the following cases would you select the Calculate Before Aggregation check-box? (Choose two)
A. When an aggregate table by country contains sales values in 3 different currencies B. When a line item table contains sales values of 2 different currencies C. When a line item table contains sales values in 1 currency D. When an aggregate table by country contains sales values in 1 currency.
168 Which of the following is a characteristic of SAP NetWeaver Business Warehouse (SAP NetWeaver BW) when migrating it to run on SAP HANA? A. The SAP NetWeaver BW Accelerator becomes faster. B. The sizing of your current SAP NetWeaver BW application servers has to be re-evaluated. C. The SAP NetWeaver BW application server can be co-deployed on the SAP HANA database hardware. D. The usage of the SAP NetWeaver BW Accelerator becomes obsolete.
169 What is the Function of an Aggregation node in a calculation view? A. It provides grouping of filter criteria. B. It allows grouping of columns required for your Information model. C. It calculates the sum, minimum, or maximum values for Selected columns. D. It joins the result sets from different data sources.
170 Which of the following are restrictions of the SAP HANA fat file upload? (Choose two) A. The upload does not allow changes to the column names of new tables. B. The upload prevents data type changes when appending data. C. A table must have the same column order as the fat file when you append data. D. A new table always has a 1:1 mapping between the fat file columns and the table columns.
171 What are the consequences of executing the Stop activity on the Data Provisioning view in the SAP HANA studio for a table that is currently replicated? A. The table is dropped from the SAP HANA database. B. Triggers and logging tables are deleted. C. The Replication of the table is temporarily stopped and can be resumed. D. Triggers and logging tables are kept.
172 A corporation with over 15.000 cost centers would like to ensure that Only the person responsible for the cost center may view salary Information for individuals assigned to their cost center.
How can the corporation achieve this in SAP HANA?
A. Create a dynamic analytic privilege using the cost center and employee master data. B. Create an analytic privilege using the cost center and the salary measure. C. Create an Analysis Authorization using the cost center and employee master data. D. Create an object privilege on the cost center and employee master data schema.
173 An analytic view has a long runtime.
Which of the following can be a root cause for the bad performance? (Choose two)
A. The Execute In option is set to SQL Engine. B. The analytic view uses calculated columns. C. The analytic view uses generated columns. D. The Calculation Before Aggregation fag is set.
174 Which of the following data provisioning tasks can you perform in the SAP HANA studio? (Choose three) A. Configure Remote sources for SAP HANA smart data access. B. Activate the SAP Web Dispatcher service for SAP HANA Direct Extractor Connection (DXC). C. Start Replication of tables for SAP Landscape Transformation (SLT). D. Create Replication configurations for SAP Landscape Transformation (SLT). E. Create an SAP ECC extractor datastore for SAP Data Services.
175 Which of the following are characteristics of a Referential join? (Choose two) A. It requires Referential integrity between right and left tables. B. If a field is Selected from the right table, it acts similar to a left outer join. C. It assumes Referential integrity between right and left tables. D. If a field is Selected from the right table, it acts similar to an inner join.
176 When you try to delete an Attribute view you receive the error message, "One or more objects are dependent upon
this object".
Which of the following Functions can you use to find out which objects depend on this view? (Choose two)
A. History Function B. Where-used Function C. Auto Documentation Function D. Display XML Function.
177 Which of the following are characteristics of an agile data mart running on SAP HANA? (Choose two) A. Transformed application data is stored in the database. B. Queries run on highly normalized application data. C. Application data is transformed at query runtime. D. Application data is transformed before loading.
178 Which of the following would you create to ensure the fastest calculation performance? A. A calculated measure in an SAP BusinessObjects universe B. An input parameter in an SAP HANA Information model C. A report variable in an SAP BusinessObjects reporting Client D. A calculated column in an SAP HANA Information model.
179 Which of the following Tools can you use to load data into SAP HANA from SAP DataSource extractors? (Choose two) A. SAP Direct Extractor Connection B. SAP Data Services C. SAP Landscape Transformation Server D. SAP Replication Server.
180 You have been asked to create an SAP HANA Attribute view using the tables Employee (left table) and Department (right table), shown in the attached diagram. Your view should contain the columns NAME and D_Name for all employees.
Which of the following join types do you user
A. Referential join B. Left outer join C. Text join D. Inner join.
|
