option

Primer test

COMMENTS STADISTICS RECORDS
TAKE THE TEST
Title of test:
Primer test

Description:
Primer test

Author:
AVATAR

Creation Date:
25/04/2016

Category:
Others

Number of questions: 187
Share the Test:
Facebook
Twitter
Whatsapp
Share the Test:
Facebook
Twitter
Whatsapp
Last comments
No comments about this test.
Content:
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 tools can you use to monitor the query time from SAP HANA? Central Management Console Performance tab of the System Monitor Event Viewer SQL Trace.
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 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 of the following are benefits of implementing SAP HANA? (Choose three) 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.
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? In the universe In the Web Intelligence report In the analytic view In the calculation view using an attribute value variable.
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 of the following are direct outputs of an analytic view? (Choose three) Hierarchies Private attributes Restricted attributes Measures Attribute views.
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.
When building a business layer to report on SAP HANA, what do you have to do if you want to display more than 5,000 rows? Remove all filters from the analytic views. Deactivate the Limit Size of Result Set parameter in the Central Management Console. Set the Array Fetch Size parameter to the maximum in the relational connection. Deactivate the Limit Size of Result Set parameter in the business layer.
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.
Which of the following properties of a derived attribute view can you modify? Description Description mapping Calculated attributes Filters.
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).
What outputs can you create in an attribute view? (Choose two) Key Attributes Calculated Attributes Restricted Measures Calculated Measures Private Attributes.
Which technologies use trigger-based replication? (Choose two) ABAP extractors Test Data Migration Server (TDMS) Standard SQL database replication Near Zero Downtime.
Which reporting tool can you use to display native parent-child hierarchies from SAP HANA? Microsoft Excel SAP BusinessObjects WebIntelligence SAP BusinessObjects Analysis, edition for OLAP SAP BusinessObjects Analysis, edition for Microsoft Office.
What is one of the advantages of using SAP BusinessObjects Analysis, edition for Microsoft Office? Direct access to attribute views in SAP HANA Direct access to column tables in SAP HANA Direct connection to SAP HANA via MDX Direct connection to SAP HANA via BICS.
You are building a calculation view and want to select data from an analytic view. How can you achieve better performance for this requirement? Use CE functions Use SQL statements Use L programming Use table indexing.
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 are using SAP BusinessObjects Data Services as your ETL tool. What is the next step required after you have created the DataStore and imported the metadata from an SAP ERP system into SAP HANA? Import data from the SAP ERP system into SAP HANA. Create an SAP BusinessObjects Data Services job to migrate data to SAP HANA. Import the metadata from SAP HANA into SAP BusinessObjects Data Services. Create a connection in SAP BusinessObjects Data Services to the SAP ERP system.
When must you create a calculation view in SAP HANA? When you need to create a star schema When key figures span across tables When you need calculations before aggregations When you need analytic operations like aggregation.
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 of the following are functions of the controller in the SAP Landscape Transformation (SLT) server? (Choose two) 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.
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.
You create an analytic view and want to restrict access to departments with specific values using analytic privileges. Which tasks do you have to perform to accomplish this? (Choose three) Assign restricted values to the attribute view. Assign values to be restricted. Choose at least one information model to assign restrictions. Assign the analytic privilege to a user or role. Assign values to be restricted to a content table. Choose an attribute to define restricted values for it.
Your customer wants to implement a SAP product that: - Providesnear real-time replication to SAP HANA - ConnectsSAP HANA to a non-SAP source system and SAP BW - UsesSAP extractors What do you recommend? SAP Legacy System Migration Workbench (LSMW) SAP Landscape Transformation (SLT) Sybase Replication Server SAP BusinessObjects Data Services 4.0.
Which of the following steps is required for configuring SAP Landscape Transformation (SLT)? Define the number of background work processes in SLT. Define an RFC connection from SLT to SAP HANA. Define a DB connection from SLT to the source system. Define the number of jobs to be used for data replication.
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 NetWeaver Business Warehouse 7.02 installed. Do a homogeneous system copy from your current DB to SAP HANA DB.
Which statement best describes an analytic view as a multidimensional view? Analytic views are composed of one data foundation and one or more attribute views. Analytic views are composed of at least one attribute view joined with more than one data foundation. Analytic views are composed of multiple joined data foundations. Analytic views are composed of at least one attribute view.
Which of the following authentication methods are supported for Single Sign-On for SAP HANA? Kerberos LDAP over SSL Secure Network Communication (SNC) SAML CAS (Central Authentication Service).
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 application enables you to create a multisource universe in SAP BusinessObjects BI 4.0? SAP HANA Studio Information Design Tool Universe Design Tool Information Engine.
What can you use to transform data from SAP Business Warehouse (BW) into SAP HANA? SAP Landscape Transformation (SLT) SAP BW extractors SAP BusinessObjects Data Services SAP Legacy System Migration Workbench (LSMW).
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. Savepoints can be backed up. Log volumes can be backed up. Non-committed transactions can be recovered. Committed transactions can be recovered.
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.
What are the key benefits of using SAP BusinessObjects Explorer with SAP HANA? (Choose three) 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.
How can you improve the quality of your information model design? (Choose three) Use ‘case’ or ‘if’ statements whenever possible. Use row-based database expressions. Design your views to be reusable. Modularize your views. Avoid duplications in your modeling.
Which SAP BusinessObjects tool do you use to visualize real-time key performance indicators with simulations? Explorer Analysis, edition for OLAP Web Intelligence Dashboards.
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.
You want to broadcast reports that use data from SAP HANA.Which SAP BusinessObjects tool do you use? Analysis, edition for OLAP Dashboards Crystal Reports Explorer.
What can be used as a source for the data foundation of an analytic view? (Choose two) A table that contains surrogate IDs referring to primary keys in the attribute views A table that contains foreign keys referring to primary keys in the attribute views A table that contains business facts or measures A table that contains only descriptive attributes.
If you want to create or drop tables in a schema, which privilege type do you need? SYSTEM ANALYTIC PACKAGE SQL.
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.
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 SAP BusinessObjects reporting tool should you use to answer ad-hoc questions and interact with shared information? Crystal Reports Dashboards Explorer WebIntelligence.
How can you assess the quality of the loaded data in SAP HANA? (Choose two) Configure the SAP Landscape Transformation tool to implement the data quality process. Compare data from reports in SAP BusinessObjects against the SAP HANA _SYS_STATISTICS table. Perform master data quality checks in SAP ERP prior to replication in SAP HANA. Compare reports in SAP BusinessObjects against source data for specific selections.
Which SAP HANA model is recommended for reporting purposes where read operations on mass data are required? Analytic view Calculation view using SQL Calculation view using SQL Script Attribute view.
Which types of calendar are available for time attribute views in SAP HANA? (Choose two) Fiscal Factory Gregorian Julian.
Which of the following operations can you use when you create a calculation view using the SAP HANA studio graphical interface? (Choose two) PROJECTION UNION INTERSECT INSERT.
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 CONTENT_ADMIN SAP_ALL IC MODELER.
What is the purpose of the savepoint process in SAP HANA? Save changed data to the persistent storage when a transaction is committed. Save logs to persistent storage when a transaction is committed. Save changed data and logs to the persistent storage on a regular basis. Free-up memory by saving less used data to the persistent storage.
Which best practices should you apply when you use SQL script in SAP HANA? (Choose three) Use the WHERE clause for updates. Use UNION ALL instead of UNION. Use dynamic SQL with variables. Use cursors. Use CE functions.
You want to create a graphical calculation view using the SAP HANA studio. Which steps are mandatory for this task? (Choose three) Define a projection. Write an SQL script. Save and activate the view. Define output fields. Choose a data source.
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? (Choose three) You can load unstructured data into SAP HANA. You can merge data streams. You can use the same hardware. You can perform real-time data replication. You can use BI Content extractors or function modules.
For what purpose do you use SQL Script in SAP HAN? (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.
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 are benefits of using accelerators with SAP HANA? (Choose two) They provide pre-built business content. They provide pre-built customer-specific solutions. They reduce the time required for implementation. They eliminate the need for customization.
How can you evaluate the speed of a calculation within the database? (Choose two) Use the Data Preview function in the SAP HANA studio. Execute a Web Intelligence report and check the duration of the previous refresh. Execute an information space using SAP BusinessObjects Explorer. Write and execute an appropriate SQL statement.
You are running an SAP BusinessObjects WebIntelligence report that fetches data from SAP HANA. Which components will be used inside SAP HANA for providing data to this report? (Choose two) Persistence Layer MDX Session Management Authorization Manager.
You want to design a model in SAP HANA. Which of the following modeling constructs do you use to create an analytic view? (Choose three) Join types Attribute views User privileges Tables Analytic views.
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.
Which SAP BusinessObjects tool do you use to visualize real-time key performance indicators with simulations? Explorer Analysis, edition for OLAP Web Intelligence Dashboards.
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.
Where does SAP recommend you create calculated measures? In a column view In a business layer In an attribute view In an analytic view.
You want to test the quality of SAP HANA data by using a set of results from the source system. How can you retrieve the required data from SAP HANA? (Choose three) Use SAP Landscape Transformation (SLT). Use the data preview in SAP HANA studio. Use an SAP BusinessObjects client tool (such as Explorer or Web Intelligence). Use the database schema _SYS_REPO. Write and execute an appropriate SQL statement.
Which of the following privileges do you need to activate views? SELECT option on the _SYS_BIC schema SELECT option on the _SYS schema SELECT option on the _SYS_BI schema SELECT option on the _SYS_REPO schema.
In a reporting scenario you use an Opening Date attribute in the data foundation that contains information about your stores. You want to determine the number of years each store has been in business. How do you achieve this? Use calculated measures. Use time attributes. Use calculated attributes. Use private attributes.
Which SAP BusinessObjects tools require an SAP BusinessObjects semantic layer (universe) to access data in SAP HANA? (Choose three) Crystal Reports 2011 Crystal Reports for Enterprise Dashboards Analysis Office v1.1 WebIntelligence.
What are benefits of using a business layer on top of SAP HANA? (Choose two) An extra layer of granular security Improved database calculation speed Fast throughput via BICS connectivity Users can use business names instead of technical names.
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.
When must you create a calculation view in SAP HANA? When you need to create a star schema When key figures span across tables When you need calculations before aggregations When you need analytic operations like aggregation.
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.
Which new connection type is available as of SAP BusinessObjects Data Services 4.0? Operational Data Provider BAPI function calls IDOCs Read table via ABAP data flows.
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.
Which of the following tools can you use to monitor the query time from SAP HANA? Central Management Console Performance tab of the System Monitor Event Viewer SQL Trace.
What are the advantages of using SAP BusinessObjects Data Services to load data into SAP HANA? (Choose three) You can load unstructured data into SAP HANA You can merge data streams. You can use the same hardware. You can perform real-time data replication. You can use BI Content extractors or function modules.
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.
How can you improve the quality of your information model design? (Choose three) Use ‘case’ or ‘if’ statements whenever possible Use row-based database expressions Design your views to be reusable. Modularize your views Avoid duplications in your modeling.
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.
If you want to create or drop tables in a schema, which privilege type do you need? SYSTEM ANALYTIC PACKAGE SQL.
Which view in SAP HANA studio do you use to add additional users? Properties View Quick launch View Console View Navigator View.
Which tool do you use for complex data transformation of SAP ERP data? SAP Landscape Transformation (SLT) Sybase Replication Server SAP BusinessObjects Data Services SAP BusinessObjects Explorer.
You need to retrieve data from SAP HANA that is restricted to a certain region and specific users. How can you implement this security strategy? By assigning SQL privileges to the necessary users By assigning Analytic privileges to the necessary users By assigning System privileges to the necessary users By assigning Package privileges to the necessary users.
You create a business layer in the SAP BusinessObjects Information Design Tool (IDT). Which of the following could you add to the data foundation? (Choose two) Packages Column Tables Synonyms Information Models.
You implemented SAP-delivered business content on SAP HANA. When you try to activate the business content the activation fails. What could be a reason for this? You have not created a calculation view to expose the data to the users. The data has not been loaded into SAP HANA memory yet. The schema mapping was not set up correctly. The import of business content was performed with the _SYS_REPO user.
You want to allow another developer to access the information models in one of your packages. What privilege do you have to assign to this user to allow access? SELECT on _SYS_REPO SELECT on _SYS_REPO with the grant option REPO.READ for the package REPO.MAINTAIN_NATIVE_PACKAGES for the package.
Which data provisioning method can you use to load data from SAP business content DataSources into SAP HANA? (Choose two) SAP Landscape Transformation (SLT) SAP Landscape Directory (SLD) SAP Direct Extractor Connection (DXC) SAP BusinessObjects Data Services.
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.
Which of the following can you use as a source for a graphical calculation view? (Choose three) Calculation view SQL view Decision table Table Procedure.
Which of the following can you check to investigate the query time in SAP HANA?(Choose three) The SQL plan cache The Central Management Console The expensive statements trace The statistics server warning for long running statements The System information tab of the Administration console.
You create a role with the following command: CREATE ROLE "InfoUser" When you try to assign this role to user PETER with the following command: GRANT InfoUser to PETER you receive an error message "Invalid user privilege: INFOUSER". What must you do to avoid this problem? (Choose three) Recreate the role with the command CREATE ROLE InfoUser. Recreate user PETER with GRANT OPTION. Grant the role the WITH ADMIN OPTION. Recreate the role with the command CREATE ROLE INFOUSER. Grant the role with the command GRANT "InfoUser" to PETER.
Which of the following can you set up to enable the extraction of data from SAP Business Warehouse (BW) into SAP HANA? (Choose three) SAP System Landscape Directory (SLD) SAP BusinessObjects Data Services SAP Landscape Transformation (SLT) Open hub SAP HANA Direct Extractor Connection (DXC).
Which of the following does an SAP BusinessObjects universe use to communicate with SAP HANA? ABAP SQL MDX BICS.
Which of the following must you do in order to use SAP BusinessObjects Explorer on SAP HANA data? (Choose two) Create a delivery unit. Create a business layer. Create an information model. Create an information space.
Where is the physical data stored, on which a calculation view is based? In the _SYS_BI schema In a schema In the _SYS_BIC schema In a package.
Which of the following automatically aggregates data? (Choose two) Analytic view Calculation view Column table Attribute view.
Which privilege type do you have to assign to a role, when you want to provide row-level access to data? ANALYTIC PACKAGE SYSTEM SQL.
Using SAP BusinessObjects Data Services, in which of the following can you perform data transformations? (Choose two) Query Datastore XML File Script.
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.
During loading of data into SAP HANA you want to filter the source data. Where can you apply the filters? (Choose two) In a query transformation in SAP BusinessObjects Data Services In a row generation transformation in SAP BusinessObjects Data Services In a SQL WHERE clause in SAP Landscape Transformation (SLT) In an ABAP code rule in SAP Landscape Transformation (SLT).
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 BusinessObjects Information Design Tool SAP HANA database SAP HANA studio Content node.
You want to restrict access to SAP HANA information models based on user groups. The models are accessed through an SAP BusinessObjects report. In which of the following can you implement these restrictions? (Choose two) The schema mapping The restricted measures The analytic privileges The universe.
Which of the following must you avoid to ensure your calculation view uses only the calculation engine? (Choose three) Combining SQL and CE Functions Reading from tables in the column store Reading from tables using SELECT statements Joins using SQL DO WHILE loops.
Which of the following sequences of steps is required before you can create a report on an analytic view using replicated SAP ERP data? Set up replication from ERP -> Create an analytic view -> Create analytic privileges -> Create a business layer Create a business layer -> Set up replication from ERP -> Create an analytic view -> Create analytic privileges Create an analytic view -> Create analytic privileges -> Set up replication from ERP -> Create a business layer Create an analytic view -> Set up replication from ERP -> Create analytic privileges -> Create a business layer.
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'.
A company wants to use SAP BusinessObjects reporting tools. They cannot use Adobe Flash. They require scheduled, ready-made reports. Which reporting tool do you recommend? (Choose two) Dashboards Web Intelligence Explorer Crystal Reports.
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? (Choose two) 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.
A customer wants to report on large amounts of SAP HANA data. The users want to drill from the top aggregation level to the lowest granularity and try different types of graphical representations of the data on the fly. Which SAP BusinessObjects reporting tool would you recommend? SAP BusinessObjects Dashboards SAP BusinessObjects Web Intelligence SAP BusinessObjects Explorer SAP BusinessObjects Crystal Reports for Enterprise.
Which of the following are required elements when you create any type of hierarchy in SAP HANA? (Choose two) A child node An analytic view A data foundation An attribute view.
On which of the following servers can you configure SAP HANA Direct Extractor Connection (DXC) data sources? (Choose two) SAP Business Warehouse server SAP BusinessObjects Data Services server SAP HANA server SAP ECC server.
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? (Choose two) 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.
How can you restrict SAP HANA modeling users from viewing sensitive data? Use scrambled source data. Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users. Use the pre-delivered MODELER role. Remove ALTER SYSTEM in the system privileges for the modeling users.
An analytic view has two columns, SHIP_TO_COUNTRY and SHIP_FROM_COUNTRY, that contain ISO country codes. You must replace these codes with the English country names by joining to the same country attribute view twice. What must you create to achieve this? A derived attribute view A shared attribute view Two data foundations An attribute view using the Copy From method.
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 of the following CE functions can you use to query an analytic view directly? CE_CALC CE_AGGREGATION CE_OLAP_VIEW CE_JOIN_VIEW.
You want to add a column to a calculation view that displays the year-to-date revenue of the current fiscal year. How can you achieve this? (Choose two) Use a calculated attribute. Use a calculated measure. Use a variable. Use a CE function.
Which of the following are required to create an attribute view? (Choose two) Data Foundation Default Schema Join Key Attribute.
You are running an SAP BusinessObjects Web Intelligence report that fetches data from an analytic view. Which of the following 4 components is used by SAP HANA to provide data for this report? SAP host agent Delivery unit XS engine OLAP engine.
Which of the following are required to build a SQLScript calculation view? (Choose two) Define a data foundation. Define a measure. Set the MultiDimensional 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 BusinessObjects Data Services.
Which of the following can you use to build the data foundation for an attribute view? (Choose two) Referential Join Union Projection Text Join.
Which SAP BusinessObjects reporting tool can you use to create a report as shown in the attached screenshot? Web Intelligence Crystal Reports Analysis, edition for OLAP Dashboard.
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.
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 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.
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.
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 BusinessObjects repository and be used by SAP BusinessObjects 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.
What must you configure to directly access an SAP HANA analytic view using SAP BusinessObjects Analysis edition for Microsoft Office? RFC connection SAP HANA Direct Extractor Connection (DXC) Pre-delivered MODELING role System DSN.
Which of the following is used to make hierarchies available to reporting tools? CE Functions MDX SQLScript SQL.
What is the purpose of a template table in SAP BusinessObjects 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.
Which of the following tasks must you perform before you publish a universe within the SAP BusinessObjects Information Design Tool (IDT) on top of SAP HANA? (Choose two) Add the INFORMATION_CONSUMER role to the user. Add dimensions and measures to the business layer. Add information models to the data foundation. Add an information space to the business layer.
You define a measure CURR_CONV to perform a currency conversion in an analytic view. When you query the analytic view it fails with a currency/unit conversion error message. What can you do to ensure that the query runs without error message? (Choose two) Maintain valid conversion rate entries in TCUR tables Set the Upon conversion failure parameter of CURR_CONV to Ignore Remove the Target Currency property in CURR_CONV Unselect the Enable for decimal shifts property in CURR_CONV.
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 dropdown box on the right? RFC ODBC/JDBC BICS ODBO.
You have made modifications to an information model within a delivery unit. You want to export the model to an SAP HANA target system. In the Schema Mapping dialog, where do you define the target system schema? In the Authorization schema In the Authoring schema In the _SYS_BI schema In the Physical schema.
An SAP BusinessObjects Web Intelligence report throws an SQL error during query execution. Which of the following could you check to resolve the error? (Choose two) The business layer The business view The Web Intelligence report variables The SAP HANA information model.
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? Global temporary table Decision table Row table Column table.
What happens when you turn on replication of an SAP ERP source system using SAP Landscape Transformation (SLT)? SLT creates ABAP code in the ERP system that writes to application tables. SLT creates ABAP code in the ERP system that writes to logging tables. SLT creates database triggers in the ERP system that write to logging tables. SLT creates database triggers in the ERP system that write to application tables.
Which of the following are characteristics of using a Rapid Deployment Solution (RDS), such as Operational Reporting for SAP HANA? (Choose two) Relevant tables are replicated. SAP will create information models based on customer requirements. Customized tables and columns are replicated. Pre-designed information models are imported into SAP HANA.
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.
A calculation view that joins one fact table with dimension tables performs slowly. Which of the following can you do to improve performance? Turn the calculation view into an analytic view. Turn the calculation view into a simple calculation view. Load the calculation view into memory. Load the calculation view into the _SYS_BI schema.
User A has to set up tables and views in a database schema that is owned by user B. Which of the following privilege must you grant? CREATE ANY to user A REFERENCES to user A CREATE ANY to user B REFERENCES to user B.
You have to do reverse pivot transformations on large data tables before loading the data into SAP HANA. Which of the following do you recommend to use? SAP Landscape Transformation (SLT) SAP BusinessObjects Data Services 4.0 SAP HANA Direct Extractor Connection (DXC) SAP System Landscape Directory (SLD).
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.
A customer wants to reproduce the following SQL statement in SAP HANA: SELECT P.PROD_NAME, P.PROD_ID, PT.PROD_DESC FROM PRODUCTS P, PROD_TEXTS PT WHERE P.PROD_ID=PT.PROD_ID; Which of the following SQLScript constructs is equivalent to this SQL statement and yields the best performance? ot_products= CE_COLUMN_TABLE(PRODUCTS); ot_prodtexts= CE_COLUMN_TABLE(PROD_TEXTS); ot_all=CE_JOIN(:ot_products, :ot_prodtexts, [PROD_ID]); output=CE_PROJECTION(:ot_all, [PROD_NAME, PROD_ID, PROD_DESC]); SELECT P.PROD_NAME, P.PROD_ID, NULL as PROD_DESC FROM PRODUCTS P UNION SELECT NULL as PROD_NAME, PT.PROD_ID, PT.PROD_TEXTS FROM PROD_TEXTS PT; SELECT P.PROD_NAME, P.PROD_ID, PT.PROD_DESC FROM PRODUCTS P JOIN PROD_TEXTS PT ON P.PROD_ID=PT.PROD_ID; ot_products= CE_COLUMN_TABLE(PRODUCTS); ot_prodtexts= CE_COLUMN_TABLE(PROD_TEXTS); ot_all=CE_UNION_ALL(:ot_products, :ot_prodtexts); output=CE_PROJECTION(:ot_all, [PROD_NAME, PROD_ID, PROD_DESC]);.
Your SAP BusinessObjects report runs slowly. Which of the following actions could improve the performance? (Choose two) Restrict data by using variables in the information model. Tune the Array Fetch Size parameter of the universe. Move calculated measures from the information model to the report. Join all the analytic views with each other in the business layer.
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? (Choose two) 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.
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 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? (Choose two) Client filtering in the Delivery unit view. Joins in information models. Memory leaks. Client filtering in SAP Landscape Transformation (SLT).
When you load data from SAP ECC using SAP BusinessObjects Data Services, where would you create an ABAP data flow? in a query transformation in a batch job in the ABAP editor (transaction SE38) in the Job overview (transaction SM37).
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.
When you activate a procedure, in which schema is the procedure stored? SYSTEM _SYS_BIC SYS_REPL _SYS_BI.
In which of the following can you use a FOR loop over your data? Monitoring View Calculation View Analytic View Attribute View.
Which of the following must an analytic view contain? A measure A calculated measure A hierarchy An attribute view.
In SAP HANA studio, in which of the following can you create users? (Choose two) The Administration console The Roles node The Content node The SQL editor.
You created a model on a table XYZ.PRODUCTS. You successfully activated the model. When you run the data preview you receive an error message "Insufficient privilege. Not authorized". Which of the following 4 statements do you execute to resolve the error before you reactivate the model? GRANT SELECT on SCHEMA XYZ to _SYS_REPO GRANT SELECT on PRODUCTS to _SYS_REPO WITH GRANT OPTION GRANT SELECT on SCHEMA XYZ to _SYS_BIC WITH GRANT OPTION GRANT SELECT on PRODUCTS to _SYS_BIC.
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 of the following nodes can you use when you create a calculation view with the SAP HANA studio graphical interface? (Choose two) Data Foundation Aggregation Join Analytic Privilege.
When table replication is suspended, what does the SAP Landscape Transformation (SLT) server do? It prevents the RFC connection from reading the source system logging tables. It deletes the database triggers and the logging tables in the source system. It stops the RFC connection and deletes the target tables in SAP HANA. It keeps reading via the RFC connection from the source system but does not load the data into SAP HANA.
Which of the following can be part of an analytic view? (Choose three) Query transformation Unions Logical joins Data foundation Attributes.
Which tool do you use for real-time data provisioning into SAP HANA? SAP Landscape Transformation (SLT) SAP BusinessObjects Data Federation Administration SAP BusinessObjects Data Services SAP Direct Extractor Connection (DXC).
You are experiencing performance problems with SAP BusinessObjects reports based on SAP HANA data. Which of the following can you do to increase performance? (Choose two) 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.
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? (Choose two) 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 repeatedly load data from a flat file into SAP HANA with SAP Data Services. The target table is not available in SAP HANA and must be recreated with every scheduled data load. The structure of the target table is identical to the structure of the source table. Which of the following steps must you perform? Note: There are 3 correct answers to this question. Enter the table name and schema name. Import metadata of the target table from the SAP HANA datastore. Drop a template table into the data flow. Map the source structure to the template table. Create a table in the SAP HANA studio.
What are characteristics of a constraint filter? Note: There are 2 correct answers to this question. 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 design time on a table. It is defined during the runtime in the SQL query.
Which connection type is required from the SAP ERP system to SAP HANA to enable a CO-PA side-by-side scenario? Please choose the correct answer. Secondary database connection JDBC HTTP connection Remote Function Call.
You want to create a customer segmentation on your SAP HANA data. Which of the following do you use? Please choose the correct answer. RODBC library SAP HANA Business Function Library SAPUI5 runtime library SAP HANA Predictive Analysis Library.
Two attribute views in the same analytic view contain the same column name: the ID from the Customer attribute view and the ID from the Product attribute view. In the output, the system automatically renamed one column to ID_1. You want to indicate that ID_1 originated from the Product attribute view by renaming it to ID_PRODUCT. Where in the attribute properties of ID_1 can you change this? Note: There are 2 correct answers to this question. In the alias label In the label In the alias name In the name.
You have a replicated an SAP ERP transaction table that contains a language field and a text table containing descriptions in various languages. You create an attribute view by joining these two tables using a text join. As which of the following join types does the text join act in this context? Please choose the correct answer. Referential join Inner join Left outer join Right outer join.
You have a replicated an SAP ERP transaction table that contains a language field and a text table containing descriptions in various languages. You create an attribute view by joining these two tables using a text join. As which of the following join types does the text join act in this context? Please choose the correct answer. Referential join Inner join Left outer join Right outer join.
Which of the following describe an SAP HANA attribute view? Note: There are 3 correct answers to this question. It is a persistent store of data. It is a reusable object in analytic views. It is a copy of data after transformation. It is a set of tables joined together. It is a reusable object in calculation views.
Which CE function do you use to implement an inner join between two tables on a list of join attributes? Please choose the correct answer. CE_COLUMN_TABLE CE_JOIN_VIEW CE_OLAP_VIEW CE_JOIN.
You have created several information models. A colleague has to create new tables in the existing schema and extend your information models. Which privileges do you give to your colleague? Note: There are 2 correct answers to this question. System privileges Analytic privileges Package privileges Object privileges.
Which package privileges are required to extend an SAP HANA Live view? There are 3 correct answers to this question. REPO.MAINTAIN_NATIVE_PACKAGES REPO.EDIT_IMPORTED_OBJECTS REPO.EDIT_NATIVE_OBJECTS REPO.READ REPO.ACTIVATE_NATIVE_OBJECTS.
In which order are views consumed by the SAP HANA Live virtual data model? Please choose the correct answer. 1. Query 2.Reuse 3.Private 1.Query 2.Private 3.Reuse 1.Reuse 2.Query 3.Private 1. Reuse 2.Private 3. Query.
Which of the following SAP data provisioning methods provide complex transformations? There are 2 correct answers to this question SAP Data Services SAP Replication Server SAP HANA smart data access SAP HANA smart data quality.
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? Please choose the correct answer. Input parameter Variable Filter Restricted measure.
How does SAP recommend modeling a view that contains actual measures from one fact table and planned measures from another fact table? Please choose the correct answer. Create one analytic view for each of the fact tables and create a calculation view that implements a join over both analytic views. Create one analytic view for each of the fact tables and create a calculation view that implements a union over both analytic views. Create one attribute view for each of the fact tables and create an analytic view that implements a union over both attribute views. Create one attribute view for each of the fact tables and create a calculation view that implements a join over both attribute views.
In a fuzzy search, when would you perform a freestyle search? Please choose the correct answer. When you want to search in only one column When you want to search in multiple columns When you want to search with a low fuzziness threshold When you want to search with a high fuzziness threshold.
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? Please choose the correct answer. System privilege Package privilege Object privilege Analytic privilege.
For which SAP HANA data types is a FULLTEXT index created automatically during table creation? There are 2 correct answers to this question TEXT NCLOB VARCHAR SHORTTEXT.
What does SAP HANA smart data integration use for data provisioning? There are 3 correct answers to this question. Database triggers Database logs SAP HANA smart data access Real-time adapters SAP HANA smart data streaming.
With which of the following do you build the vocabulary of a decision table? Please choose the correct answer. Attributes Actions Measures Conditions.
Which of the following can you use as sources for the vocabulary in a decision table? There are 3 correct answers to this question. Procedures Physical tables Table types OData models Calculation views.
Which of the following is included in a rapid deployment solution (RDS) implemented on SAP HANA? There are 3 correct answers to this question. A mix of onsite and offsite consulting The SAP HANA database license Guides and educational material SAP best practices and templates Conversion of all BEx queries to analytic views.
Report abuse Terms of use
HOME
CREATE TEST
COMMENTS
STADISTICS
RECORDS
Author's Tests