C_SACS_2308 Practice Exam Questions with Answers SAP Certified Application Associate - SAP Analytics Cloud Story Design Certification

A public dataset is a type of dataset that is shared among different stories. You can use public datasets to create stories or blend data with models. A public dataset has the following properties:

• It can be shared among different stories. You can use public datasets in multiple stories without having to import them again.
• It cannot be converted to a model. You cannot convert a public dataset to a model. If you want to create a model from a public dataset, you have to import it as a private dataset first.
• Its data is not structured in a star schema. A public dataset does not have any predefined dimensions or measures. It only has columns and rows of data.
• Its data source cannot be changed. You cannot change the data source of a public dataset after you import it. If you want to update the data in a public dataset, you have to import a new file.

The Optimized Design Experience is a new design option for creating stories in SAP Analytics Cloud. It offers several usability improvements and performance enhancements compared to the Classic Design Experience. However, it also has some limitations and differences, such as the unavailability of some elements that are present in the Classic Design Experience1.

The following filter options are supported in the Optimized Design Experience:

• Input Control: This option allows you to add interactive filters to a story page that allow the story viewers to filter data, compare figures, and explore relationships directly from the page. You can use the Input Controls tool in the Tools section to select dimensions or measures that you want to use as input controls2.
• Cascading: This option allows you to create a hierarchy of input controls that depend on each other. You can use this option to filter data based on multiple levels of a dimension, such as Country, Region, and City. You can also use this option to filter data based on different dimensions that are related, such as Product Category and Product Name3.
• Section: This option is not a filter option, but a way of organizing a story into different parts based on a dimension. A section creates a separate page for each member of the dimension, and displays the same widgets on each page with the data filtered by the section dimension. Sections are available in both the Optimized and Classic Design Experiences4.

The other options are not supported in the Optimized Design Experience, because:

• Advanced: This option allows you to create complex filters using logical operators, such as AND, OR, and NOT. You can use this option to filter data based on multiple conditions or expressions, such as Revenue > 1000 AND Profit Margin < 10%. Advanced filters are available only in the Classic Design Experience.
• Controls: This option is not a valid filter option in SAP Analytics Cloud. It may refer to input controls, which are supported, or chart controls, which are not supported. Chart controls are buttons that allow you to change the chart type, switch between absolute and relative values, or drill up and down in a hierarchy. Chart controls are available only in the Classic Design Experience.

References:

1: Choosing Between Optimized and Classic Design Modes - SAP Learning 2: Using Input Controls - SAP Learning 3: Creating Cascading Input Controls - SAP Learning 4: Creating Sections - SAP Learning : [Advanced Filters - SAP Learning] : [Chart Controls - SAP Learning]

The SAP Digital Boardroom supports engaging with a remote audience through annotations and screen sharing. Annotations allow users to highlight or draw on the screen using different colors and shapes, which can help to emphasize key points or explain complex concepts. Screen sharing allows users to share their screen with other participants who join the digital boardroom session via a web browser, which can help to facilitate collaboration and communication. Data Analyzer and story editing are not features that support engaging with a remote audience; they are features that allow users to analyze data or modify stories in the digital boardroom. Verified References: [SAP Analytics Cloud - Digital Boardroom]

You can use table templates and styling rules to change the formatting of a table in the Styling panel. Table templates allow you to apply predefined formats to tables, such as alternating row colors, grid lines, and font sizes. Styling rules allow you to apply conditional formatting to tables, such as changing the background color, font color, or icon based on certain criteria. In-cell charts and thresholds are not available in the Styling panel; they are options that can be enabled or disabled in the Builder panel. Verified References: [SAP Analytics Cloud - Table Formatting]

According to the SAP Help Portal1, stories can be viewed only in portrait mode for phones and landscape mode for tablets; the stories do not rotate their orientation. This is a unique quality of viewing stories on a mobile device, as opposed to viewing them on a computer browser, where the stories can be rotated and resized according to the screen dimensions. Therefore, it is important to design stories for mobile devices using the Responsive page and the Device Preview Bar in SAP Analytics Cloud Story Design.

