para mlehor

You have created SAP HANA information models from replicated SAP ECC data. How can you compare the data of the replicated tables with the underlying ECC source data?. Use the SAP ERP Data Browser (transaction SE16). Use the Catalog node to open table contents. Use transaction IUUC_REPL_CONTENT. Use the Data Provisioning view from the Quick Launch.

When you activate an analytic view, a column view is created. In which schema is this column view stored?. _SYS_BIC. _SYS_BI. _SYS_REPO. _SYS.

Which connection type is required from the SAP ERP system to SAP HANA to enable COPA side by side scenario?. HTTP connection. JDBC. Secondary database connection. Remote Function Call.

You have imported models from the development system. What is the recommended way toactivate dependent models in SAP HANA?. Use the Activate with History function. Use the Where-Used List function. Use the Cascade Activate function. Activate each view manually.

What are advantages of implementing SAP HANA using an SAP rapid-deployment solution over a traditional implementation project?. Fixed-scope implementation. No need for consultants. Lower risk. Pre-configured content. Customized content.

Which of the following automatically aggregates data?. Analytic view. Calculation view. Column table. Attribute view.

Your customer wants to implement a SAP product that: Provides near real-time replication to SAP HANA Connects SAP HANA to a non-SAP source system and SAP BW Uses SAP extractors What do you recommend?. SAP Legacy System Migration Workbench (LSMW). SAP Landscape Transformation (SLT). Sybase Replication Server. SAP BusinessObjects Data Services 4.0.

You need to find out which users logged on to the SAP HANA system over the course of the last week. What would you check?. The Audit log. Entries in M_CONNECTIONS. The nameserver_history.trc file. The indexserver_alert.trc file.

You have created an information space in SAP BusinessObjects Explorer but the information space is not available on the Home page. How can you make the information space available on the Home page?. Drag the information space to the Home page. Refresh the list of information spaces on the Home page. Select the "Show on Home page" checkbox in the information space properties. Index the information space again.

You are experiencing performance problems with SAP BusinessObjects reports based on SAP HANA data. Which of the following can you do to increase performance?. Add only relevant data to the report queries. Avoid aggregation and work on raw data. Merge all relevant data into a consolidated report. Use drill-down or linked reports.

What is the advantage of reporting directly from column tables?. It provides multi-language support. It eliminates the need for additional modeling. It shifts complex calculations and logic to SAP HANA. It supports analytical privileges.

Which view in SAP HANA studio do you use to add additional users?. Properties View. Quick launch View. Console View. Navigator View.

Which of the following actions must you perform in an SAP HANA system to transport content to another SAP HANA system?. Generate and save an export file to a shared directory. Assign the content repository to a transport request. Mass copy the content repository into the other SAP HANA system. Assign the package to a delivery unit.

You model hierarchies in attribute views. Which of the following technologies do you use to make these hierarchies available for reporting tools?. JDBC. BICS. ODBO. ODBC.

HANA Currency Conversion supported only via ___. Analytic. Attribute. Calculation. Analytic / Calculation.

Which of the following are benefits of implementing SAP HANA?. SAP HANA provides real-time analytics. SAP HANA performs much faster than the standard SAP ERP. SAP HANA provides pre-configured BI Content. SAP HANA combines OLTP and OLAP in one system. SAP HANA replaces SAP BW.

Which of the following are restrictions of the SAP HANA flat file upload?. A table must have the same column order as the flat file when you append data. The upload does not allow to change the column names of new tables. A new table must have a 1:1 mapping between the flat file columns and the table columns. The upload prevents data type changes when appending data.

Which of the following can you set up to enable the extraction of data from SAP Business Warehouse (BW) into SAP HANA?. SAP System Landscape Directory (SLD). SAP BusinessObjects Data Services. SAP Landscape Transformation (SLT). Open hub. SAP HANA Direct Extractor Connection (DXC).

In SAP ERP there are more than 50,000 application tables. How do you determine the relevant SAP ERP tables to replicate in SAP HANA and their dependencies?. Use SAP ERP Data Modeler (transaction SD11). Use SAP ERP ABAP Dictionary Maintenance (transaction SE11). Use the SAP ERP Tables and Indexes Monitor(transaction DB02). Use SAP ERP Data Browser (transaction SE16).

You have set up replication from SAP ERP using SAP Landscape Transformation (SLT). You notice that the information models do not show the latest data from ERP. What do you check to investigate this?. Activation status of the information models. Transaction SAP ERP Data Modeler (SD11). Transaction LTR on SLT. Data Provisioning view in SAP HANA studio.

You want to model customer master data. Which of the following must you select?. Filter. Table. Hierarchy. Key attribute.

What are benefits of using a business layer on top of SAP HANA?. An extra layer of granular security. Improved database calculation speed. Fast throughput via BICS connectivity. Users can use business names instead of technical names.

