C_HANAIMP_1 SAP HANA Certified Application Associate Exam Set 4

You want to retrieve data from SAP HANA and restrict access to certain data columns for specificuser groups. Where can you implement this?


Options are :

  • In the data foundation
  • In the analytic privileges
  • In the business layer (Correct)
  • In the SQL privileges

Answer : In the business layer

You create an analytic view and want to restrict access to departments with specific values usinganalytic privileges. Which tasks do you have to perform to accomplish this? (Choose three)A. Assign restricted values to the attribute view.B. Assign values to be restricted. Choose at least one information model to assign restrictions.C. Assign the analytic privilege to a user or role.D. Assign values to be restricted to a content table.E. Choose an attribute to define restricted values for it.


Options are :

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

Answer : B,C,E

SAP C_THR12_66 Certified Associate - Human Capital Exam Set 3

Which of the following steps is required for configuring SAP Landscape Transformation (SLT)?


Options are :

  • Define an RFC connection from SLT to SAP HANA.
  • Define the number of jobs to be used for data replication. (Correct)
  • Define the number of background work processes in SLT.
  • Define a DB connection from SLT to the source system.

Answer : Define the number of jobs to be used for data replication.

How can you improve the quality of your information model design? (Choose three)A. Use ´case´ or ´if´ statements whenever possible.B. Use row-based database expressions.C. Design your views to be reusable.D. Modularize your views.E. Avoid duplications in your modeling.


Options are :

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

Answer : C,D,E

Which feature is supported by the backup and recovery process within the standard delivery ofSAP HANA?


Options are :

  • Information model recovery
  • Automatic backup of archiving log files scheduled within SAP HANA
  • Point-in-time recovery (Correct)
  • Incremental backup

Answer : Point-in-time recovery

Your customer has the following reporting requirements:Real-time profitability reporting on large-scale data volumesOn-the-fly analysis of profitability data at any level of granularity, aggregation, and dimensionCost allocation reports with significantly faster processing timeWhich application do you recommend?


Options are :

  • SAP Bank Analyzer with SAP HANA
  • SAP HANA for Banking
  • SAP Deposits Management with SAP HANA
  • SAP HANA CO-PA Accelerator (Correct)

Answer : SAP HANA CO-PA Accelerator

Which security settings can you apply in analytic privileges? (Choose two)A. Grant access to analytic views.B. Restrict access within an analytic view using measure values.C. Restrict access within an analytic view using attribute values.D. Restrict access to hierarchies.


Options are :

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

Answer : A,C

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)  A. Client filtering in the Delivery unit view.B. Joins in information models.C. Memory leaks.D. Client filtering in SAP Landscape Transformation (SLT).


Options are :

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

Answer : B,D

SAP C_TSCM52_66 Certified Associate - Procurement Exam Set 4

You want to create a graphical calculation view using the SAP HANA studio. Which steps aremandatory for this task? (Choose three)A. Define a projection.B. Write an SQL script.C. Save and activate the view.D. Define output fields.E. Choose a data source.


Options are :

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

Answer : C,D,E

Which types of calendar are available for time attribute views in SAP HANA? (Choose two)A. FiscalB. FactoryC. GregorianD. Julian


Options are :

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

Answer : A,C

You modify an existing view. How can you determine which models are affected by this change?


Options are :

  • Use the History feature for the changed model.
  • Use the "Auto Documentation" to compare the object version of the changed model.
  • Use the audit trail.
  • Use the "Where-Used List" feature for the changed model. (Correct)

Answer : Use the "Where-Used List" feature for the changed model.

SAP C_TSCM42_66 Certified Associate Production Planning Exam Set 7

You want to create a custom attribute in addition to your data model.How can you achieve this?


Options are :

  • Create the attribute as a calculated attribute within the analytic view. (Correct)
  • Create the attribute as a calculated measure within the attribute view.
  • Create the attribute as a restricted attribute within the calculation view.
  • Create the attribute and add it to the appropriate system table manually.

Answer : Create the attribute as a calculated attribute within the analytic view.

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?


Options are :

  • Information Design Tool
  • Web Intelligence
  • Central Management Console
  • SAP HANA Studio (Correct)

Answer : SAP HANA Studio

Which delivered role is mandatory for a system administrator in SAP HANA?


Options are :

  • IC MODELER
  • CONTENT_ADMIN (Correct)
  • SAP_ALL
  • SYS_ADMIN

Answer : CONTENT_ADMIN

SAP P_HCMTM_64 Certified Professional - HCM Talent Mngt Exam Set 3

Which of the following tools can you use to monitor the query time from SAP HANA?