The data source connection that can be used in SAP Analytics Cloud to wrangle data is imported. Imported data sources are data files that are uploaded to SAP Analytics Cloud and stored in its internal database. Users can wrangle imported data sources using the Data Preparation feature, which allows them to transform, enrich, cleanse, and merge data. Live and public data sources cannot be used to wrangle data in SAP Analytics Cloud; live data sources remain in their original systems and public data sources are read-only datasets provided by SAP. Verified References: [SAP Analytics Cloud - Data Preparation]

When a model includes a prompt, the prompt is presented at runtime before data can be displayed in the story. The prompt allows users to select the values they want to filter the data by. The prompt is not related to the predefined widgets, the rendering of widgets, or the navigation to widgets. Verified References: [SAP Analytics Cloud - Prompting]

The correct answers are A. Intersecting data only, D. All primary data, and E. All data. These are the three link types that you can use to blend data in a story, according to the SAP Learning course on Blending Data in Models1. The link type determines how the dimension data from the primary and secondary models are displayed in the blended chart or table

These are two of the options that you can use for data wrangling when you import a file for a story in SAP Analytics Cloud, according to the SAP Help Portal1. Data wrangling is the process of cleaning, structuring, and enriching raw data into a desired format for better decision making in less time2.

The custom expression editor is a tool that allows you to create or edit formulas and expressions for your data columns3. You can access the custom expression editor by clicking on the formula icon in the builder panel or by double-clicking on a column header in the data view3. The custom expression editor provides a list of functions and operators that you can use to manipulate your data, such as arithmetic, logical, string, date, and aggregation functions3. You can also use the custom expression editor to create calculated columns or measure-based dimensions from your existing columns3.

The transform bar is a tool that allows you to apply various transformations to your data columns, such as renaming, reordering, grouping, splitting, merging, or deleting columns4. You can access the transform bar by clicking on the transform icon in the builder panel or by right-clicking on a column header in the data view4. The transform bar provides a list of actions that you can use to modify your data structure, such as move left, move right, group by, split by delimiter, merge columns, or delete column4. You can also use the transform bar to change the data type or format of your columns, such as text, number, date, currency, or percentage4.

The sort options that are available in stories are ascending and descending order, and multiple dimensions together. Ascending and descending order allow you to sort data by one or more dimensions or measures in ascending or descending order. Multiple dimensions together allow you to sort data by more than one dimension in a hierarchical order. Dimensions and measures together, and multiple measures together are not valid sort options in stories. Verified References: [SAP Analytics Cloud - Sorting]

The presentation types for the Digital Boardroom are dashboard and agenda. Dashboard allows users to create a custom layout of widgets and pages on a large screen, such as a wall-mounted monitor or a projector. Agenda allows users to create a structured sequence of pages and topics that can be navigated using a touch screen, such as a tablet or a laptop. Custom and canvas are not presentation types for the Digital Boardroom; they are options that can be used to design dashboard layouts or story pages. Verified References: [SAP Analytics Cloud - Digital Boardroom]

A dataset is a type of data source that allows you to import data from files, such as Excel or CSV files. You can use datasets to create stories or blend data with models. However, datasets have some limitations, such as:

• They cannot be scheduled. You have to manually refresh the data in a dataset.
• They do not support column-based or property security. You cannot restrict access to certain columns or properties in a dataset.
• They do not support transformations. You cannot apply any transformations to the data in a dataset.
• They can overwrite imported data. You can choose to append or replace the data in a dataset when you import a new file.

Therefore, the correct answer is They cannot be scheduled and They do not support column-based or property security, as they are the limitations of datasets.

The link type determines how the data from the primary and secondary models are blended in a story. There are three link types: Primary, All, and Intersection1.

• Primary: Only the data from the primary model that matches the data from the secondary model is displayed. This is equivalent to an inner join in SQL.
• All: All the data from both models is displayed, regardless of whether they match or not. This is equivalent to a full outer join in SQL.
• Intersection: Only the data that exists in both models is displayed. This is equivalent to an intersection in set theory.

In this case, the link type that returns what data is Intersection, because it only shows the data that is common to both models, such as Customer A and Customer B. Customer C and Customer D are excluded because they do not exist in both models.