A company loads data every night from several source systems into multiple tables in SAP HANA using complex transformation rules. The calculation view that joins these tables performs unexpectedly slow. Which of the following could you investigate to be able to improve performance?. Whether the joins and transformations of the tables can be moved to the data loading process of SAP BusinessObjects Data Services. Whether an InfoCube compression is running. Whether the calculation view needs to create large intermediate result sets. Whether savepoints are written during execution.

Which SAP BusinessObjects reporting tool should you use to answer ad-hoc questions and interact with shared information?. Crystal Reports. Dashboards. Explorer. WebIntelligence.

When you use SAP Landscape Transformation (SLT) replication, which of the following can you set up in the advanced replication settings?. Change a character field length of a table. Change the target table for specific records of a table. Assign a specific mass transfer ID to a table. Add a field to a table.

You need to create an SAP HANA data model based on a star schema. Which SAP HANA engine is recommended for analytical purposes?. Calculation engine. OLAP engine. Row store engine. Join engine.

Your customer requires real-time replication. Where do you select the tables to be replicated to SAP HANA?. in transaction LTR in SAP Landscape Transformation (SLT). in the Import dialog of the Quick Launch of SAP HANA studio. in transaction SAP ERP Tables and Indexes Monitor (DB02). in the Data Provisioning dialog of SAP HANA studio.

What are characteristics of a constraint filter?. It is defined during the design time on a table. It is applied on a table before the query execution. It is applied on the result set of an SQL query. It is defined during the runtime in the SQL query.

Where can you reactivate a user after too many invalid logon attempts?. In the SQL console. In the user specific schema. In the INVALID_CONNECT_ATTEMPS view. In the user properties.

You want to retrieve data from SAP HANA and restrict access to certain data columns for specific user groups. Where can you implement this?. In the analytic privileges. In the data foundation. In the business layer. In the SQL privileges.

What are the key benefits of using SAP BusinessObjects Explorer with SAP HANA?. You do not need to create your own queries to access information. You can easily create your own queries to access information. You can access information for data discovery intuitively. You can execute ad-hoc business analytics quickly. You can easily create an IDT business layer.

With which of the following do you build the vocabulary of a decision table?. Actions. Attributes. Conditions. Measures.

Which of the following are required elements when you create any type of hierarchy in SAP HANA?. A child node. An analytic view. A data foundation. An attribute view.

You are using SAP NetWeaver Business Warehouse (SAP NetWeaver BW) in your company as the enterprise data warehouse. You want to use SAP NetWeaver BW as a data provisioning tool for SAP HANA without disturbing your BW reporting. Which of the following are SAP recommended actions?. Automate the ETL processes in SAP NetWeaver using process chains. Write data back from SAP HANA into the replicated SAP NetWeaver BW tables. Create new InfoObjects for the SAP HANA InfoProviders. Schedule the real-time data loads into SAP HANA.

You have two analytic views. One contains actual data and the other one 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?. JOIN in a calculation view. JOIN in an analytic view. UNION in a calculation view. PROJECTION in a calculation view.

Prior to modeling in SAP HANA, you want to validate referential integrity between two very large tables in the SAP HANA database. Which SAP HANA tool would you use?. Data preview. View contents. View log. SQL console.

Company needs to load external data from a flat file into SAP HANA. How can you do this?. SAP HANA Direct Extractor Connection (DXC). SAP System Landscape Transformation (SLT). SAP HANA SQL Import statement. SAP BusinessObjects Data Services.

If you want to create or drop tables in a schema, which privilege type do you need?. SYSTEM. ANALYTIC. PACKAGE. SQL.

In which View, client queries can be less optimized and could significantly be slower compare to other models. Analytic. Attribute. Calculation (SQL). Calculation (CE Functions).

Which of the following is a best practice in calculation views?. Apply a static filter on a projection node. Combine analytic views with a join node. Change an attribute to a measure. Push calculations down to the attribute views.

You want to aggregate the grand total sales amount into one currency. In which of the following cases would you perform the calculation before aggregation?. When a line item table contains sales values of two different currencies. When an aggregate table by country contains sales values in one currency. When a line item table contains sales values in one currency. When an aggregate table by country contains sales values in three different currencies.

You create a graphical calculation view that is based on analytic views. What do you use to combine the data from the analytic views?. Referential join. Projection node. Aggregation node. Union.

When you create a report in SAP BusinessObjects you notice that some columns of your SAP HANA information model are not available in the report. How can you make the columns available?. Add the columns in SAP Landscape Transformation replication. Add the columns to the query panel of the report. Add the columns to the source table in the catalog node in SAP HANA studio. Add the columns to the business layer.

What is features available in Project Creation Wizard. New option to auto-share an XS Project to the SAP HANA Repository during the project creation wizard. New option to auto-share an XS Server - side Project to the SAP HANA Repository during the project creation wizard. New option to auto-share an XS client - side Project to the SAP HANA Repository during the project creation wizard. New option to auto-share an XS Server - side secure Project to the SAP HANA Repository during the project creation wizard.