Options are :

  • Central Management Console
  • Event Viewer
  • Performance tab of the System Monitor
  • SQL Trace (Correct)

Answer : SQL Trace

A company loads data every night from several source systems into multiple tables in SAP HANAusing complex transformation rules. The calculation view that joins these tables performsunexpectedly slow.Which of the following could you investigate to be able to improve performance? (Choose two)A. Whether the joins and transformations of the tables can be moved to the data loading processof SAP BusinessObjects Data Services.B. Whether an InfoCube compression is running.C. Whether the calculation view needs to create large intermediate result sets.D. Whether savepoints are written during execution.


Options are :

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

Answer : A,C

Your SAP BusinessObjects report runs slowly.Which of the following actions could improve the performance? (Choose two)A. Restrict data by using variables in the information model.B. Tune the Array Fetch Size parameter of the universe.C. Move calculated measures from the information model to the report.D. Join all the analytic views with each other in the business layer.


Options are :

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

Answer : A,B

SAP P_HCMTM_64 Certified Professional - HCM Talent Mngt Exam Set 2

In SAP HANA studio, in which of the following can you create users? (Choose two)A. The Administration consoleB. The Roles nodeC. The Content nodeD. The SQL editor


Options are :

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

Answer : A,D

Which best practices should you apply when you use SQL script in SAP HANA? (Choose three)A. Use the WHERE clause for updates.B. Use UNION ALL instead of UNION.C. Use dynamic SQL with variables.D. Use cursors.E. Use CE functions.


Options are :

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

Answer : A,B,E

How can you improve the performance of a report that is based on SAP HANA data? (Choosetwo)A. Ensure that all SAP HANA tables are in the same schema.B. Maintain appropriate constraint filters in SAP HANA.C. Ensure that all calculations are pushed down to the SAP HANA database.D. Gather new database statistics.


Options are :

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

Answer : B,C

C_TADM51_731 SAP Net Weaver with System Administration Test Set 2

In which of the following can you use a FOR loop over your data?


Options are :

  • Analytic View
  • Monitoring View
  • Calculation View (Correct)
  • Attribute View

Answer : Calculation View

Which data store type is recommended for write-intensive scenarios?


Options are :

  • Column store
  • Table store
  • Row store (Correct)
  • Object store

Answer : Row store

How many result tables can a calculation view generate per session?


Options are :

  • One (Correct)
  • Unlimited
  • Two
  • None

Answer : One

SAP C_TSCM42_66 Certified Associate - Production Exam Set 7

A customer wants to reproduce the following SQL statement in SAP HANA:SELECT P.PROD_NAME, P.PROD_ID, PT.PROD_DESCFROM PRODUCTS P,PROD_TEXTS PTWHERE P.PROD_ID=PT.PROD_ID;Which of the following SQLScript constructs is equivalent to this SQL statement and yields thebest performance?


Options are :

  • 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]);
  • 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]); (Correct)

Answer : 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]);

You have to do reverse pivot transformations on large data tables before loading the data intoSAP HANA.Which of the following do you recommend to use?


Options are :

  • SAP System Landscape Directory (SLD)
  • SAP HANA Direct Extractor Connection (DXC)
  • SAP BusinessObjects Data Services 4.0 (Correct)
  • SAP Landscape Transformation (SLT)

Answer : SAP BusinessObjects Data Services 4.0

Which of the following must an analytic view contain?


Options are :

  • An attribute view
  • A measure (Correct)
  • A hierarchy
  • A calculated measure

Answer : A measure

SAP C_TSCM52_66 Certified Associate - Procurement Exam Set 3

You need to run a Web Intelligence report that requires data from SAP HANA filtered for a specificyear based on ad hoc user input.For best performance, how would you achieve this?


Options are :

  • Use a prompt in the query of the Web Intelligence report.
  • Use a dynamic transformation rule during data provisioning
  • 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. (Correct)

Answer : Use input from a Web Intelligence report passed to a variable in an information model.

What is an example of a selective data load using SAP Landscape Transformation?


Options are :

  • Selected data for transformation is split into portions.
  • Selected data for a range of years is loaded into SAP HANA. (Correct)
  • 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.

Answer : Selected data for a range of years is loaded into SAP HANA.

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?


Options are :

  • CREATE ANY to user A
  • REFERENCES to user B
  • REFERENCES to user A (Correct)
  • CREATE ANY to user B

Answer : REFERENCES to user A

SAP C_TADM51702 Certified Technology Associate - System Exam Set 1

Which of the following operations can you use when you create a calculation view using the SAPHANA studio graphical interface? (Choose two)A. PROJECTIONB. UNIONC. INTERSECTD. INSERT


Options are :

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

Answer : A,B

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions