Test Part 1

You are creating a styling rule for a table with a hierarchy of Country, Region, and City. You want to apply the styling rule only to countries. Which level option must you use?. Self and Siblings. Self and Children. Self and Descendants. Self.

You need to delete characters from a column in a dataset. What can you use? Note: There are 2 correct answers to this question. Custom expression editor. Formula bar. Calculation editor. Transform bar.

You have a live data model with two dimensions: Firstname and Lastname. Users want a single dimension in the data model that displays the dimensions as Lastname, Firstname. What must you do?. Create the combined data in the source system. Create a calculated dimension in the story. Create a calculated dimension in the data model. Group the Firstname and Lastname in the data model.

You are creating a styling rule for a table. What is the context?. The most granular level in the table. The highest level in the table. The table header. The location of the cursor.

Why would you use predictive analytics in SAP Analytics Cloud? Please choose the correct answer. To predict software trends. To forecast business outcomes. To enhance hardware durability. To increase advertising reach.

When addressing a performance issue in SAP Analytics Cloud, which of the following should be analyzed first? Please choose the correct answer. User access levels. Network latency. Data model complexity. Optimized Design mode.

For which activities must you enable Advanced Mode in story design? Note: There are 2 correct answers to this question. Add a popup. Add JavaScript to a button. Add a layer to a geo map. Add a custom widget.

Which of the Augmented Analytics Smart Features in SAP Analytics Cloud generates fully populated, multi-tabbed stories?. Search to Insight. Smart Predict. Predictive Forecast. Smart Discovery.

What can you use to analyze the system performance? Please choose the correct answer. Search to Insight. System-included stories. Data analyzer. By using data locking.

How can you improve the performance of advanced data actions? Note: There are 3 correct answers to this question. Use fewer MEMBERSET statements. Use fewer FOREACH functions. Use fewer IF statements. Use fewer data functions. Use fewer aggregation dimension functions.

Which SAP Analytics Cloud feature uses natural language processing?. Smart insight. Digital boardroom. Data analyzer. Just Ask feature.

What can you use to perform cell-based calculations in a story?. Calculated measures. Dimension formulas. Restricted measures. Table formulas.

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?. Use two properties. Dis-able allocations. Use two hierarchies. Dis-able distribution.

What can you use input controls for in a story? Note: There are 2 correct answers to this question. Changing dimensions or measures displayed in a table. Filtering data on a page. Selecting an alternate data source. Implementing row-level and column-level security in a table.

What can you do to reduce the data refresh time when opening a story? Note: There are 3 correct to this question. Use responsive pages. Avoid tables with more than 500 rows and 60 columns. Load widgets in the background. Use conditional formatting. Avoid prompts.

You want to save your data analyzer result. What is it saved as?. Story. Insight. Dataset. Model.

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?. Fluid. Single. Mass.

What must a data model contain in SAP Analytics Cloud? Note: There are 2 correct answers to this question. Measures. Calculations. Hierarchies. Dimensions.

You are using a live connection for a model. Where can you define data security?. Source system. Data access control. SAP Analytics Cloud model. SAP Analytics Cloud role.

What are the available connection types in SAP Analytics Cloud? Note: There are 2 correct answers to this question. Live. On-premise. Cloud. Import.

You want to use an input control to filter data appearing in a story. At what level is the filter applied?. Calculation. Page. Component. Story.

For which activities must you enable Advanced Mode in story design? Note: There are 2 correct to this question. Add JavaScript to a button. Add a popup. Add a layer to a geo map. Add a custom widget.

You have a column chart in a story. You notice some of the labels are missing until you mouse over the data point. How can you ensure that the labels are always visible?. Increase the overall size of the chart widget on the page. Select the Avoid Data Label Overlap checkbox. Increase the font size of the axis labels.

When scrolling down in a long table, how can you retain column headers? Note: There are 2 correct answers to this question. Freeze Up to column. Enable Auto-Size And Page Table Vertically. Enable Keeping member names visible. Freeze Up to row.