Which of the following are required to create an attribute view?. Data Foundation. Default Schema. Join. Key Attribute.

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?. - 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 both in the logical join of analytic view. - Model the transactional data in the projection node of an calculation view - Model the master data in the data foundation of an attribute view - Combine both in the union node of the calculation view. - 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 both in the union node of the calculation view. - Model the transactional data in the projection node of an calculation view - Model the master data in the datafoundation of an attribute view - Combine both in the join node of the calculation view.

You are using SAP Landscape Transformation to replicate data into SAP HANA. Which of the following can you use to define the schema that the replicated data populates?. Advanced replication settings (transaction iuuc_repl_content). Change Authoring Schema in the Quick Launch view. Data Provisioning in the Quick Launch view. Configuration & Monitoring Dashboard (transaction LTR).

You want to use an extractor to build a model in SAP HANA. Which table can you use to view detailed information about the extractor?. BSEG. RODELTAM. ROOSOURCE. RSOLTPSOURCE.

Which SAP BusinessObjects tools require an SAP BusinessObjects semantic layer (universe) to access data in SAP HANA?. Crystal Reports 2011. Crystal Reports for Enterprise. Dashboards. Analysis Office v1.1. WebIntelligence.

Which SAP BusinessObjects tool do you use to visualize real-time key performance indicators with simu-lations?. Explorer. Analysis, edition for OLAP. Web Intelligence. Dashboards.

What does the following SQL statement do? SELECT SCORE() as SCORE, PRODUCT_NAME, *FROM PRODUCT_ITEMS WHERE CONTAINS(*,'Paper', FUZZY(0.8)) ORDER BY PRODUCT_NAME. It performs a fuzzy search on all columns in the PRODUCT_NAME table for the term 'Paper'. It performs a fuzzy search count on the number of columns in the PRODUCT_NAME table that contain the term 'Paper'. It performs a fuzzy search on the PRODUCT_NAME column in the PRODUCT_ITEMS table for the term 'Paper'. It performs a fuzzy search of all columns in the PRODUCT_ITEMS table for the term 'Paper'.

Which engine is used for calculation and aggregation based on star schema. Join Engine. Calculation Engine. SQL Optimizer Engine. OLAP Engine.

You want to create a customer segmentation on your SAP HANA data. Which of the following do you use?. RODBC library. SAP HANA Business Function Library. SAPUI5 runtime library. SAP HANA Predictive Analysis Library.

Which of the following must an analytic view contain?. A measure. A calculated measure. A hierarchy. An attribute view.

You receive an activation error in a scripted calculation view that uses the following function:CE_PROJECTION(:table1, ["AMOUNT"], '"PROD" = A') What could be a reason for this error?. The filter condition is not set within square brackets. The projection list contains a field that is not specified in the filter condition. The filter condition must be specified inside the projection list. The filter condition contains a field that is not part of the projection list.

Which of the following does an SAP BusinessObjects universe use to communicate with SAP HANA?. ABAP. SQL. MDX. BICS.

You have to design a report that shows actual, planned, and variance values. How do you implement this requirement if you want to achieve the best performance?. Use a calculation view based upon two analytic views using a union. Use a calculation view based upon two analytic views using a join. Use a single source data foundation in the Universe Design Tool and include the two analytic views. Use a multisource-enabled data foundation in the Universe Design Tool for each analytic view.

When loading data into SAP HANA, which of the following tasks can you perform using SAP Data Services?. Replicate data using database triggers. Read data from SAP ERP using the embedded SAP BW system. Replicate data by reading database logs. Read data from SAP ERP using ABAP data flows.

Which connectivity combination between MS Excel and SAP HANA provides multidimensional reporting capabilities?. ODBO connector via SQL requests to analytic or calculation views. ODBC connector via MDX requests to analytic or calculation views. ODBO connector via MDX requests to analytic or calculation views. ODBO connector via MDX requests to column tables.

Which of the following can you use to build the data foundation for an attribute view?. Referential Join. Union. Projection. Text Join.

Which of the following can be grouped when multiple schemas exist in an SAP HANA database?. Information models. Data tables. Packages. Users.

Which of the following must you avoid to ensure your calculation view uses only the calculation engine?. Combining SQL and CE Functions. Reading from tables in the column store. Reading from tables using SELECT statements. Joins using SQL. DO WHILE loops.

Your customer wants to use SAP BusinessObjects Data Services to migrate and transform large volumes of data to SAP HANA. What do you recommend?. Use ABAP data flows. Use RFC/BAPI function calls. Use the RFC_READ_TABLE. Use IDOCs.

Which of the following must you do when you create an analytic view?. Define a column as an attribute. Define a column as a measure. Select a data foundation table. Define a join. Select an attribute view.