You want to add a calculated column to an SAP BusinessObjects Web Intelligence report.
In which application do you create the calculation to achieve best report performance? Central Management Console Information Design Tool Web Intelligence SAP HANA Studio.
Which delivered role is mandatory for a system administrator in SAP HANA? SYS_ADMIN CONTENT_ADMIN SAP_ALL IC MODELER.
Which tasks do you have to perform if you want to use SAP BW with SAP HANA as the underlying database?
(Choose three) Install SAP Business Warehouse Accelerator (BWA). Perform a database migration from your current DB to SAP HANA DB. Execute the report RS_BW_POST_MIGRATION. Upgrade to at least SAP NetWeaver Business Warehouse 7.30 SP5. Recreate SAP BW indexes after SAP HANA database migration.
460684bb-deee-44c2-80f9-71c46954fbe4:
Which connection method that is listed on the left can you use with the tools that are available in the drop-down box on the right?
all are correct RFC ODBC/JDBC BICS ODBO.
What is an example of a selective data load using SAP Landscape Transformation? Selected data field values are randomized and loaded into SAP HANA. Selected units or currencies are converted into recalculated amounts or values and loaded into SAP HANA. Selected data for transformation is split into portions. Selected data for a range of years is loaded into SAP HANA.
What is the purpose of a template table in SAP Business-objects Data Services? To create pre-designed information models To fill an existing target table with new data To read source data and perform data transformations To create a target table and fill this table with data.
You have loaded data into SAP HANA using SAP BusinessObjects Data Services.
Where can you view that data? (Choose two) In the Catalog node of SAP HANA studio In the SAP BusinessObjects Data Services job monitor In the Content node of SAP HANA studio In the SAP BusinessObjects Data Services table preview.
You modify an existing view. How can you determine which models are affected by this change? Use the audit trail. Use the History feature for the changed model. Use the "Where-Used List" feature for the changed model. Use the "Auto Documentation" to compare the object version of the changed model.
Which SAP BusinessObjects reporting tool should you use to answer ad-hoc questions and interact with shared information? Crystal Reports Dashboards Explorer WebIntelligence.
You have imported models from the development system. What is the recommended way to activate 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.
Which security settings can you apply in analytic privileges?
(Choose two) Grant access to analytic views. Restrict access within an analytic view using measure values. Restrict access within an analytic view using attribute values. Restrict access to hierarchies.
Which of the following tasks are prerequisites for creating a hierarchy in SAP HANA?
(Choose three) Define an output structure for the attribute view. Define the data foundation. Choose the type of hierarchy. Define calculated attributes for the nodes of the hierarchy. Define an analytic view.
Your customer has the following reporting requirements:
-Real-time profitability reporting on large-scale data volumes -On-the-fly analysis of profitability data at any level of granularity, aggregation, and dimension -Cost allocation reports with significantly faster processing time Which application do you recommend? SAP Bank Analyzer with SAP HANA SAP Deposits Management with SAP HANA SAP HANA CO-PA Accelerator SAP HANA for Banking.
You develop a disaster recovery plan. What do you have to consider in case of a disk failure?
(Choose three) Configuration files can be restored automatically. Save points can be backed up. Log volumes can be backed up. Non-committed transactions can be recovered. Committed transactions can be recovered.
Which SAP tool would you use for data cleansing before data is loaded into SAP HANA? SAP Business-objects Information Steward SAP Business-objects Data Services SAP Landscape Transformation SAP Net-Weaver Master Data Management.
Which tasks do you have to perform if you want to use SAP BW with SAP HANA as the underlying database? Recreate SAP BW indexes after SAP HANA database migration. Do a heterogeneous system copy from your current DB to SAP HANA DB. Ensure that you have at least SAP Net-Weaver Business Warehouse 7.02 installed. Do a homogeneous system copy from your current DB to SAP HANA DB.
Which of the following tasks must you perform before you build a business layer within the SAP BusinessObjects Information Design Tool (IDT) on top of SAP HANA? (Choose three) Publish the connection to CMS. Build a query to test the connection. Build a relational connection to SAP HANA. Build an OLAP connection to SAP HANA. Build a data foundation.
Which connectivity options can you use to create a SAP BusinessObjects universe on SAP HANA? (Choose two) OLAP connection using MDX Relational connection using BICS Relational connection using ODBC Relational connection using MDX Relational connection using JDBC.
You want to report on data from SAP HANA using MS Excel. How can you achieve this? (Choose two) Select an analytic view using the Data Connection wizard. Create a ODBC connection between SAP HANA and MS Excel. Select an attribute view using the Data Connection wizard. Create an ODBO connection between SAP HANA and MS Excel.
Which of the following are functions of the DB trigger within SAP Landscape Transformation (SLT)?
(Choose two) Ensure that replicated changes are kept within the logging tables. Record relevant changes in logging tables. Include only relevant tables for DB recording. Decluster table classes into a transparent format.
When must you create a calculation view in SAP HANA?
(Choose two) When you need to perform join operations. When you need calculations before aggregations. When key figures span across tables. When you need to perform a union of base tables.
How can you improve the performance of a report that is based on SAP HANA data?
(Choose two) Ensure that all SAP HANA tables are in the same schema. Maintain appropriate constraint filters in SAP HANA. Ensure that all calculations are pushed down to the SAP HANA database. Gather new database statistics.
You need to run a Web Intelligence report that requires data from SAP HANA filtered for a specific year based on ad hoc user input. For best performance, how would you achieve this? Use a pre-defined prompt based on a self-join in the business layer. Use input from a Web Intelligence report passed to a variable in an information model. Use a dynamic transformation rule during data provisioning. Use a prompt in the query of the Web Intelligence report.
For what purpose do you use SQL Script in SAP HANA?
(Choose two) To transfer a large amount of data between engines To achieve very high performance on SELECT statements To combine two analytic views To create database procedures To shift complex calculations and logic to the client side.
How can you improve the performance of an information model?
(Choose three) Use generated columns. Use analytic views wherever possible. Use indexes on all measures. Use attribute views wherever possible. Use constraint filters.
Which technologies use trigger-based replication?
(Choose two) ABAP extractors Test Data Migration Server (TDMS) Standard SQL database replication Near Zero Downtime.
Which of the following are required to build a SQL Script calculation view?
(Choose two) Define a data foundation. Define a measure. Set the Multi-dimensional Reporting property to false. Add columns to the var_out output parameter.
A company needs to load external data from a flat file into SAP HANA.
How can you do this? (Choose two) SAP HANA Direct Extractor Connection (DXC) SAP System Landscape Transformation (SLT) SAP HANA SQL Import statement SAP Business Objects Data Services.
Which of the following properties of a derived attribute view can you modify? Description Description mapping Calculated attributes Filters.
Which of the following can you use to build the data foundation for an attribute view? (Choose two) Referential Join Union Projection Text Join.
How can you create a computed column in an information model? (Choose two) Create a calculated attribute within a calculation view. Create a counter in an analytic view. Create a restricted measure in a calculation view. Create a restricted measure in an analytic view.
You have an SAP HANA productive system with sensitive data.How can you restrict modeling users from viewing this data? (Choose two) Remove ALTER SYSTEM in the system privileges for the modeling users. Use randomized data for the development of data models. Allow modeling only on the SAP HANA development system and export/import the models to the productive system. Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users.
What are benefits of using an SAP BusinessObjects business layer on top of SAP HANA? (Choose two) Business layers can be exported to the SAP Business-objects repository and be used by SAP Business-objects client tools. Reporting users can change replication settings in the business layer to access more data. Business layers can be exported to an SAP HANA database and be used for modeling. Reporting users can create individual reports based on separate information models using one business layer.
Which SAP Business Objects tool do you use to visualize real-time key performance indicators with simulations? Explorer Analysis, edition for OLAP Web Intelligence Dashboards.
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).
Which of the following CE functions can you use to query an analytic view directly? CE_CALC CE_AGGREGATION CE_OLAP_VIEW CE_JOIN_VIEW.
Which package privileges are required to extend an SAP HANA Live view?
Note: There are 3 correct answers to the question REPO.ACTIVATE_NATIVE_OBJECTS REPO.EDIT_IMPORTED_OBJECTS REPO.READ REPO.EDIT_NATIVE_OBJECTS REPO.MAINTAIN_NATIVE_PACKAGES.
Which view in SAP HANA studio do you use to add additional users? Properties View Quick launch View Console View Navigator View.
HANA Currency Conversion supported only via ___ Analytic Attribute Calculation Analytic / Calculation.
Which of the following can you set up to enable the extraction of data from SAP Business Warehouse (BW) into SAP HANA?
Note: There are 3 correct answers to the question SAP System Landscape Directory (SLD) SAP Business Objects Data Services SAP Landscape Transformation (SLT) Open hub SAP HANA Direct Extractor Connection (DXC).
What are the key benefits of using SAP Business Objects Explorer with SAP HANA?
Note: There are 3 correct answers to the question 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.
What is the default maximum number of rows in Data preview? 500 1000 5000 10000.
SAP delivered content Information models can be activated from? Import Migrate Mass Copy All of the above.
Auto-documentation generates technical design document in which format? .doc .pdf .xml All of the above.
Calculation engine performs the following: Create joins at run-time Create calculated measures & calculated attributes Compute & executes Calculation Views All of the above.
The HANA optimized Info cubes has the following features No dimension tables No secondary fact-table They represent “flat structures All of the above.
LT replication “Schema” can be configured to support extraction jobs as follows: Real-Time Schedule by Interval Schedule by Time All of the above.
For Time Attribute views, which calendar types can be created?
Note: There are 2 correct answers to the question Gregorian calendar Fiscal calendar Factory calendar All of the above.
Security & Authorization of SAP HANA is required to maintain the following? Control access to objects/views Field-level security Restrict users from viewing Information models All of the above.
Which of the following cardinalities are supported in Attribute view?
(Choose 3) 1:N N:1 1:1 N:N All of the above.
Pre-requisite to execute Crystal reports enterprise?
Note: There are 2 correct answers to the question JDBC/ODBC interfaces Relational Universe MDX All of the above.
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? Shared network drive SAP Business Objects Information Design Tool SAP HANA database SAP HANA studio Content node.
Which SAP tool would you use for data cleansing before data is loaded into SAP HANA? SAP BusinessObjects Information Steward SAP BusinessObjects Data Services SAP Landscape Transformation SAP NetWeaver Master Data Management.
Which transaction is used for releasing extractors specified by the customers in SLT? RODPS_OS_OPEN RODPS_OS_CLOSE RODPS_OS_EXPOSE RODPS_OS.
Which feature is supported by the backup and recovery process within the standard delivery of SAP HANA? Incremental backup Information model recovery Point-in-time recovery Automatic backup of archiving log files scheduled within SAP HANA.
What outputs can you create in an attribute view?
Note: There are 2 correct answers to the question Calculated Measures Key Attributes Calculated Attribute Restricted Measures Private Attributes.
If you want to create or drop tables in a schema, which privilege type do you need?
Note: There is 1 correct answers to the question SYSTEM ANALYTIC PACKAGE SQL.
In which tool can you create information spaces for reporting? SAP HANA modeler perspective SAP HANA SQL editor SAP Business Objects Explorer Information Design Tool.
Which of the following are functions of the controller in the SAP Landscape Transformation (SLT) server?
Note: There are 2 correct answers to the question Create repositories in the source system Write data to the SAP HANA system using the DB connection Map database structures between SAP HANA and the source system Schedule replication processes.
Which of the following is used to make hierarchies available to reporting tools? CE Functions MDX SQLScript SQL.
You discover row count discrepancies between source data and SAP HANA information models. Which of the following can you investigate to find the source of the discrepancies?
Note: There are 2 correct answers to the question Client filtering in the Delivery unit view Joins in information models Memory leaks Client filtering in SAP Landscape Transformation (SLT).
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?
Note: There are 2 correct answers to the question Activation status of the information models Transaction SAP ERP Data Modeler (SD11) Transaction LTR on SLT Data Provisioning view in SAP HANA studio.
When must you create a calculation view in SAP HANA? When you need to create a star schema When key figures (measures) span across tables When you need calculations before aggregations When you need analytic operations like aggregation.
What is an example of a selective data load using SAP Landscape Transformation? Selected data field values are randomized and loaded into SAP HANA Selected units or currencies are converted into recalculated amounts or values and loaded into SAP HANA Selected data for transformation is split into portions Selected data for a range of years is loaded into SAP HANA.
You want to create a custom attribute in addition to your data model. How can you achieve this? Create the attribute as a calculated attribute within the analytic view Create the attribute and add it to the appropriate system table manually Create the attribute as a calculated measure within the attribute view Create the attribute as a restricted attribute within the calculation view.
Which of the following sequences of steps is used to implement SAP HANA with SAP ERP? Data Provisioning => SAP HANA system setup => Modeling => Consumption SAP HANA system setup => Modeling => Data Provisioning => Consumption SAP HANA system setup => Data Provisioning => Modeling => Consumption SAP HANA system setup => Data Provisioning => Consumption => Modeling.
Which data store type is recommended for write-intensive scenarios? Row store Column store Object store Table store.
Which delivered role is mandatory for a system administrator in SAP HANA? SYS_ADMIN IC MODELER CONTENT_ADMIN SAP_ALL.
What is the purpose of the save-point process in SAP HANA? Free-up memory by saving less used data to the persistent storage Save changed data and logs to the persistent storage on a regular basis Save changed data to the persistent storage when a transaction is committed Save logs to persistent storage when a transaction is committed.
Which best practices should you apply when you use SQL script in SAP HANA?
Note: There are 3 correct answers to the question Use the WHERE clause for updates Use UNION ALL instead of UNION Use dynamic SQL with variables Use Cursors Use CE functions.
How many result tables can a calculation view generate per session? Unlimited One Two None.
What are the advantages of using SAP BusinessObjects Data Services to load data into SAP HANA?
Note: There are 3 correct answers to the question You can use the same hardware You can load unstructured data into SAP HANA You can use BI Content Extractors or Function Modules You can merge Data Streams You can perform real-time data replication.
What is one of the advantages of using SAP BusinessObjects Analysis edition for Microsoft Office? Direct access to attribute views in SAP HANA Direct connection to SAP HANA via BICS Direct connection to SAP HANA via MDX Direct access to column tables in SAP HANA.
What is the behavior of a Text Table Join where language column SPRAS is available? Left Outer Join Right Outer Join Inner Join Referential Join.
To support high availability, which of the following are valid index server actual roles for a 5 node scale-out SAP HANA system? Two masters, two slaves, one standby One master, four slaves One master, three slaves, one standby Four masters, one standby.
Which of the following reduces the amount of data transferred from the OLAP engine to the Calculation Engine? Unions Projections Calculated attributes in an attribute view Calculated attributes in an analytic view.
Which of the following can you use as a source for a graphical calculation view?
Note: There are 3 correct answers to the question Calculation view SQL view Table Decision table Procedure.
Which of the following does an SAP BusinessObjects universe use to communicate with SAP HANA? ABAP SQL MDX BICS.
In which tool can you create information spaces for reporting? In the SAP HANA modeler perspective In the SAP HANA SQL editor In SAP BusinessObjects Explorer In the Information Design Tool.
When must you create a calculation view in SAP HANA?
Note: There are 2 correct answers to the question When you need to perform join operations When you need calculations before aggregations When key figures span across tables When you need to perform a union of base tables.
|
