Modeling
Qs:1 Which of the following nodes can you use when you create a calculation view with the SAP HANA studio graphical interface? (Choose two)
A. Data Foundation
B. Aggregation
C. Join
D. Analytic Privilege
Qs:3 Which of the following can be part of an analytic view? (Choose three)
A. Query transformation
B. Unions
C. Logical joins
D. Data foundation E. Attributes
Qs:12 Which of the following can you use as a source for a graphical calculation view? (Choose three)
A. Calculation view
B. SQL view
C. Decision table
D. Table E. Procedure
Qs:18 Where is the physical data stored, on which a calculation view is based?
A. In the _SYS_BI schema
B. In a schema
C. In the _SYS_BIC schema
D. In a package
Qs:19 Which of the following automatically aggregates data? (Choose two)
A. Analytic view
B. Calculation view
C. Column table
D. Attribute view
Qs:25 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)
A. The schema mapping
B. The restricted measures
C. The analytic privileges
D. The universe
Qs:29 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
A. It performs a fuzzy search on all columns in the PRODUCT_NAME table for the term 'Paper'.
B. It performs a fuzzy search count on the number of columns in the PRODUCT_NAME table that contain the term 'Paper'.
C. It performs a fuzzy search on the PRODUCT_NAME column in the PRODUCT_ITEMS table for the term 'Paper'.
D. It performs a fuzzy search of all columns in the PRODUCT_ITEMS table for the term 'Paper'.
Qs:33 Which of the following are required elements when you create any type of hierarchy in SAP HANA? (Choose two
A. A child node
B. An analytic view
C. A data foundation
D. An attribute view
Qs:36 How can you restrict SAP HANA modeling users from viewing sensitive data?
A. Use scrambled source data.
B. Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users.
C. Use the pre-delivered MODELER role.
D. Remove ALTER SYSTEM in the system privileges for the modeling
Qs:37 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. A derived attribute view
B. A shared attribute view
C. Two data foundations
D. An attribute view using the Copy From method.
Qs:41 Which of the following are required to create an attribute view? (Choose two)
A. Data Foundation
B. Default Schema
C. Join
D. Key Attribute
Qs:43 Which of the following are required to build a SQLScript calculation view? (Choose two)
A. Define a data foundation.
B. Define a measure.
C. Set the MultiDimensional Reporting property to false.
D. Add columns to the var_out output parameter.
Qs:45 Which of the following can you use to build the data foundation for an attribute view? (Choose two)
A. Referential Join
B. Union
C. Projection
D. Text Join
Qs:48 How can you create a computed column in an information model? (Choose two)
A. Create a calculated attribute within a calculation view.
B. Create a counter in an analytic view.
C. Create a restricted measure in a calculation view.
D. Create a restricted measure in an analytic view.
Qs:49 You create a graphical calculation view that is based on analytic views. What do you use to combine the data from the analytic views?
A. Referential join
B. Projection node
C. Aggregation node
D. Union
SLT
Qs:2 When table replication is suspended, what does the SAP Landscape Transformation (SLT) server do?
A. It prevents the RFC connection from reading the source system logging tables.
B. It deletes the database triggers and the logging tables in the source system.
C. It stops the RFC connection and deletes the target tables in SAP HANA.
D. It keeps reading via the RFC connection from the source system but does not load the data into SAP HANA.
Qs:4 Which tool do you use for real-time data provisioning into SAP HANA?
A. SAP Landscape Transformation (SLT)
B. SAP BusinessObjects Data Federation Administration
C. SAP BusinessObjects Data Services
D. SAP Direct Extractor Connection (DXC)
Qs:6 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)
A. Activation status of the information models
B. Transaction SAP ERP Data Modeler (SD11)
C. Transaction LTR on SLT
D. Data Provisioning view in SAP HANA studio
Qs:15 Which of the following can you set up to enable the extraction of data from SAP Business Warehouse (BW) into SAP HANA? (Choose three)
A. SAP System Landscape Directory (SLD)
B. SAP BusinessObjects Data Services
C. SAP Landscape Transformation (SLT)
D. Open hub
E. SAP HANA Direct Extractor Connection (DXC)
Qs:23 During loading of data into SAP HANA you want to filter the source data. Where can you apply the filters? (Choose two)
A. In a query transformation in SAP BusinessObjects Data Services
B. In a row generation transformation in SAP BusinessObjects Data Services
C. In a SQL WHERE clause in SAP Landscape Transformation (SLT)
D. In an ABAP code rule in SAP Landscape Transformation (SLT)
Qs:28 Which of the following sequences of steps is required before you can create a report on an analytic view using replicated SAP ERP data?
A. Set up replication from ERP Create an analytic view Create analytic privileges --> Create a business layer
B. Create a business layer --> Set up replication from ERP --> Create an analytic view --> Create analytic privileges
C. Create an analytic view --> Create analytic privileges --> Set up replication from ERP --> Create a business layer
D. Create an analytic view --> Set up replication from ERP --> Create analytic privileges Create a business layer
Qs:31 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)
A. Use the SAP ERP Data Browser (transaction SE16).
B. Use the Catalog node to open table contents.
C. Use transaction IUUC_REPL_CONTENT.
D. Use the Data Provisioning view from the Quick Launch.
SAP BO reports
Qs:5 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)
A. Add only relevant data to the report queries.
B. Avoid aggregation and work on raw data.
C. Merge all relevant data into a consolidated report.
D. Use drill-down or linked reports.
Qs:7 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)
A. Packages
B. Column Tables
C. Synonyms
D. Information Models
Qs:10 Which data provisioning method can you use to load data from SAP business content DataSources into SAP HANA? (Choose two)
A. SAP Landscape Transformation (SLT)
B. SAP Landscape Directory (SLD)
C. SAP Direct Extractor Connection (DXC)
D. SAP BusinessObjects Data Services
Qs:11 Your customer requires real-time replication. Where do you select the tables to be replicated to SAP HANA?
A. in transaction LTR in SAP Landscape Transformation (SLT)
B. in the Import dialog of the Quick Launch of SAP HANA studio
C. in transaction SAP ERP Tables and Indexes Monitor (DB02)
D. in the Data Provisioning dialog of SAP HANA studio
Qs:16 Which of the following does an SAP BusinessObjects universe use to communicate with SAP HANA?
A. ABAP
B. SQL
C. MDX
D. BICS
Qs:17 Which of the following must you do in order to use SAP BusinessObjects Explorer on SAP HANA data? (Choose two)
A. Create a delivery unit.
B. Create a business layer.
C. Create an information model.
D. Create an information space.j
Qs:21 Using SAP BusinessObjects Data Services, in which of the following can you perform data transformations? (Choose two)
A. Query
B. Datastore
C. XML File
D. Script
Qs:22 In which tool can you create information spaces for reporting?
A. in the SAP HANA modeler perspective
B. in the SAP HANA SQL editor
C. in SAP BusinessObjects Explorer
D. in the Information Design Tool
Qs:24 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?
A. Shared network drive
B. SAP BusinessObjects Information Design Tool
C. SAP HANA database
D. SAP HANA studio Content node
Qs:30 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)
A. Dashboards
B. Web Intelligence
C. Explorer
D. Crystal Reports
Qs:32 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?
A. SAP BusinessObjects Dashboards
B. SAP BusinessObjects Web Intelligence
C. SAP BusinessObjects Explorer
D. SAP BusinessObjects Crystal Reports for Enterprise
Qs:34 On which of the following servers can you configure SAP HANA Direct Extractor Connection (DXC) data sources? (Choose two)
A. SAP Business Warehouse server
B. SAP BusinessObjects Data Services server
C. SAP HANA server
D. SAP ECC server
Qs:35 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)
A. Add the columns in SAP Landscape Transformation replication.
B. Add the columns to the query panel of the report.
C. Add the columns to the source table in the catalog node in SAP HANA studio.
D. Add the columns to the business layer.
Qs:42 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?
A. SAP host agent
B. Delivery unit
C. XS engine
D. OLAP engine
Qs:44 A company needs to load external data from a flat file into SAP HANA. How can you do this? (Choose two)
A. SAP HANA Direct Extractor Connection (DXC)
B. SAP System Landscape Transformation (SLT)
C. SAP HANA SQL Import statement
D. SAP BusinessObjects Data Services
Qs:50 You have loaded data into SAP HANA using SAP BusinessObjects Data Services. Where can you view that data? (Choose two)
A. In the Catalog node of SAP HANA studio
B. In the SAP BusinessObjects Data Services job monitor
C. In the Content node of SAP HANA studio
D. In the SAP BusinessObjects Data Services table preview
SAP Business objects tools use which connection technologies when connecting to SAP HANA?
A. MDX & SQL
B.SQL & BICS
C. BICS &MDX
D. SQL & MDX
ACCESS: Privileges
Qs:9 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?
A. SELECT on _SYS_REPO
B. SELECT on _SYS_REPO with the grant option
C. REPO.READ for the package
D. REPO.MAINTAIN_NATIVE_PACKAGES for the package
Qs:8 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?
A. You have not created a calculation view to expose the data to the users.
B. The data has not been loaded into SAP HANA memory yet.
C. The schema mapping was not set up correctly.
D. The import of business content was performed with the _SYS_REPO user.
Qs:13 Which of the following can you check to investigate the query time in SAP HANA? (Choose three)
A. The SQL plan cache
B. The Central Management Console
C. The expensive statements trace
D. The statistics server warning for long running statements
E. The System information tab of the Administration console
Qs:14 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)
A. Recreate the role with the command CREATE ROLE InfoUser.
B. Recreate user PETER with GRANT OPTION.
C. Grant the role the WITH ADMIN OPTION.
D. Recreate the role with the command CREATE ROLE INFOUSER.
E. Grant the role with the command GRANT "InfoUser" to PETER.
Qs:20 Which privilege type do you have to assign to a role, when you want to provide row-level access to data?
A. ANALYTIC
B. PACKAGE
C. SYSTEM
D. SQL
Qs:38 How can you improve the performance of an information model? (Choose three)
A. Use generated columns.
B. Use analytic views wherever possible.
C. Use indexes on all measures.
D. Use attribute views wherever possible.
E. Use constraint filters.
Architecture
Qs:26 Which of the following must you avoid to ensure your calculation view uses only the calculation engine? (Choose three)
A. Combining SQL and CE Functions
B. Reading from tables in the column store
C. Reading from tables using SELECT statements
D. Joins using SQL
E. DO WHILE loops
Qs:39 Which of the following CE functions can you use to query an analytic view directly?
A. CE_CALC
B. CE_AGGREGATION
C. CE_OLAP_VIEW
D. CE_JOIN_VIEW
Qs:40 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)
A. Use a calculated attribute.
B. Use a calculated measure.
C. Use a variable.
D. Use a CE function.
Qs:47 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?
A. The Audit log
B. Entries in M_CONNECTIONS
C. The nameserver_history.trc file
D. The indexserver_alert.trc file
No comments:
Post a Comment