Which of the following is included in a rapid deployment solution (RDS) implemented on SAP HANA ? Conversion of all BEX queries to analytic views Guides and educational material A mix of onsite and offsite consulting The SAP HANA database license SAP best practices and templates.
Which versions of your information models are visible on the History tab of the Modeler
perspective in the SAP HANA studio?
Only the last active version All active and inactive versions All active versions The last active and inactive version.
Which SAP HANA privileges are used for administration tasks such as creating schemas? System privileges Package privileges Analytic privileges Application privileges.
You want to enable the end user to decide at runtime how to restrict the data in an information model. Which of the following objects do you use? Input parameter Filter Restricted measure Variable.
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 data foundation of an attribute view
• Combine both in the join node of the calculation view
.
A new user has implemented an SAP HANA data model. which technical user requires select rights on the new user's schema? _SYS_REPO _SYS_BIC _SYS_BI _SYS_SECURITY.
In a fuzzy search, when would you perform a freestyle search? When you want to search with a low fuzziness threshold When you want to search in only one column When you want to search in multiple columns When you want to search with a high fuzziness threshold.
Which tasks can you perform with the data provisioning view in the SAP HANA studio? (Choose two) Start replication of tables Filter replicated data Apply data transformations Suspend replication of tables.
Which of the following are characteristics of an operational data mart based on SAP HANA?
(Choose two)
It is based on analytic denormalized data models It uses real-time replication of time-critical data It runs directly on top of the operational data It persists transformed data.
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? Analytic privilege System privilege Package privilege Object privilege.
How can you define conditions and actions in a decision table? (Choose three) Use ABAP routines Use conditional expressions Use CE functions Use date operations Use mathematical operations.
You want to model customer master data.Which of the following must you select? (Choose two) Filter Table Hierarchy Key attribute.
Which of the following can be grouped when multiple schemas exist in an SAP HANA database? Information models Data tables Pacakges Tables.
How can you import information models into SAP HANA using the Quick Launch view? Select the Redeploy button Select Data Provisioning -> Load Select Import -> SAP HANA Content -> Import Data From Local File Select Import -> SAP HANA Content -> Delivery Unit.
Which of the following steps do you have to execute to import models from one SAP HANA
system (system1) to another SAP HANA system (system2)? (Choose three)
Create a delivery unit on system1 Import the models into system2 Create a schema on system2 Create a delivery unit on system2 Export the models from system1.
You have to extract entities such as persons, countries, products, and places from business text such as PDF files. Which of the following tools in SAP HANA can you use? Full-text search UI toolkit Python-based text analysis scripts Fuzzy search Application function libraries.
Which of the following actions must you perform in an SAP HANA system to transport content to another SAP HANA system? (Choose two) 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.
The IT department has a service level agreement (SLA) that states "all production systems must be available to the end user within ½ hour of any type of system failure."
Which of the following helps meet the SLA for SAP HANA system failures?
Disaster recovery Scale up Side-by-side scenario Scale out high availability.
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.
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.
You have created an input parameter in an information model. In which of the following can you use the input parameter? The definition of an information space that reads from the information model The creation of a BEx query reading from the information model The creation of an SAP BusinessObjects Web Intelligence report directly on the information model The definition of objects in an SAP BusinessObjects universe.
In a left outer join, the left table has one record and the right table has three records. What is the maximum number of records that you expect in the join result? 0 1 3 4.
Your data models use hierarchies. In which front end tool can you access these hierarchies? (Choose two) SAP Business Objects Dashboards SAP Business Objects Crystal Reports 2011 SAP Business Objects Analysis, edition for OLAP SAP Business Objects Analysis, edition for Microsoft Office.
What are advantages of implementing SAP HANA using an SAP rapid-deployment solution over a traditional implementation project? (Choose three) Fixed-scope implementation No need for consultants Lower risk Pre-configured content Customized content.
Which of the following would you use to determine the engines that are used when an information model is queried? (Choose two) SQL plan cache Timeline Explain plan Visualize plan.
Where can you reactivate a user after too many invalid logon attempts? (Choose two) In the SQL console In the user specific schema In the INVALID_CONNECT_ATTEMPS view In the user properties.
How can you improve the performance of a scripted calculation view? Read data from column tables using nested SELECT statements Convert SQL code to equivalent CE functions Combine analytic views using a CE_JOIN function Combine data from the row store and column store.
Which of the following are advantages of running SAP HANA Live embedded in the SAP Business Suite? (Choose three) It uses the generic capabilities of SAP HANA such as the XS Engine It provides real-time operational reporting It allows using generic virtual data models It provides real-time replication It runs in older versions of the SAP Business Suite.
Which of the following are recommended SAP HANA modeling principles? (Choose two) Use complex expressions like IF or CASE Always do the calculation after aggregation Filter the data amount as early as possible in the lower layers Join tables on key columns.
Which of the following criteria indicate that you should store data in row tables? (Choose two) The tables have a large number of columns. The tables required frequent write access The information models search the table based on the values of a few columns. The information models frequently needs to access complete records.
A new user has implemented an SAP HANA data model.
Which technical user requires select rights on the new user's schema?
_SYS_REPO _SYS_BIC _SYS_BI _SYS_SECURITY.
Two attribute views in the same analytic view contain the same column name (ID from attribute view Customer and ID from attribute view Product). In the output, the system automatically renamed one column to ID_1.Which of the following can you do to indicate that ID_1 originated from attribute view Product? Update the alias in the properties of ID_1. Change the label of ID_1. Create a restricted column with a different name based on ID_1. Create a derived attribute view with an alias for ID_1.
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) History function Auto Documentation function Display XML function Where-Used function.
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 use? Text join Inner join Referential join Left outer join.
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? (Choose two) 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.
Which of the following objects would SAP HANA identify as the left object of a join in the graphical calculation view? The object that has its field identified first in the join output. The object that is displayed on the left hand side in the join details panel. The object that is connected to the join node first. The object that is displayed on the left hand side in the graphical calculation view.
What type of calculation would you create to ensure the fastest calculation performance? A report variable in an SAP Business Objects reporting client A calculated column in an SAP HANA information model An input parameter in an SAP HANA information model An calculated measure in an SAP Business Objects universe.
What is the functionality of an aggregation node in a calculation view? (Choose two) It calculates the sum, minimum, or maximum values for selected columns It provides grouping of filter criteria It provides deeper control over which columns are totaled It determines the output structure of the calculation view.
What is the functionality of an aggregation node in a calculation view? (Choose two) It calculates the sum, minimum, or maximum values for selected columns It provides grouping of filter criteria It provides deeper control over which columns are totaled It determines the output structure of the calculation view.
In an SQL Script calculation view, one variable contains the records that are the result of a SELECT * statement from a database table with 10 fields. You want to use this variable to populate a new variable with the same result set restricted to 1 of the 10 fields. Which CE function do you use? CE_COLUMN_TABLE CE_PROJECTION CE_CALC CE_AGGREGATION.
Which information model can you use with measures from multiple fact tables? Analytic privilege Attribute view Analytic view Calculation view.
You want to use a UNION to combine two information objects in a calculation view.
Which steps do you have to perform? (Choose two)
Define a constant column in the target Sort the columns in the output structure Connect the information objects to the UNION node Define the mapping of columns of the information objects.
Which of the following can you use to implement currency conversion in an information model? (Choose two) A calculated column in a calculation view A restricted column in an analytic view A calculated column in an analytic view A calculated column in an attribute view.
Which view do you use to combine two analytic views? Attribute view Analytic view Database view Calculation view.
Table SALES_TABLE contains the columns COUNTRY and SALES. unction calc_tax calculates sales tax based on input parameter SALES. Using a scripted calculation view, how can you call the calc_tax function? v_tax = SELECT COUNTRY, CALL :calc_tax(SALES) AS TAX FROM :SALES_TABLE v_tax = SELECT COUNTRY, calc_tax(SALES) AS TAX FROM SALES_TABLE v_tax = CE_PROJECTION(SALES_TABLE, ["COUNTRY","CALL :calc_tax(SALES)"]) v_tax = CE_PROJECTION(SALES_TABLE, ["COUNTRY","calc_tax(SALES)"].
In a graphical calculation view you specify the default client to be dynamic.
How is the client value determined when the view is used?
By checking the session client of the user accessing the view By reading the client of the tables in the view By applying the filtering conditions on the client field By executing a procedure in the user's own schema.
In a calculation view you define a calculated column and set the Calculate before Aggregation flag. Which of the following activities is mandatory to activate the view? Set the column type to Attribute Add a new aggregation node Mark the column as hidden Select the aggregation type.
In an aggregation node of a calculation view, which is the default aggregation type for an aggregated measure? Count Max Sum Min.
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.
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.
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? Create an input parameter Create a filter on the table Create a calculated column Create a restricted column.
What must you do to enable currency conversions with a fixed currency in an analytic view? Set the Enable for Conversion option Create a measure with the measure type Simple Base the target currency on a currency column Create the target currency using an input parameter.
You have created two analytic views for actual and planned financial data each. The data covers multiple years. You want to display the actual data, planned data, and their difference in three separate columns in a report. The difference column is a calculated column. How can you model this? • Create a calculation view
• Combine the analytic views in the calculation view using a UNION WITH CONSTANT VALUES
• Create restricted columns for each year for the actual and planned columns in each analytic view
• Combine the analytic views in a new calculation view using a UNION
• Create an analytic view
• Combine the analytic views in the new analytic view using a referential join
• Create a calculation view
• Combine the analytic views in the calculation view using a UNION
.
Which of the following describes an SAP HANA analytic view? It is a set of tables joined together in a star schema It is a copy of data after transformation It is a reusable object in attribute views It is a materialized set of data.
In which engines is an analytic view executed that contains a calculated column? (Choose two) Calculation engine Row store engine OLAP engine Join engine.
Which of the following objects can you use when you build an analytic view? (Choose three) Attribute views Analytic views Hierarchies Variables Projections.
What is the lowest level of granularity you can use in an analytic privilege? An attribute A View An attribute value A Column.
You want to run a report on data with multiple currencies. You want to allow end users to select the target currency at run time. Which option does SAP recommend for defining the currency conversion? A calculated column in an analytic view Currency conversion during data load Measures enabled for conversion in an analytic view ACE_CONVERSION function in a calculation view.
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? (Choose two) To a shared attribute view To a derived attribute view To a new instance of the attribute view To a copy of the attribute view.
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? Create a dynamic analytic privilege using the cost center and employee master data Create an analytic privilege using the cost center and the salary measure Create an object privilege on the cost center and employee master data schema Create an analysis authorization using the cost center and employee master data.
You modified an active analytic view in the SAP HANA studio and saved it without activating it. What is the consequence? The inactive view is not available. The inactive view is in "Read Only" mode. The active view is not available. The active view is in "Read Only" mode.
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.
When loading data into SAP HANA, which of the following tasks can you perform using SAP Data Services? (Choose two) Upload data via the SAP HANA studio Data filtering Real-time replication Data transformations.
What are the consequences of executing the stop activity on the Data Provisioning view in the HANA studio for a table that is currently replicated? Triggers and logging tables are deleted. The table is dropped from the SAP HANA database. Triggers and logging tables are kept. The replication of the table is temporarily stopped.
Which of the following tools can you use to load data into SAP HANA from SAP Data Source extractors? (Choose two) SAP Data Services SAP Sybase Replication Server SAP Landscape Transformation Server SAP Direct Extractor Connection.
You are implementing the SAP CO-PA Accelerator to enable real-time profitability reporting. Which configuration steps must you do? (Choose three) Activate continuous data replication of tables CE1xxxx, CE2xxxx, CE4xxxx Configure the SAP Business Objects Data Services replication jobs Install the SAP HANA database clients on all SAP ERP application servers Build attribute and analytic views in SAP HANA Create a secondary database connection in SAP ERP.
When you use SAP Landscape Transformation (SLT) replication, which of the following can you set up in the advanced replication settings? (Choose two) 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.
In a two system landscape, you want to transport SAP HANA information models from the source system to a target system. The source system has information objects that refer to physical schema S1. The target system uses physical schema S2. When you import the information objects into the target system, the information objects at the target cannot be opened as they still refer to schema S1.What must you do to be able to open the information objects in the target system? (Choose two) Add a schema mapping. Create a new schema. Execute a refactoring. Re imports the information models.
When you use SLT replication, which of the following determines the name of the SAP HANA schema where replicated data is stored? The name of the secondary database connection The name of the replication configuration The name of the source system schema The name of the RFC connection.
Which programming language do you use for SAP Landscape Transformation based
transformation rules?
SQL Script Java ABAP JavaSript.
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).
Which type of connection does Direct Extractor Connection (DXC) use to transfer data to SAPHANA? RFC connection Secondary database connection http connection ODBC connection.
Which of the following remote data sources can you access with SAP HANA smart data access? (Choose three) SAP NetWeaver Business Warehouse Microsoft SQL Server Apache Hadoop Tera data Database SAP Sybase Adaptive Service Enterprise.
Which of the following are restrictions of the SAP HANA flat file upload? (Choose two) 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 are characteristics of SAP NetWeaver Business Warehouse (SAP BW) when migrating it to run on SAP HANA? (Choose three) The sizing of your current SAP BW application servers remains valid. It allows co-deployment of the SAP BW application server on the SAP HANA database
hardware. It allows re-use of your available SAP BW application servers. It eliminates the need to upgrade to the latest SAP BW application version. The system usage is the same as an equivalent SAP BW on non-SAP databases.
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? (Choose two) 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 an SAP NetWeaver Business Warehouse (SAP NetWeaver BW) on SAP HANA system installed on multiple nodes. Which of the following information objects are stored on the master node? SAP NetWeaver BW master data tables DataStore Objects (DSOs) ABAP system tables Persistent Staging Area (PSA) tables.
Which of the following tools use SQL to communicate with SAP HANA? (Choose three) SAP Business Objects Web Intelligence SAP Business Objects Analysis, edition for OLAP SAP Business Objects Information Design Tool SAP Business Objects Analysis, edition for Microsoft Office SAP Business Objects Dashboards.
|
