[2023年12月]更新のC_BW4H_211試験事前練習テスト試験問題と解答SAP Certified Application Associate学習ガイド [Q30-Q55]

[2023年12月]更新のC_BW4H_211試験事前練習テスト試験問題と解答SAP Certified Application Associate学習ガイド

SAP Certified Application Associate - Reporting, Modeling and Data Acquisition with SAP BW/4HANA認証サンプル解答

質問 # 30
You create a transformation from a DataSource to a DataMart Data Store object (advanced) All key figures are updated as Sum. Which Delta methods indicate that the DataSource provides consistent information for this target? Note: There are 2 correct answers to this question.

A. ABR
B. AIM
C. AIE
D. ADD

正解：C、D

解説：
* B. ADD: This delta method indicates that the DataSource provides consistent information for this target. It means that the DataSource delivers additive delta records with after images, which are updated directly in the delta queue. This can support sum aggregation for key figures12.
* D. AIE: This delta method indicates that the DataSource provides consistent information for this target. It means that the DataSource delivers additive delta records with after images, which are updated in the extraction queue and then transferred to the delta queue. This can support sum aggregation for key figures13.
Reference:
* 1 https://wiki.scn.sap.com/wiki/display/BI/Delta+type+in+BW+Extractors
* 2 https://help.sap.com/doc/saphelp_nw73ehp1/7.31.19/en-US/4f/18f6aa3fca410ae10000000a42189d/content.htm
* 3 https://help.sap.com/doc/saphelp_nw73ehp1/7.31.19/en-US/4f/18f6b13fca410ae10000000a42189d/content.htm

質問 # 31
You want to add a Source System of type Big Data in SAP BW/4HANA. Which adapters can you use to reference the remote source system? Note: There are 2 correct answers to this question.

A. Spark SQL Adapter
B. SAP HANA Adapter
C. IQ (ODBC) adapter
D. SAP Vora ODBC adapter

正解：A、D

質問 # 32
In which ODP context is the operational delta queue (ODQ) managed by the target system?

A. ODP_CDS
B. ODPJHANA
C. ODP_SAP
D. ODP_BW

正解：B

質問 # 33
You created an Open ODS View on an SAP HANA database table to virtually consume the data in SAP BW/4HANA. Real-time reporting requirements have now changed and you are asked to persist the data in SAP BW/4HANA. Which objects are created when using the "Generate Data Flow" function in the Open ODS View editor? Note: There are 3 correct answers to this question.

A. SAP HANA calculation view
B. Data source
C. CompositeProvider
D. Transformation
E. DataStore object (advanced)

正解：B、D、E

質問 # 34
You define a remote subscription of type UPSERT in an SAP HANA Smart Data Integration (SDI) real-time udate scenario. Which fields are added to the DataSource automatically? Note: There are 3 correct answers to this question.

A. SDI_CHANGE_TIME
B. SDI_CHANGE_TYPE
C. SDI_ENTITY_COUNTER
D. SDI_CHANGE_SEQUENCE
E. SDI_RECORD_MODE

正解：A、B、E

質問 # 35
What are some of the prerequisites for using SAP S/4HANA ABAP CDS views for extraction into SAP BW/4HANA in an ODP context? Note: There are 2 correct answers to this question.

A. An ODP source system with context ODP_CDS must be created in SAP BW/4HANA.
B. The Operational Data Provisioning Framework must be configured in SAP BW/4HANA.
C. The ABAP CDS views must be released via the program RODPS_OS_EXPOSE for BW extraction.
D. The ABAP CDS views must be defined with the appropriate data extraction annotations.

正解：A、D

質問 # 36
Which of the following are possible delta-specific fields for a generic DataSource in SAP ERP?Note: There are 3 correct answers to this question.

A. Request ID
B. Numeric pointer
C. Time stamp
D. Calendar day
E. Record mode

正解：B、C、D

質問 # 37
You create a Data Store object (advanced) using the "Data Mart DataStore Object" modeling property.Which behaviors are specific to this modeling property?Note: There are 2 correct answers to this question.

A. Query results are shown only when data has been activated.
B. The change log table will be filled only after data activation.
C. Reporting is done based on a union of the inbound and active tables.
D. The records are treated as if all characteristics are in the key.

正解：C、D

質問 # 38
Which features of an SAP BW/4HANA InfoObject are intended to reduce physical data storage space?
Note: There are 2 correct answers to this question.

A. Transitive attribute
B. Compounding characteristic
C. Reference characteristic
D. Enhanced master data update

正解：A、C

質問 # 39
Which interface do you use to create a BW InfoObject with access type "SAP HANA view"?

A. BW modeling perspective in SAP HANA studio
B. SAP BW/4HANA Cockpit
C. Embedded SAP GUI in SAP HANA studio
D. SAP HANA modeler perspective in SAP HANA studio

正解：A

質問 # 40
You want to define a restricted column in an SAP HANA HDI calculation view.What do you need to define? Note: There are 2 correct answers to this question.

A. An SAP HANA data type
B. An aggregation method
C. A reference to an existing measure
D. A condition criterion

正解：B、C、D

質問 # 41
You have created a custom characteristic with the technical name "COSTOBJ". Depending on the controlling area, you need to have different attribute values assigned.How do you design the model?

A. Define characteristic "COSTOBJ" as a navigation attribute for Controlling Area.
B. Compound characteristic "COSTOBJ" with the characteristic for Controlling Area.
C. Compound the characteristic for Controlling Area with the characteristic "COSTOBJ".
D. Define Controlling Area as a navigation attribute for the characteristic "COSTOBJ".

正解：C

質問 # 42
What foundation is necessary to use SAP S/4HANA embedded analytics?

A. SAP HANA optimized business content
B. ABAP CDS view based virtual data model.
C. SAP Agile Data Preparation
D. Generated external SAP HANA Calculation Views

正解：B

解説：
SAP S/4HANA embedded analytics uses ABAP CDS view based virtual data model to provide real-time access to the transactional data without data replication. It is a collection of SAP Fiori tiles that enable real-time operational reporting. SAP S/4HANA embedded analytics comes with a lot of predefined analytical apps based on Fiori and on SAP Analytics Cloud for various functional areas. The main user types addressed by SAP S/4HANA embedded analytics are business users and analytics specialists.

質問 # 43
You created an Open ODS view of type Facts. Which object type can you associate with a view field in the characteristics folder? Note: There are 2 correct answers to this question.

A. InfoObjetc of type Characteristic
B. Calculation View of type Dimension
C. Open ODS view of type Facts
D. Open ODS view of type Master Data

正解：A、D

質問 # 44
You want to build an SAP HANA HDI calculation view of data category CUBE, but you get a "no measure defined" error.For the business requirement, a measure does not make sense. Besides changing the data category to DIMENSION, what do you have to do?

A. Switch from an aggregation node to a star join node.
B. Switch from a projection node to a star join node.
C. Switch from a projection node to an aggregation node.
D. Switch from an aggregation node to a projection node.

正解：D

質問 # 45
You want to combine an existing SAP BW/4HANA Data Model with virtual data from a new non-SAP source system for test purposes. Which approach should you consider for rapid prototyping?

A. InfoObject base modeling
B. Business content activation
C. Generate Data Flow
D. Field-based modeling

正解：D

質問 # 46
What is the recommended cold data tiering option with SAP BW/4HANA?

A. SAP IQ database
B. SAP Data Warehouse Cloud
C. Hadoop cluster
D. SAP HANA extension node

正解：A、C

質問 # 47
You want to set up the replication process for the SAP Landscape Transformation Replication Server. Which actions can you define for a specific table? Note: There are 2 correct answers to this question.

A. Convert Unicode to non-Unicode
B. Apply customizing settings to the database redo logs.
C. Change or enrich the table structure
D. Set the reading type and portion sizes
E. Apply mapping rules during the replication

正解：D、E

質問 # 48
In an SAP HANA smart data integration flowgraph, which transformation options are available? Note: There are 3 correct answers to this question.

A. Combine datasets
B. Execute an SAP HANA analysis process
C. Split datasets
D. Call an ABAP function module
E. Execute a stored procedure

正解：A、C、E

質問 # 49
What are the possible ways to fill a pre-calculated value set (bucket)? Note: There are 3 correct answers to this question.

A. By referencing a table
B. By accessing an SAP HANA Calculation View of data category Dimension
C. By using a transformation and data transfer process
D. By entering the values manually
E. By using a query

正解：A、D、E

質問 # 50
In an SAP HANA HDI Calculation View, you need to combine attributes data (left table) and the data's language-dependent text (right table) using a text join. What should you select to restrict the result set to the logon language?

A. the language column in the left table
B. The join cardinality between both tables
C. the language column in the righ table
D. The logon language in the left table

正解：C

質問 # 51
Which external hierarchy properties can be changed in the query definition?Note: There are 3 correct answers to this question.

A. Time dependency
B. Sort direction
C. Position of child nodes
D. Display text nodes
E. Expand to level

正解：B、C、E

質問 # 52
Which external hierarchy properties can be changed in the query definition? Note: There are 3 correct answers to this question.

A. Time dependency
B. Sort direction
C. Position of child nodes
D. Expand to level
E. Allow temporal hierarchy join

正解：B、C、D

質問 # 53
The Database Explorer in the Web IDE for SAP HANA proveides a data file improt wizard to create a table in SAP HANA from a flat file. What are possible actions adter the system suggests the target structure?? Note: There are 3 correct answers to this question.

A. Switch the table type between row store and column store
B. Map InfoObjetcs to fields in the target tavle
C. Change the order of the fields in the target table
D. Define sorting properties for a target table field
E. Adjust the suggested data type of the target table fileds

正解：A、C、E

質問 # 54
You have already loaded data from a non-SAP system into SAP Data Warehouse Cloud. You want to federate this data with data from an InfoCube of your SAP BW powered by SAP HANA system.What do you need to use to combine the data?