Ask Question
SAP C_BW4H_214 Practice Test - Questions Answers
Add to Whishlist
List of questions
Question 1
Using SAP HANA as modeling focus, you want to combine data from different sources. Which techniques can you use? Note: There are 2 correct answers to this question.
BAPIs (Business Application Programming Inetrface)
Calculation views
AMDPs (ABAP Manged Database Procedures)
Stored procedures
Question 2
When loading master data for a material, you want to look at the new values before they are released for reporting. What could you do using modeling features? Note: There are 2 correct answers to this question.
When you define the attributes of material, select the 'Time Dependent' setting
When you define the data transfer process, select the 'Load records wit new key only' setting
When you define the data transfer process, choose the 'Set Manually' setting for 'Overrall status of request'
When you define the material characteristic, select the 'Enhanced Master data update' setting
Question 3
In a DatStore object (advanced) of type Data Mart, which request-based deletion is possibel?
The lastest not-yet-activated reques in the inbound table
The lastest request in the active data table
Any older activated reqeust in the inbound table
The lastest request in the change log table
Question 4
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.
ABR
ADD
AIM
AIE
* 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.
* 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
Question 5
Which SAP BW/4HANA objetcs can be used as sources of a data transfer process (DTP)? Note: There are 3 correct answers to this question.
InfoSource
Open Hub Destination
DataStore Objetc (advanced)
CompositeProvider
SAP HANA Analysis Process
Question 6
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.
Open ODS view of type Facts
Calculation View of type Dimension
Open ODS view of type Master Data
InfoObjetc of type Characteristic
Question 7
For a BW query, you want to have the first month of the curret quarter as a default value for an input-ready BW variable for the characteristic OCALMONTH. Which processing tyoe do you use?
Customer Exit
Manual Input with offset value
Replacement Path
Manuel Input with default value
Question 8
Which recommendations should you follow to optimize BW query performance? Note: There are 3 correct answers to this question
Use fewer drill-down characteristics in the initial view
Use characteristic filters that overlap
Use exclude functions in the restricted key figures
Use mandatory characteristic value variables
Use include functions in the restricted key figures.
* A. Use fewer drill-down characteristics in the initial view: This can improve the query performance by reducing the amount of data that needs to be transferred and displayed at the start of the query execution. The user can drill down to more details later if needed1.
* D. Use mandatory characteristic value variables: This can improve the query performance by restricting the data selection to a smaller set of values that are relevant for the user. The user can also change the variable values later if needed1.
* E. Use include functions in the restricted key figures: This can improve the query performance by avoiding unnecessary calculations and aggregations that are done when using exclude functions. Include functions are also more efficient than selections or restricted key figures when filtering data1.
* 2 https://blogs.sap.com/2015/04/20/query-performance-optimisation-tips-in-bw-73/
* 1 https://blogs.sap.com/2022/02/02/query-performance-optimization-in-bw-few-tips/
* 3 https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/2022.12/en-us/0471d0ecea4e4677ba29d9ac1496c24c.html
* 4 https://blogs.sap.com/2021/06/02/sap-bw-4hana-performance-optimization-part-i/
Question 9
What are some of the variable types n a BW query that can use the processing tupe SAP HANA Exit. Note: There are 2 correct answers to this question.
Formula
Text
Charateristic value
Hierarchy node
* C. Characteristic value: This type of variable can use the SAP HANA Exit processing type to determine default values for variables using an AMDP class implementation. This can improve the performance and flexibility of queries that are generated as external SAP HANA views12.
* D. Hierarchy node: This type of variable can use the SAP HANA Exit processing type to determine default values for variables using an AMDP class implementation. This can improve the performance and flexibility of queries that are generated as external SAP HANA views12.
* 1 https://help.sap.com/docs/r/107a6e8a38b74ede94c833ca3b7b6f51/1.0.8/en-US/b77f3073e9d842d6959e03e74dcefa09.html
* 2 https://blogs.sap.com/2017/09/29/usage-of-sap-hana-exit-variables-for-a-standard-reporting-scenario/
Question 10
Which external hierarchy properties can be changed in the query definition? Note: There are 3 correct answers to this question.
Position of child nodes
Expand to level
Time dependency
Sort direction
Allow temporal hierarchy join
Related questions
Export
If you didn't receive an email within 5 minutes, you should submit a support request to [email protected].
|
BASIC - 1 Month
$
10
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
|
PLUS - 2 Months
$
15
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
|
PRO - 6 Months
$
40
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
|
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
Selling illegal goods, money scams etc.
Serious attack on a group.
Harassing an individual (including doxing)
Threatening or glorifying violence or serious harm, including self-harm
Nudity/Sexual content
Sexually explicit or suggestive imagery or writing involving minors
Sexually explicit or suggestive imagery or writing involving non-consenting adults or non-humans
Reusing content without attribution (link and blockquotes)
Not in English or has very bad formatting, grammar, and spelling
Author's credential is offensive, spam, or impersonation
Ex. Illegal content, incomplete question...
Question