Browser cache settings02. You want to use a composite in your SAP Analytics Cloud story designer. Which of the following are prerequisites?There are 2 correct answers to this question. Optimized Design mode. Grid page. Classic Design mode. Canvas page.

What can you use to organize dimensions into logical categories in a live model?. Level-based hierarchy. Groups. Value driver tree. Parent-child hierarchy.

What can you do with a multi action? Note: There are 2 correct answers to this question. Run allocation data actions. Import transaction data. Approve data. Run allocation processes.

Which of the following file types can you use to create an embedded dataset in an SAP Analytics Cloud story? There are 3 correct answers to this question. xlsx. CSV. mdb. txt. wid.

What source system can you connect to with a live connection?. SAP ERP Central Component. SAP SuccessFactors. SAP Business ByDesign Analytics. SAP Datasphere.

What type of predictive scenario can write back to a planning model?. Regression. Value driver tree. Classification. Time series forecast.

Where can you change a data lock status? Note: There are 2 correct answers to this question. Data action. Value lock management. Multi action. Calendar task.

You have a story in My Files. You want your colleague to review and comment on the story. What must you do?. Create a Review task for the story. Add a Comment widget to the story. Share with View access. Include the story in a Discussion.

What must you use to transform data in a dataset using if/then/else logic?. Calculations editor. Custom expression editor. Formula bar. Transform bar.

How can you limit the refresh time of a story?. Use canvas pages. Collapse the hierarchy. Create calculated measures. Implement a value driver tree.

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?. Level. Hierarchy. Cardinality. Granularity.

Your story takes a long time to open. What could cause this? Note: There are 3 correct answers to this question. Large calculation scope. Many story filters. Many hyperlinks. Complex formatting. Many data sources.

You are creating an allocation step to distribute expenses from the HR cost center to your operating cost centers. Which dimension setting controls how much is distributed to each operating cost center?. Reference. Driver. Distribute. Redistribute.

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?. Create a group that includes the dimensions. Create a level-based hierarchy in the dataset. Create a parent-child hierarchy in the dataset. Convert the embedded dataset to a model.

You have a story based on an import model. The transaction data in the model’s data source changes. How can you update the data in the model? Note: There are 2 correct answers to this question. Allow model import. Refresh the story. Refresh the import job. Schedule the import.

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?. Change the Year measure to a dimension in the dataset. Includes the Year measure in a level-based time hierarchy in the dataset. Insert a character into the Year measure using the transform bar. Add the month as a suffix to the Year measure.

You are designing a new story. You want the size and position of widgets to adjust dynamically for viewing on different devices and screen sizes. Which page type must you use?. Grid. Responsive. Composite. Canvas.

The SAP Analytics Cloud (SAC) modeler has removed the first three characters from an SAP Analytics Cloud public dimension imported from a source system. What is impacted by this change?. Public datasets. Source system. Stories. Embedded data sets.

Which calculation types include dynamic date options? Note: There are 2 correct answers to this. Aggregation. Date Difference. Restricted Measure. Difference From.

You want to total several income and expense accounts using the account type property. What configuration option in the advanced formula must you use?. Unbooked. Append. Signflip. Aggregate To.

You are creating a script for an advanced data action. Which character designates a virtual variable member?. %. /. *. #.

You want to total several income and expense accounts using the account type property. What configuration option in the advanced formula must you use?. Append. Unbooked. Signflip. Aggregate To.

When scrolling down in a long table, how can you retain column headers? Note: There are 2 correct answers to this question. Enable Keeping member names visible. Enable Auto-Size And Page Table Vertically. Freeze Up to row. Freeze Up to column.

You are using a live connection for a model. Where is the data stored?. Public dataset. SAP Analytics Cloud model. Source system. Embedded data set.

Which features are available in the Optimized Design Experience? Note: There are 3 correct to this question. Undo button. Grid pages. Linked widgets diagram. Composites. Explorer.

To which story elements can you apply conditional formatting? Note: There are 2 correct answers to this question. Table. Lane. Chart. Composite.