SAP C_P2WBW_2505 問題集

質問 1：
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.
正解：C

質問 2：
Why should you run an SAP HANA delta merge? Note: There are 2 correct answers to this question.
A. To combine the query cache from different executions
B. To improve the read performance of InfoProviders
C. To move the most recent data from disk to memory
D. To decrease memory consumption
正解：B,D

質問 3：
In SAP Web IDE for SAP HANA, you have imported a project including an HDB module with calculation views. What do you need to do in the project settings before you can successfully build the HDB module?
A. Change the schema name
B. Define a package
C. Generate the HDI container
D. Assign a space
正解：D

質問 4：
In an SAP HANA smart data integration flowgraph, which transformation options are available? Note: There are 3 correct answers to this question.
A. Run an SAP HANA analysis process
B. Combine datasets
C. Call an ABAP function module
D. Include a stored procedure
E. Split datasets
正解：B,D,E

質問 5：
The Database Explorer in the Web IDE for SAP HANA provides a data file import wizard to create a table in SAP HANA from a flat file. What are possible actions after the system suggests the target structure? Note: There are 3 correct answers to this question.
A. Define sorting properties for a target table field.
B. Adjust the suggested data type of the target table fields.
C. Change the order of the fields in the target table.
D. Remove leading zeroes for a target table field.
E. Switch the table type between row store and column store.
正解：B,C,E

質問 6：
You defined a condition in a BW query for the top 10 of 100 customers based on sales revenue.
Using key figure properties in the BW query, which two scenarios regarding result presentation can be achieved? Note: There are 2 correct answers to this question.
A. One result row with the sales revenue sum of all 100 customers
B. One result row with the sales revenue sum of the top 10 customers
C. One result row with the sales revenue sum of the top 10 customers and a second result row with the sales revenue sum of the other 90 customers
D. One result row with the sales revenue sum of the top 10 customers and a second result row with the sales revenue sum of all 100 customers
正解：B,C

質問 7：
What are the main challenges companies face that want to make data-driven decisions? Note: There are 3 correct answers to this question.
A. Harness the power of fragmented, unstructured data sources to turn them into valuable business insights.
B. Simplify the data landscape to reduce costs and accelerate insights.
C. Boost confidence in the quality of their data
D. Uncover the hidden potential in their business by unlocking seamless access to critical insights.
E. Unlock a new dimension of insights, advanced analytics, and Al capabilities.
正解：A,C,D