C_HANAIMP_1 SAP HANA Certified Application Associate Exam Set 2

What can be used as a source for the data foundation of an analytic view? (Choose two)A. A table that contains surrogate IDs referring to primary keys in the attribute viewsB. A table that contains foreign keys referring to primary keys in the attribute viewsC. A table that contains business facts or measuresD. A table that contains only descriptive attributes


Options are :

  • B,D
  • A,C
  • B,C (Correct)
  • B,A

Answer : B,C

SAP C_TSCM66_66 Certified Associate Logistics Execution Exam Set 5

Which SAP BusinessObjects reporting tool should you use to answer ad-hoc questions andinteract with shared information?


Options are :

  • Dashboards
  • WebIntelligence (Correct)
  • Crystal Reports
  • Explorer

Answer : WebIntelligence

If you want to create or drop tables in a schema, which privilege type do you need?


Options are :

  • SQL (Correct)
  • PACKAGE
  • SYSTEM
  • ANALYTIC

Answer : SQL

When you activate an analytic view, a column view is created. In which schema is this columnview stored?


Options are :

  • _SYS_BIC (Correct)
  • _SYS_BI
  • _SYS_REPO
  • _SYS

Answer : _SYS_BIC

SAP C_TSCM42_66 Certified Associate Production Planning Exam Set 6

Which SAP HANA model is recommended for reporting purposes where read operations on massdata are required?


Options are :

  • Calculation view using SQL
  • Attribute view
  • Calculation view using SQL Script
  • Analytic view (Correct)

Answer : Analytic view

You have imported models from the development system. What is the recommended way toactivate dependent models in SAP HANA?


Options are :

  • Use the Activate with History function
  • Activate each view manually
  • Use the Where-Used List function
  • Use the Cascade Activate function. (Correct)

Answer : Use the Cascade Activate function.

How can you assess the quality of the loaded data in SAP HANA? (Choose two)A. Configure the SAP Landscape Transformation tool to implement the data quality process.B. Compare data from reports in SAP BusinessObjects against the SAP HANA_SYS_STATISTICS table.C. Perform master data quality checks in SAP ERP prior to replication in SAP HANA.D. Compare reports in SAP BusinessObjects against source data for specific selections.


Options are :

  • A,D
  • C,A
  • C,D (Correct)
  • C,B

Answer : C,D

SAP C_TSCM42_66 Certified Associate Production Planning Exam Set 1

In which tool can you create information spaces for reporting?


Options are :

  • in the SAP HANA modeler perspective
  • in SAP BusinessObjects Explorer (Correct)
  • in the SAP HANA SQL editor
  • in the Information Design Tool

Answer : in SAP BusinessObjects Explorer

SAP C_THR12_66 Certified Associate - Human Capital Exam Set 1

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?


Options are :

  • SELECT on _SYS_REPO with the grant option
  • SELECT on _SYS_REPO
  • REPO.READ for the package (Correct)
  • REPO.MAINTAIN_NATIVE_PACKAGES for the package

Answer : REPO.READ for the package

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.


Options are :

  • D,B
  • A,D
  • A,C
  • A,B (Correct)

Answer : A,B

Which of the following nodes can you use when you create a calculation view with the SAP HANAstudio graphical interface? (Choose two)A. Data FoundationB. AggregationC. JoinD. Analytic Privilege


Options are :

  • A,C
  • D,C
  • None of the Above
  • A,D
  • B,C (Correct)

Answer : B,C

SAP C_THR12_66 Certified Associate - Human Capital Exam Set 4

Which of the following must you do in order to use SAP BusinessObjects Explorer on SAP HANAdata? (Choose two)A. Create a delivery unit.B. Create a business layer.C. Create an information model.D. Create an information space.


Options are :

  • B,D
  • C,B
  • C,D (Correct)
  • C,A

Answer : C,D

What does the following SQL statement do?SELECTSCORE() as SCORE, PRODUCT_NAME, *FROMPRODUCT_ITEMSWHERECONTAINS(*,'Paper', FUZZY(0.8))ORDER BYPRODUCT_NAME


Options are :

  • 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 all columns in the PRODUCT_NAME table for 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'. (Correct)

Answer : It performs a fuzzy search of all columns in the PRODUCT_ITEMS table for the term 'Paper'.

Which of the following automatically aggregates data? (Choose two)A. Analytic viewB. Calculation viewC. Column tableD. Attribute view


Options are :

  • A,D
  • A,C
  • A,B (Correct)
  • D,B

Answer : A,B

SAP C_TSCM52_66 Certified Associate Financial Accounts Test Set 2

Which of the following does an SAP BusinessObjects universe use to communicate with SAPHANA?


Options are :

  • MDX
  • ABAP
  • SQL (Correct)
  • BICS

Answer : SQL

Using SAP BusinessObjects Data Services, in which of the following can you perform datatransformations? (Choose two)A. QueryB. DatastoreC. XML FileD. Script


