C_HANAIMP_1 SAP HANA Certified Application Associate Exam Set 1

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)A. Maintain valid conversion rate entries in TCUR tablesB. Set the Upon conversion failure parameter of CURR_CONV to IgnoreC. Remove the Target Currency property in CURR_CONVD. Unselect the Enable for decimal shifts property in CURR_CONV


Options are :

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

Answer : A,B

SAP C_TSCM62_65 Certified Associate - Order Fulfilment Exam Set 4

Which of the following are required to create an attribute view? (Choose two)A. Data FoundationB. Default SchemaC. JoinD. Key Attribute


Options are :

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

Answer : A,D

On which of the following servers can you configure SAP HANA Direct Extractor Connection(DXC) data sources? (Choose two)A. SAP Business Warehouse serverB. SAP BusinessObjects Data Services serverC. SAP HANA serverD. SAP ECC server


Options are :

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

Answer : A,D

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.


Options are :

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

Answer : A,B,E

SAP C_TSCM52_66 Certified Associate - Procurement Exam Set 5

What is the purpose of a template table in SAP BusinessObjects Data Services?


Options are :

  • To read source data and perform data transformations
  • To fill an existing target table with new data
  • To create a target table and fill this table with data (Correct)
  • To create pre-designed information models

Answer : 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 SAPBusinessObjects Information Design Tool (IDT) on top of SAP HANA? (Choose two)A. Add the INFORMATION_CONSUMER role to the user.B. Add dimensions and measures to the business layer.C. Add information models to the data foundation.D. Add an information space to the business layer.


Options are :

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

Answer : B,C

A customer wants to report on large amounts of SAP HANA data. The users want to drill from thetop aggregation level to the lowest granularity and try different types of graphical representationsof the data on the fly.Which SAP BusinessObjects reporting tool would you recommend?


Options are :

  • SAP BusinessObjects Dashboards
  • SAP BusinessObjects Explorer (Correct)
  • SAP BusinessObjects Web Intelligence
  • SAP BusinessObjects Crystal Reports for Enterprise

Answer : SAP BusinessObjects Explorer

SAP P_HCMTM_64 Certified Professional - HCM Talent Mngt Exam Set 3

Which tasks do you have to perform if you want to use SAP BW with SAP HANA as the underlyingdatabase? (Choose three)A. Install SAP Business Warehouse Accelerator (BWA).B. Perform a database migration from your current DB to SAP HANA DB.C. Execute the report RS_BW_POST_MIGRATION.D. Upgrade to at least SAP NetWeaver Business Warehouse 7.30 SP5.E. Recreate SAP BW indexes after SAP HANA database migration.


Options are :

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

Answer : B,C,D

460684bb-deee-44c2-80f9-71c46954fbe4:Which connection method that is listed on the left can you use with the tools that are available inthe dropdown box on the right?A. RFCB. ODBC/JDBCC. BICSD. ODBO E.RTS


Options are :

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

Answer : A,B,C,D

Which of the following CE functions can you use to query an analytic view directly?


Options are :

  • CE_OLAP_VIEW (Correct)
  • CE_AGGREGATION
  • CE_CALC
  • CE_JOIN_VIEW

Answer : CE_OLAP_VIEW

SAP C_TSCM66_66 Certified Associate Logistics Execution Exam Set 2

What happens when you turn on replication of an SAP ERP source system using SAP LandscapeTransformation (SLT)?


Options are :

  • SLT creates database triggers in the ERP system that write to application tables.
  • SLT creates database triggers in the ERP system that write to logging tables. (Correct)
  • SLT creates ABAP code in the ERP system that writes to logging tables
  • SLT creates ABAP code in the ERP system that writes to application tables.

Answer : SLT creates database triggers in the ERP system that write to logging tables.

You want to add a column to a calculation view that displays the year-to-date revenue of thecurrent 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.


Options are :

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

Answer : B,D

An analytic view has two columns, SHIP_TO_COUNTRY and SHIP_FROM_COUNTRY, thatcontain ISO country codes. You must replace these codes with the English country names byjoining to the same country attribute view twice.What must you create to achieve this?


