Questions
ayuda
option
My Daypo

ERASED TEST, YOU MAY BE INTERESTED ON181 - 220

COMMENTS STATISTICS RECORDS
TAKE THE TEST
Title of test:
181 - 220

Description:
a 181 - 220

Author:
LucianoC
(Other tests from this author)

Creation Date:
27/07/2017

Category:
Others

Number of questions: 40
Share the Test:
Facebook
Twitter
Whatsapp
Share the Test:
Facebook
Twitter
Whatsapp
Last comments
No comments about this test.
Content:
181 Which of the following nodes do you use to implement filters in a graphical calculation view? (Choose two) A. Join B. Projection C. Aggregation D. Union.
182 Your Information model needs real-time access to external data stored in Microsoft SQL Server 2011. How can you implement this scenario in SAP HANA? (Choose two) A. Create a virtual table and use it in Attribute view B. Create a batch job in SAP Data Services C. Create a virtual table and use it in a calculation view D. Perform Replication using SAP Replication Server.
183 Which CE Function do you use to implement the following SQL statement? SELECT DATE, SHOP_ID, PRODUCT_ID, QUANTITY * COST AS "PRICE" FROM SALES_DATA; A. CE_AGGREGATION B. CE_CALC_VIEW C. CE_CONVERSION D. CE_CALC.
184 Which of the following Information models does SAP recommend to combine fact table fields with the corresponding master data attributes? (Choose two) A. Database view B. Calculation view C. Analytic view D. Attribute view.
185 You modified an active analytic view in the SAP HANA studio and saved it without activating it. What is the consequence? A. The inactive view is available for reporting. B. The active view is in "read-Only" mode. C. The inactive view is in "read-Only" mode. D. The active view is not available for reporting.
186 Which of the following are mandatory to create a decision table? (Choose two) A. A condition B. An action C. A CE Function D. A parameter.
187 In a SQLScript calculation view, one table variable contains the records that are the result of a SELECT * statement from a database table with 10 fields. You want to use this table variable to populate a new table variable with the same result set, which is restricted to 1 of the 10 fields. Which CE Function do you user A. CE_UNION B. CE_CALC C. CE_COLUMN_TABLE D. CE_PROJECTION.
188 You work with an Information model on SAP HANA that contains sales data for all regions. Which of the following modeling techniques can you use to Define re-usable columns per region? A. Input parameters B. Analytic privileges C. Restricted columns D. Constraint filters.
189 How can you add an existing Attribute view to the logical view of your analytic view twice? (Choose two) A. Copy the Attribute view. B. Create a derived analytic view. C. Create a derived Attribute view. D. Rename the Attribute view.
190 D. Rename the Attribute view. A. The creation of an SAP BEx query reading from the Information model B. The creation of an SAP BusinessObjects Web Intelligence report directly on the Information model C. The definition of objects in an SAP BusinessObjects universe D. The definition of an Information space that reads from the Information model.
191 You want to investigate the runtime of a SELECT statement against an analytic view. Which of the following Tools do you use to analyze the model performance, including transferred data? A. Plan visualizer B. Load graph C. SQL Editor D. SQL Debugger.
192 You want to improve query performance by introducing filters into the SAP HANA Information model. Which of the following can you use to reduce data transfer between views? (Choose two) A. Analytic privileges B. Calculated columns C. Client-independent views D. Constraint filters.
193 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 could you user A. Python-based text Analysis scripts B. Full-text search UI Toolkit C. Application Function libraries D. Fuzzy search.
194 Which of the following can you use to implement currency conversion in an Information model? (Choose two) A. A calculated column in a calculation view B. A calculated column in an Attribute view C. A calculated column in an analytic view D. A restricted column in an analytic view.
195 You have created two analytic views for actual and planned financial data. 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? A. • Create an analytic view. • Combine the analytic views in the new analytic view using a Referential join. B. • Create a calculation view. • Combine the analytic views in the calculation view using a UNION WITH CONSTANT VALUES. C. • Create a calculation view. • Combine the analytic views in the calculation view using a UNION. D. • 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. .
196 Which of the following objects can you use when you Build an analytic view? (Choose three) A. Attribute Views B. Hierarchies C. Variables D. Projections E. Analytic Views.
197 Which of the following is a best practice in calculation views? A. Change an Attribute to a measure. B. Apply a static filter on a Projection node. C. Push calculations down to the Attribute views. D. Combine analytic views with a join node.
198 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)r (Choose three) A. Export the models from System1. B. Create a delivery unit on System1. C. Create a delivery unit on System2. D. Import the models into System2. E. Create a schema on System2.
199 What is the advantage of creating analytic views in SAP HANA over reporting directly from column tables? (Choose two) A. Shifting of complex calculations and logic to SAP HANA. B. Supporting analytical privileges. C. Reporting directly from SAP BusinessObjects Web Intelligence. D. Eliminating the need for additional modeling.
200 Which of the following actions can you do with a derived Attribute view? (Choose two) A. Define the name of the derived Attribute view. B. Use the derived Attribute view in the data foundation of an analytic view. C. Define the output of the derived Attribute view. D. Use the derived Attribute view in the logical join view of an analytic view.
201 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.
202 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.
203 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.
204 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).
205 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.
206 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.
207 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.
208 You implemented SAP-delivered business content on SAP HAN A. When you try to activate the business content the Activation falls. 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.
209 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.
210 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.
211 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.
212 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.
213 Which of the following can you check to investigate the query tie 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.
214 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.
215 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).
216 Which of the following does an SAP BusinessObjects universe use to communicate with SAP HANA? A. ABAP B. SQL C. MDX D. BICS.
217 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.
218 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.
219 Which of the following automatically aggregates data? (Choose two) A. Analytic view B. Calculation view C. Column table D. Attribute view.
220 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.
Report abuse Consent Terms of use