Options are :

  • A,B
  • A,D (Correct)
  • A,C
  • B,D

Answer : A,D

Which of the following can you set up to enable the extraction of data from SAP BusinessWarehouse (BW) into SAP HANA? (Choose three)A. SAP System Landscape Directory (SLD)B. SAP BusinessObjects Data ServicesC. SAP Landscape Transformation (SLT)D. Open hubE. SAP HANA Direct Extractor Connection (DXC)


Options are :

  • C,D,E
  • B,D,E (Correct)
  • B,A,E
  • B,D,C

Answer : B,D,E

SAP C_TADM51702 Certified Technology Associate - System Exam Set 1

Where is the physical data stored, on which a calculation view is based?


Options are :

  • In the _SYS_BI schema
  • In the _SYS_BIC schema
  • In a package
  • In a schema (Correct)

Answer : In a schema

Which of the following sequences of steps is required before you can create a report on ananalytic view using replicated SAP ERP data?


Options are :

  • Set up replication from ERP ? Create an analytic view ? Create analytic privileges ? Create a business layer (Correct)
  • Create an analytic view ? Set up replication from ERP ? Create analytic privileges ? Create a business layer
  • Create an analytic view ? Create analytic privileges ? Set up replication from ERP ? Create a business layer
  • Create a business layer ? Set up replication from ERP ? Create an analytic view ? Create analytic privileges

Answer : Set up replication from ERP ? Create an analytic view ? Create analytic privileges ? Create a business layer

Which tool do you use for real-time data provisioning into SAP HANA?


Options are :

  • SAP Landscape Transformation (SLT) (Correct)
  • SAP Direct Extractor Connection (DXC)
  • SAP BusinessObjects Data Federation Administration
  • SAP BusinessObjects Data Services

Answer : SAP Landscape Transformation (SLT)

SAP C_TSCM66_66 Certified Associate Logistics Execution Exam Set 5

Which of the following must you avoid to ensure your calculation view uses only the calculationengine? (Choose three)A. Combining SQL and CE FunctionsB. Reading from tables in the column storeC. Reading from tables using SELECT statementsD. Joins using SQLE. DO WHILE loops


Options are :

  • B,E,D
  • E,C,D
  • A,C,B
  • A,C,D (Correct)

Answer : A,C,D

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 ServicesB. In a row generation transformation in SAP BusinessObjects Data ServicesC. In a SQL WHERE clause in SAP Landscape Transformation (SLT)D. In an ABAP code rule in SAP Landscape Transformation (SLT)


Options are :

  • A,B
  • A,C
  • C,D
  • A,D (Correct)

Answer : A,D

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.


Options are :

  • A,D,E (Correct)
  • C,D,E
  • A,D,B
  • A,B,E

Answer : A,D,E

SAP C_TSCM42_66 Certified Associate - Production Exam Set 6

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?


Options are :

  • SAP BusinessObjects Information Design Tool
  • Shared network drive (Correct)
  • SAP HANA studio Content node
  • SAP HANA database

Answer : Shared network drive

You are experiencing performance problems with SAP BusinessObjects reports based on SAPHANA 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.


Options are :

  • A,B
  • C,D
  • A,C
  • A,D (Correct)

Answer : A,D

Which data provisioning method can you use to load data from SAP business contentDataSources 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


Options are :

  • C,B
  • C,A
  • C,D (Correct)
  • B,D

Answer : C,D

SAP C_THR12_66 Certified Associate - Human Capital Exam Set 5

You have set up replication from SAP ERP using SAP Landscape Transformation (SLT). Younotice 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 modelsB. Transaction SAP ERP Data Modeler (SD11)C. Transaction LTR on SLTD. Data Provisioning view in SAP HANA studio


Options are :

  • C,D (Correct)
  • B,D
  • C,A
  • A,D

Answer : C,D

When table replication is suspended, what does the SAP Landscape Transformation (SLT) serverdo?


Options are :

  • It keeps reading via the RFC connection from the source system but does not load the data into SAP HANA.
  • It prevents the RFC connection from reading the source system logging tables. (Correct)
  • 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.

Answer : It prevents the RFC connection from reading the source system logging tables.

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. DashboardsB. Web IntelligenceC. ExplorerD. Crystal Reports


Options are :

  • B,C
  • B,D (Correct)
  • A,D
  • B,A

Answer : B,D

SAP P_HCMTM_64 Certified Professional - HCM Talent Mngt Exam Set 2

You implemented SAP-delivered business content on SAP HANA. When you try to activate thebusiness content the activation fails.What could be a reason for this?


Options are :

  • The schema mapping was not set up correctly. (Correct)
  • You have not created a calculation view to expose the data to the users.
  • The import of business content was performed with the _SYS_REPO user.
  • The data has not been loaded into SAP HANA memory yet.

Answer : The schema mapping was not set up correctly.

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions