[2025年更新]C-SAC-2501のPDF問題完璧見込みでPassTest練習試験合格させます
SAP C-SAC-2501 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
質問 # 10
Which automatically created dimension type can you delete from an analytic data model?
- A. Generic
- B. Version
- C. Date
- D. Organization
正解：A
解説：
In an analytic data model within SAP Analytics Cloud, the automatically created dimension type that you can delete is the Generic dimension. This type of dimension is typically used for custom or ad-hoc categorizations and, unlike system-generated dimensions like Date or Version, can be modified or removed as per the specific needs of your data model and analysis requirements.
Reference:
SAP Analytics Cloud Help Documentation: Data Model Dimensions
SAP Analytics Cloud User Guide: Managing Dimensions in Analytic Models
質問 # 11
What can you use to perform cell-based calculations in a story?
- A. Restricted measures
- B. Table formulas
- C. Calculated measures
- D. Dimension formulas
正解：B
解説：
Table formulas in SAP Analytics Cloud are used to perform cell-based calculations within a story. These formulas can be applied directly to table cells, allowing for customized calculations that are specific to the data presented in the table. This feature is particularly useful for ad-hoc analysis and when specific calculations are needed that are not covered by predefined measures or dimensions.
Reference:
SAP Analytics Cloud Help Documentation: Using Table Formulas
SAP Analytics Cloud User Guide: Cell-Based Calculations in Stories
質問 # 12
You want to save your data analyzer result. What is it saved as?
- A. Dataset
- B. Insight
- C. Model
- D. Story
正解：B
質問 # 13
You want to use an input control to filter data appearing in a story. At what level is the filter applied?
- A. Page
- B. Story
- C. Component
- D. Calculation
正解：A
解説：
When using an input control to filter data in a SAP Analytics Cloud story, the filter is applied at the Page level. This means that the selected filter criteria will affect all the components (tables, charts, etc.) on that particular page, allowing for a cohesive and consistent view of the data filtered according to the chosen parameters.
Reference:
SAP Analytics Cloud Help Documentation: Filtering Data with Input Controls SAP Analytics Cloud User Guide: Page-Level Filtering in Stories
質問 # 14
In which types of data source can you concatenate data? Note: There are 3 correct answers to this question.
- A. Live data model
- B. Standalone dataset
- C. Data analyzer insight
- D. Embedded data set
- E. Imported data model
正解：B、D、E
解説：
In SAP Analytics Cloud, data concatenation can be performed on Embedded datasets, Standalone datasets, and Imported data models. This process involves combining data from multiple sources or tables into a single dataset or model, providing a unified view of the data. This is particularly useful for analyses that require a comprehensive dataset compiled from various data sources.
Reference:
SAP Analytics Cloud Help Documentation: Working with Datasets
SAP Analytics Cloud User Guide: Concatenating Data in Models and Datasets
質問 # 15
You have a dataset that extracts data from an SAP Business Warehouse (SAP BW) system. The data in the SAP BW system changes. How can you update the dataset?
- A. You must create a new dataset.
- B. You must manually reimport the data.
- C. You must refresh the story that uses the dataset.
- D. You can schedule the dataset to update on a regular basis.
正解：D
解説：
For datasets that extract data from external systems like SAP Business Warehouse (SAP BW), SAP Analytics Cloud provides the capability to schedule updates on a regular basis. This feature ensures that the dataset within SAP Analytics Cloud remains up-to-date with the latest changes from the SAP BW system, without the need for manual reimport or creating a new dataset. Scheduled updates can be configured to run at specific intervals, automating the data refresh process.
Reference:
SAP Analytics Cloud Help Documentation: Scheduling Data Refresh
SAP Analytics Cloud User Guide: Automating Dataset Updates from External Sources
質問 # 16
You have a story in My Files. You want your colleague to review and comment on the story. What must you do?
- A. Share with View access
- B. Create a Review task for the story
- C. Add a Comment widget to the story
- D. Include the story in a Discussion
正解：A
質問 # 17
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. Create a parent-child hierarchy in the dataset.
- B. Create a group that includes the dimensions.
- C. Create a level-based hierarchy in the dataset.
- D. Convert the embedded dataset to a model.
正解：C
解説：
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
質問 # 18
What can you use input controls for in a story? Note: There are 2 correct answers to this question.
- A. Selecting an alternate data source
- B. Changing dimensions or measures displayed in a table
- C. Implementing row-level and column-level security in a table
- D. Filtering data on a page
正解：B、D
解説：
Input controls in a story in SAP Analytics Cloud can be used for changing dimensions or measures displayed in a table and for filtering data on a page. Input controls provide a way for users to interactively modify the view of the data, such as selecting which dimensions or measures to display, or filtering the entire page's content based on selected criteria, enhancing the interactivity and flexibility of data analysis within stories.
Reference:
SAP Analytics Cloud Help Documentation: Input Controls in Stories
SAP Analytics Cloud User Guide: Using Input Controls for Data Interaction
質問 # 19
What features are supported by data analyzer? Note: There are 3 correct answers to this question.
- A. Charts
- B. Linked dimensions
- C. Conditional formatting
- D. Input controls
- E. Calculated measures
正解：A、C、E
質問 # 20
You have a dimension with members for product groups and products. Each product group has associated products. You want to plan by product group without disaggregating into the products. How can you do this?
- A. Dis-able distribution
- B. Use two hierarchies
- C. Use two properties
- D. Dis-able allocations
正解：B
解説：
When you have a dimension with members for product groups and associated products and want to plan by product group without disaggregating into the individual products, using two hierarchies is the best approach. One hierarchy can represent the product groups at a higher level, allowing for planning and analysis at the group level. The second hierarchy can include both the product groups and their associated individual products for more detailed analysis when needed. This approach provides flexibility in planning and analyzing data at different levels of detail without the necessity of disaggregating data at the product group level.
Reference:
SAP Analytics Cloud Help Documentation: Hierarchies in Planning
SAP Analytics Cloud User Guide: Managing Hierarchies for Planning
質問 # 21
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. Calculation editor
- B. Formula bar
- C. Transform bar
- D. Custom expression editor
正解：C、D
質問 # 22
You are using a live connection for a model. Where is the data stored?
- A. Public dataset
- B. Source system
- C. Embedded data set
- D. SAP Analytics Cloud model
正解：B
解説：
Connections and data preparation
When using a live connection in SAP Analytics Cloud, the data remains stored in the source system. This means that no data is imported or replicated into SAP Analytics Cloud; instead, it is accessed and analyzed in real-time directly from the source system. This approach ensures that the most current data is always used for analysis and that data governance and security policies of the source system remain in control.
Reference:
Live Data Connections to SAP S/4HANA | SAP Help Portal1
SAP Analytics Cloud Connection Guide2
SAP Analytics Cloud Data Connections - InsightCubes
In the context of SAP Analytics Cloud, when using a live connection to connect to a data source, the data remains stored in the source system. This setup means that SAP Analytics Cloud directly queries the data in its original location, without importing or copying it into the SAP Analytics Cloud environment. This approach is advantageous for several reasons, including maintaining a single source of truth, reducing data redundancy, and ensuring data is always up-to-date without the need for synchronization processes. Live connections are particularly useful for real-time or near-real-time data analysis and reporting, providing insights based on the most current data available without the overhead of data replication.
SAP Analytics Cloud documentation and user guides typically emphasize the benefits and use cases of live connections, highlighting how they maintain data in the source system to ensure real-time data access and analysis.
SAP training materials for Data Analysts using SAP Analytics Cloud, including study guides and official certification resources, explain the technical and practical aspects of live connections, including where data is stored and how it is accessed.
Best practice guides for SAP Analytics Cloud, often available through the SAP Community or SAP Knowledge Base, provide insights and recommendations on setting up and using live connections, reinforcing the concept that data stays in the source system.
質問 # 23
How can you help a user enter data faster in a planning story? Note: There are 2 correct answers to this question.
- A. Set Size Limits for Planning Performance in the model.
- B. Select fluid data entry mode in the story.
- C. Enable Optimize Recommended Planning Area in the model.
- D. Enable unbooked data in the story.
正解：B、C
質問 # 24
You are creating a styling rule for a table. What is the context?
- A. The highest level in the table
- B. The location of the cursor
- C. The table header
- D. The most granular level in the table
正解：B
質問 # 25
Which SAP Analytics Cloud feature uses natural language processing?
- A. Digital boardroom
- B. Data analyzer
- C. Smart insight
- D. Just Ask feature
正解：D
質問 # 26
In a data model, what can you use to further describe a dimension?
- A. Variable
- B. Data action
- C. Property
- D. Measure
正解：C
解説：
In a data model within SAP Analytics Cloud, Properties are used to further describe dimensions. Properties provide additional context or metadata for dimension members, such as descriptions, classifications, or other attributes that help to better understand and analyze the data within the dimension. This makes properties essential for detailed data analysis and reporting.
Reference:
SAP Analytics Cloud Help Documentation: Dimension Properties
SAP Analytics Cloud User Guide: Enhancing Dimensions with Properties
質問 # 27
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. Signflip
- B. Append
- C. Unbooked
- D. Aggregate To
正解：A
質問 # 28
You are using a live connection for a model. Where can you define data security?
- A. Source system
- B. Data access control
- C. SAP Analytics Cloud model
- D. SAP Analytics Cloud role
正解：A
解説：
When using a live connection in SAP Analytics Cloud, data security is defined and managed within the source system. This approach leverages the existing security protocols and permissions set up in the source system, ensuring that data governance and access controls remain consistent and are centrally managed. Users accessing data through SAP Analytics Cloud with a live connection will be subject to the same security constraints and permissions as if they were accessing the data directly from the source system. This integration ensures a unified security model, simplifying administration and ensuring data security and compliance.
質問 # 29
How can you limit the refresh time of a story?
- A. Create calculated measures
- B. Implement a value driver tree
- C. Use canvas pages
- D. Collapse the hierarchy
正解：D
解説：
Collapsing the hierarchy in a story can help limit the refresh time, as it reduces the amount of data that needs to be processed and displayed at any given time. By presenting data at a higher aggregation level initially, you can improve performance and allow users to expand specific sections of the hierarchy as needed for more detailed analysis.
Reference:
SAP Analytics Cloud Help Documentation: Improving Story Performance
SAP Analytics Cloud User Guide: Managing Data Hierarchy for Performance
質問 # 30
You are creating a new public version. Which categories can you use? Note: There are 2 correct answers to this question.
- A. Budget
- B. Actual
- C. Predictive
- D. Forecast
正解：B、D
質問 # 31
......
オンライン問題傑作練習用であなたの試験を合格してみせます：https://www.passtest.jp/SAP/C-SAC-2501-shiken.html
練習できるC-SAC-2501にはPassTest明確な練習であなたをSAP Certified Associate - Data Analyst - SAP Analytics Cloud試験合格させます：https://drive.google.com/open?id=1i6-wappMNE_afwoU5RsJg7wZn6-rcCXI