Options are :

  • An attribute view using the Copy From method.
  • Two data foundations
  • A shared attribute view
  • A derived attribute view (Correct)

Answer : A derived attribute view

SAP P_HCMTM_64 Certified Professional - HCM Talent Mngt Exam Set 1

When you create a report in SAP BusinessObjects you notice that some columns of your SAPHANA 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.


Options are :

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

Answer : B,D

What are benefits of using an SAP BusinessObjects business layer on top of SAP HANA?(Choose two)A. Business layers can be exported to the SAP BusinessObjects repository and be used by SAPBusinessObjects client tools.B. Reporting users can change replication settings in the business layer to access more data.C. Business layers can be exported to an SAP HANA database and be used for modeling.D. Reporting users can create individual reports based on separate information models using onebusiness layer.


Options are :

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

Answer : A,D

How can you restrict SAP HANA modeling users from viewing sensitive data?


Options are :

  • Remove ALTER SYSTEM in the system privileges for the modeling users.
  • Use scrambled source data. (Correct)
  • NONE
  • Use the pre-delivered MODELER role.
  • Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users

Answer : Use scrambled source data.

SAP C_TSCM52_66 Certified Associate Financial Accounts Test Set 5

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 statementD. SAP BusinessObjects Data Services


Options are :

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

Answer : C,D

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.


Options are :

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

Answer : B,D

You have made modifications to an information model within a delivery unit. You want to exportthe model to an SAP HANA target system.In the Schema Mapping dialog, where do you define the target system schema?


Options are :

  • In the Authorization schema
  • In the Physical schema (Correct)
  • In the _SYS_BI schema
  • In the Authoring schema

Answer : In the Physical schema

SAP C_TSCM62_65 Certified Associate - Order Fulfilment Exam Set 5

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


Options are :

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

Answer : A,D

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?


Options are :

  • SAP host agent
  • OLAP engine (Correct)
  • XS engine
  • Delivery unit

Answer : OLAP engine

Which of the following can you use to build the data foundation for an attribute view? (Choose two)A. Referential JoinB. UnionC. ProjectionD. Text Join


Options are :

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

Answer : A,D

SAP C_TSCM42_66 Certified Associate Production Planning Exam Set 3

Which of the following are characteristics of using a Rapid Deployment Solution (RDS), such asOperational Reporting for SAP HANA? (Choose two)A. Relevant tables are replicated.B. SAP will create information models based on customer requirements.C. Customized tables and columns are replicated.D. Pre-designed information models are imported into SAP HANA.


Options are :

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

Answer : A,D

You create a graphical calculation view that is based on analytic views.What do you use to combine the data from the analytic views?


Options are :

  • Aggregation node
  • Referential join
  • Projection node
  • Union (Correct)

Answer : Union

Which of the following are required elements when you create any type of hierarchy in SAPHANA? (Choose two)A. A child nodeB. An analytic viewC. A data foundationD. An attribute view


Options are :

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

Answer : C,D

SAP C_HANATEC_1 Certified Technology Associate Practice Exam Set 4

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?


Options are :

  • The Audit log (Correct)
  • Entries in M_CONNECTIONS
  • The indexserver_alert.trc file
  • The nameserver_history.trc file

Answer : The Audit log

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 studioB. In the SAP BusinessObjects Data Services job monitorC. In the Content node of SAP HANA studioD. In the SAP BusinessObjects Data Services table preview


Options are :

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

Answer : A,D

Which of the following is used to make hierarchies available to reporting tools?


Options are :

  • MDX (Correct)
  • SQLScript
  • SQL
  • CE Functions

Answer : MDX

SAP C_TADM51_731 Certified Technology Associate System Exam Set 7

You want to load a large amount of source data (more than one billion rows) into SAP HANA forread-intensive information models.Which table type is recommended for this scenario?


Options are :

  • Column table (Correct)
  • Row table
  • Decision table
  • Global temporary table

Answer : Column table

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)A. The business layerB. The business viewC. The Web Intelligence report variablesD. The SAP HANA information model


Options are :

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

Answer : A,D

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions