[Feb-2023] SAP Certified Application Associate C-BW4HANA-24 Exam Practice Dumps [Q37-Q61] : Actual Test Materials : http://blog.actualtests4sure.com

NO.37 When can you NOT use a characteristic with the High Cardinality property? Note: There are 3 correct answers to this question.

When it will be a navigation attribute

When it will be a time-dependent attribute

When it will be part of a report-to-report interface

When it will be part of a hierarchy

When it will be a compound characteristic

NO.38 Which objects can you combine using a CompositeProvider? Note: There are 2 correct answers to this question.

SAP HANA calculation views

CompositeProvider

InfoSources

Key figures

NO.39 You expect to have more than 2 billion records as master data references for a characteristic in your data model and want to use the high cardinality option.
What do you need to consider in reporting?

Using this characteristic as a navigational attribute will impact response time.

The High Cardinality property needs to be defined in the Composite Provider.

The local SID values are created automatically during reporting, which will impact the response time.

Using a hierarchy of this characteristic for navigation will impact response time.

NO.40 You want to validate your SAP HANA data model. What must you ensure to use the data preview functionality?

The _SYS_BIC user is created in the system and the runtime information is written to_SYS STATISTICS.

You are connected as SYSTEM user and all object privileges are assigned to this SYSTEM user.

The _SYS_REPO user must have sufficient object privileges assigned to your desired schema.

Your content package is assigned with sufficient repository privileges to the SYS REPO user.

NO.41 You plan to regularly transfer changes from an SAP ERP custom table to SAP BW/4HANA. An additional custom development may NOT be implemented in the source system. Which Operational Data Provisioning (ODP) source system type do you recommend?

ODP-SLT

ODP-SAP

ODP-BW

ODP-CDS

NO.42 You need to create a CompositeProvider to combine data from an SAP HANA calculation view with a DataStore object (advanced). Which of the following Eclipse perspectives do you use?

JavaScript perspective

BW modeling perspective

ABAP perspective

SAP HANA modeler perspective

NO.43 “You created two structures that are defined without key figures. Afterwards, you use both structures in your query definition. How many key figures can the query contain?”

Exactly two key figures

Up to 10 key figures

Any number of key figures

Exactly one key figures

NO.44 For which business requirements do you suggest an SAP BW/4HANA modeling focus rather than an SAP HANA modeling focus?
Note: There are 2 correct answers to this question.

Report on a harmonized set of master data.

Load snapshots or deltas on a periodic basis.

Use existing HANA content models.

Leverage SQL in-house knowledge.

NO.45 Which properties determine the delta process within the Operational Data Provisioning (ODP) delta management for DataSources?
Note: There are 2 correct answers to this question.

Serialization

Delta type

Record mode

Parallelization

Record type

NO.46 What must you do if you want to use an object from BI Content?

Copy the BI Content object into the customer name space.

Convert the object from A version to D version.

Activate the object in the Data Warehousing Workbench.

Identify the BI Content objects in SAP HANA studio.

NO.47 How do you enable streaming mode for a process chain?

Navigate to Process Chain Maintenance (RSPC).Select Streaming Mode in the process chain attributes.

Navigate to Customizing (SPRO).Change the general settings for SAP BW/4HANA.

Navigate to Modeling DW Workbench (RSA1).Activate streaming mode on the Current Settings Folder tab.

Navigate to Process Chain Maintenance (RSPC). Add a new process variant for streaming mode.

NO.48 You need to combine master data (right table) and transactional data (left table) using a referential join. How will this referential join behave?

It is executed as an inner join when NO fields from the right table are requested.

It always returns all fields from the right table as a result data set.

It is executed as an inner join when a description mapping is defined between the left table and the u right table.

It returns a result data set if the left table has a corresponding entry on the right table.

NO.49 You need to combine master data (right table) and transactional data (left table) using a referential join.
How will this referential join behave?

It is executed as an inner join when NO fields from the right table are requested.

It always returns all fields from the right table as a result data set.

It is executed as an inner join when a description mapping is defined between the left table and the u right table.

It returns a result data set if the left table has a corresponding entry on the right table.

NO.50 You need to restrict a sales report to the products that make up 50% of the total revenue. Which BW query feature do you use?

Condition

Calculated key figure

Restricted key figure

Exception

NO.51 You model a second SAP BW/4HANA CompositeProvider to integrate tables from an SAP HANA database schema with an existing SAP BW/4HANA CompositeProvider. What must you do first?

Set The CompositeProvider Can Be Added to Another CompositeProvider flag.

Assign consumption properties to the new SAP HANA calculation view.

Connect an export DataSource from the exisiting CompositeProvider to the new CompositeProvider.

Create an Open ODS view with consumption properties to consume the data in the SAP BW/4HANA schema.

NO.52 Which SAP Landscape Transformation Replication Server cockpit operation removes all data from the trigger table?

Suspend Replication and Resume Replication

Stop Replication and Resume Replication

Suspend Replication and Start Replication

Stop Replication and Start Replication

NO.53 You want to use the SAP HANA concept of semantic types as part of the currency conversion mechanism. You decide to use semantic type Amount with Currency Code within your SAP HANA calculation view. Which currency reference can be assigned to the measure? Note: There are 3 correct answers to this question.

A fixed currency

A currency from a currency conversion

A currency from another column

A currency from an SAP HANA content calculation view

A currency from SAP BW customizing

NO.54 You need to enable real-time streaming using SAP HANA smart data integration (SDI) to load data into a DataStore object (advanced). What are prerequisites for this requirement? Note: There are 2 correct answers to this question.

The source system is pulling data into SAP BW/4HANA.

The process chain is running in streaming mode.

The data target is a DataStore object (advanced) of the InfoCube model template.

The adapter is real-time enabled.

NO.55 Which query property do you set to minimize the initial run time for the query read mode?

Read all data at once.

Read data individually from InfoProvider.

Cache is inactive.

Read data when you navigate or expand hierarchies.

NO.56 Which actions can you perform with an SAP HANA calculation view that has the DIMENSION data category assigned?
Note: There are 2 correct answers to this question.

Join serveral tables.

Define text joins.

Persist master data.

Aggregate measures.

NO.57 To gather the requirements for data model design, which is the logical sequence? (indico solo la risposta corretta)

Reporting requirment Source of data Trasformation Storage requirement

NO.58 You need to load data from a generic DataSource using Operational Data Provisioning (ODP). In which sequence do you perform the activities?

1. Create a DataSource.
2. Replicate the DataSource.
3. Activate the DataSource.
4. Run job RODPS_OS_EXPOSE.

1. Create a DataSource.
2. Replicate the DataSource.
3. Run job RODPS_OS_ EXPOSE.
4. Activate the DataSource.

1. Create a DataSource.
2. Run job RODPS_OS_EXPOSE.
3. Replicate the DataSource.
4. Activate the DataSource.

1. Create a DataSource.
2. Activate the DataSource.
3. Run job RODPS_OS_EXPOSE.
4. Replicate the DataSource.

NO.59 Which SAP tool do you suggest to create a pixel-precise formatted report?

SAP Lumira, discovery edition

SAP Analysis for OLAP

SAP Crystal Reports for Enterprise

SAP Analytics Cloud

NO.60 In which sequence does SAP recommen

1. Transformations i-I 2. Reporting requirements3. Sources of data4. Storage requirements

1. Reporting requirements 2. Sources of data 3. Transformations4. Storage requirements

1. Storage requirements2. Transformations3. Sources of data4. Reporting requirements

1. Transformations i-I 2. Sources of data3. Reporting requirements4. Storage requirementsfor the data model design concept?

NO.61 you create a new sap hana remote connection. How does sap hana smart data access(SDA) differ from sap hana smart data integration(SDI)? (2 answer)

SDI is recommended for data source with limited changesin data structureSDA contains features to act as a full blown ETL tool”

SDI supports data replication in real timeSDA does not provide this capability”

SDI requires an additional sap hana data provisioning serverSDA is integrated in the sap hana index server”

SDI is used only for sap hana native appsthe SDA interface is used for sap bw/4hana models”