
2025年最新の実際に出ると確認された 無料SAP C_SAC_2501試験問題
C_SAC_2501リアル試験問題解答は無料
SAP C_SAC_2501 認定試験の出題範囲:
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
質問 # 34
You need to delete characters from a column in a dataset. What can you use? Note: There are 2 correct answers to this question.
- A. Custom expression editor
- B. Calculation editor
- C. Transform bar
- D. Formula bar
正解:A、C
質問 # 35
You are creating a script for an advanced data action. Which character designates a virtual variable member?
- A. #
- B. *
- C. %
- D. /
正解:C
質問 # 36
What can you do with a multi action? Note: There are 2 correct answers to this question.
- A. Import transaction data
- B. Run allocation processes
- C. Approve data
- D. Run allocation data actions
正解:A、D
質問 # 37
Which of the following data sources can you use in SAP Analytics Cloud data analyzer? Note: There are 3 correct answers to this question.
- A. SAP Datasphere model
- B. SAP Analytics Cloud analytic model
- C. SAP Analytics Cloud public dataset
- D. SAP HANA view
- E. SAP BusinessObjects Universe
正解:A、B、D
質問 # 38
How can you improve the performance of advanced data actions? Note: There are 3 correct answers to this question.
- A. Use fewer aggregation dimension functions
- B. Use fewer IF statements
- C. Use fewer FOREACH functions
- D. Use fewer data functions
- E. Use fewer MEMBERSET statements
正解:B、C、D
質問 # 39
You are entering values for several expense accounts in a data table. Which data entry mode must you use to process the data with a delay defined in System Administration?
- A. Mass
- B. Single
- C. Fluid
正解:C
質問 # 40
You want to total several income and expense accounts using the account type property.
What configuration option in the advanced formula must you use?
- A. Unbooked
- B. Signflip
- C. Aggregate To
- D. Append
正解:B
質問 # 41
You are creating a data action to copy data from one year to the next.In the parameter for the source year, which default setting must you change?
- A. Level
- B. Hierarchy
- C. Granularity
- D. Cardinality
正解:D
質問 # 42
Your embedded dataset in SAP Analytics Cloud has columns for Country, Region, City, and Customer Name. You want to aggregate measures for these columns as a single column. What can you do?
- A. Convert the embedded dataset to a model.
- B. Create a level-based hierarchy in the dataset.
- C. Create a group that includes the dimensions.
- D. Create a parent-child hierarchy in the dataset.
正解:B
解説:
To aggregate measures for columns such as Country, Region, City, and Customer Name as a single column in an embedded dataset, creating a level-based hierarchy is the most effective approach. This type of hierarchy allows you to define a multi-level structure that represents the logical relationship between different geographical entities and customer names. By doing so, you can easily perform aggregations and analyze data at various levels of detail, from the broadest level (e.g., Country) down to the most specific one (e.g., Customer Name).
Reference:
SAP Analytics Cloud Help Documentation: Creating Hierarchies in Models
SAP Analytics Cloud User Guide: Data Modeling and Hierarchies
質問 # 43
You want to display differences between measures in a chart. What can you use?
- A. Restricted measure
- B. Reference line
- C. Threshold
- D. Variance
正解:D
解説:
To display differences between measures in a chart within SAP Analytics Cloud, you can use the Variance feature. Variance helps to highlight the differences or gaps between two data points or measures, making it easier to identify trends, outliers, or areas requiring attention in visual representations like charts.
Reference:
SAP Analytics Cloud Help Documentation: Variance Analysis in Charts
SAP Analytics Cloud User Guide: Displaying Measure Differences Using Variance
質問 # 44
What are the available connection types in SAP Analytics Cloud? Note: There are 2 correct answers to this question.
- A. Live
- B. Import
- C. Cloud
- D. On-premise
正解:A、B
解説:
SAP Analytics Cloud supports two primary types of data connections: Live Data Connection and Import Data Connection. Live Data Connection establishes a direct link to the data source, allowing real-time data access without replicating the data into SAP Analytics Cloud. This is ideal for scenarios where up-to-the-minute data is crucial, and data volume is large. On the other hand, Import Data Connection involves copying data from the source into SAP Analytics Cloud, which is suitable for scenarios where data doesn't change frequently, or there's a need for data transformation and enrichment within SAP Analytics Cloud.
Reference:
SAP Analytics Cloud Help Documentation: Data Connections Overview
SAP Analytics Cloud User Guide: Live Data vs. Import Data Scenarios
質問 # 45
You import data into a dataset. One of the columns imported is Year, and SAP Analytics Cloud interprets it as a measure. How can you ensure that it is treated as a calendar year?
- A. Insert a character into the Year measure using the transform bar.
- B. Includes the Year measure in a level-based time hierarchy in the dataset.
- C. Add the month as a suffix to the Year measure.
- D. Change the Year measure to a dimension in the dataset.
正解:D
解説:
If SAP Analytics Cloud interprets a 'Year' column as a measure instead of a dimension, it should be changed to a dimension to ensure it is treated as a calendar year. This adjustment can be made within the model or dataset settings, where the column's role can be switched from a measure (quantitative value) to a dimension (qualitative value). Treating 'Year' as a dimension allows it to be used appropriately in time-based analyses, such as trends over time, without being aggregated like a numerical measure.
質問 # 46
Where can you change a data lock status? Note: There are 2 correct answers to this question.
- A. Data action
- B. Calendar task
- C. Value lock management
- D. Multi action
正解:B、D
質問 # 47
Your users need to analyze data in a story. What kinds of data models can you create? Note: There are 2 correct answers to this question.
- A. Analytic
- B. Planning
- C. Embedded
- D. Standalone
正解:A、B
質問 # 48
How can you determine node relationships in a value driver tree? Note: There are 2 correct answers to this question.
- A. Use a calculated member
- B. Use a dimension hierarchy
- C. Use a model converted measure
- D. Use a story calculated measure
正解:A、B
質問 # 49
What can you use to organize dimensions into logical categories in a live model?
- A. Groups
- B. Parent-child hierarchy
- C. Value driver tree
- D. Level-based hierarchy
正解:B
解説:
In a live model within SAP Analytics Cloud, dimensions can be organized into logical categories using either level-based hierarchies or parent-child hierarchies. Level-based hierarchies are used when the relationships between items are defined by distinct levels, such as Geography might be divided into Country, State, and City levels. Parent-child hierarchies, on the other hand, are useful when the data's hierarchy is not strictly defined by levels but by a parent relationship where a child member is associated with a parent member, which is common in organizational structures or product categories.
Reference:
SAP Analytics Cloud Help Documentation: Creating and Managing Hierarchies SAP Analytics Cloud User Guide: Working with Models
質問 # 50
What can you do to reduce the data refresh time when opening a story? Note: There are 3 correct answers to this question.
- A. Use conditional formatting
- B. Load widgets in the background
- C. Avaid tables with more than 500 rows and 60 columns
- D. Avaid prompts
- E. Use responsive pages
正解:A、B、C
質問 # 51
......
試験問題集でC_SAC_2501練習無料最新のSAP練習テスト:https://jp.fast2test.com/C_SAC_2501-premium-file.html