24_C_02_SA

You want to display differences between measures in a chart. What can you use?. Variance. Restricted measure. Threshold. Reference line.

In a data model, what can you use to further describe a dimension?. Data action. Measure. Property. Variable.

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

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

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

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 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.

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.

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.

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

How can you determine node relationships in a value driver tree? Note: There are 2 correct answers to this question. Use a model converted measure. Use a story calculated measure. Use a dimension hierarchy. Use a calculated member.

What account types use the Average rate type? Note: There are 2 correct answers to this question. INC. LEQ. AST. EXP.

You create a private version. Which options can you use to let others users adapt this plan data? Note: There are 2 correct answers to this question. Submit. Publish As. Share. Copy.

You are using mass data entry mode. After you enter new transaction data, what can you do with the data? Note: There is 1 correct answer to this question. Publish. Process. Approve. Reject.

You are creating a new public version. Which categories can you use? Note: There are 2 correct answers to this question. Budget. Forecast. Actual. Predictive.

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

Which of the following data sources can you use in Analytics cloud data analyzer? Note There are 3 correcst anwers to this question. Datasphere model. Analytics cloud public dataset. Analytics cloud analytic model. Hana View. Business Objects universe.

You input new data for a private version in a story. Which must you do to ensure the new data is added to the model?. Save. Send. Publish. Nothing.

Which dimension type can you use like a measure?. Entity. Account. Date. Organization.

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 a System Administration. Fluid. Single. Mass.

Your users need to analyze data in a story. What kind of data models can you create? There are 2 correct answers to this question. Standalone. Embedded. Planning. Analytic.

Your embedded dataset in Analytics Cloud has columns for Country, Region, City, And Customer Name. You want to aggregate measures, for these columns. What can you do?. Create a parent-child hierarchy in the dataset. Create a level-based hierarchy in the dataset. Convert the embedded dataset to a model. Create a group that includes the model.

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

Where can you create a blank planning version?. In a data cell. In version management. In the version dimension. In the planning model.

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

Which Analyticsc feature uses natural language processing?. A Digital board room. Data analyzer. Smart insight. Just Ask feature.

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.

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.

What is required to use version management in a story?. Planning model. Classic mode. Analytic model. Optimized model.

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

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.

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

In a planning data model, what dimensions are included by default? Note: There are 2 correct answers to this question. Date. Version. Entity. Organization.

You have a dataset that extracts data from an BW system. The data in the BW system changes. How can you update the dataset?. You must create a new dataset. You must manually reimport the data. You must refresh the story that uses the dataset. You can schedule the dataset to update on a regular basis.

Which tasks can you perform in data analyzer? Note: There are 2 correct answers to this question. Input data. Filter data. Drill down on data. Create cross-calculation.

In which types of data source can you concatenate data? Note: There are 3 correct answers to this question. Embedded data set. Live data model. Data analyzer insight. Standalone dataset. Imported data model.

Which programming language is used for scripting in an Analytics Cloud story?. Python. Wrangling Expression Language. ABAP. JavaScript.

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.

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

You need to run allocations on two models: the expense mode and the sales model: What do you need to create?. One multi action with two steps. One allocation step with two steps. One data action with two steps. One process flow with two sequences.

Which of the following is supported when using composites in a story?. Save as a template. Include on a responsive page. Add comments. Use linked analysis.

Which of the following file types can you use t create an embedded dataset in an Analytics Cloud story? Not there are 3 correct answers to this question. Xlsx. Csv. Mdb. Txt. wid.

What can you use to analyze the system performance?. Data analyzer. Search to Insight. Smart Discovery. System-included stories.

You have three source systems in your organization. You want to use Analyticsc to analyze data from each source system. One source system uses a live connection. The other two use an import connection. How many connections do you require in Analytics Cloud?. 1. 2. 3. 4.

Which scenario types can you select when you create a new Predictive Scenario in Analytics Cloud? Note: There are 2 correct Answers to this question. Exponential Smoothing. Regression. Classification. Linear Regression.

What is emphasized in the Performance, Troubleshooting, and Security Management segment of the SAP Analytics Cloud exam? Please choose the correct answer. Promoting product sales. Identifying and resolving performance issues. Conducting legal compliance audits. Enhancing corporate branding.

How can data analysts ensure data consistency across different reports in Analytics cloud? There are 3 correct answers to this question. By using data locking. Implementing shared dimensions. Applying consistent filter settings. Enabling automatic data refresh. Utilizing master data management.

What can you do to reduce the data refresh time when opening a story? Note: There are 3 correct answers 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 prompt.

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.

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.

How can you help a user enter data faster in a planning story? Note: There are 2 correct answers to this question. Select fluid data entry mode in the story. Enable Optimize Recommended Planning Area in the model. Set Size Limits for Planning Performance in the model. Enable unbooked data in the story.

What features are supported by data analyzer? Note: There are 3 correct answers to this question. Calculated measures. Linked dimensions. Conditional formatting. Input Controls. Charts.

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

You have a live data model with two dimensions: Firstname and Last name. 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. Group the Firstname and Lastname in the data model. Create a calculated dimension in the data model. Create a calculated dimension in the story.

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

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

In Analytics Cloud Analytics Designer, what does the automatic syntax check do? Note: There are 3 correct answers to this question. Balance brackets. Find errors within one script. Find errors within the whole application. Correct capitalization automatically. Division by zero.

Which transformation functions can you use when wrangling data? Note: There are 3 correct answers to this question. Substring. Replace. Split. If. Concatenate.

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

Which Analytics Cloud function can be specified in AO, edition for Analytics Cloud?. Define Dimensions. Define Private Versions. Define Allocations. Define Value Driver Trees.

You import data into a dataset. One of the columns imported is Year, and 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. Add the month as a suffix to the Year measure. Insert a character into the Year measure using the transform bar. Includes the Year measure in a level-based time hierarchy in the dataset.

Which of the following options are included with the Analytics cloud, embedded edition? Note: There are 2 correct Answers to this question. Import connections. Planning professional license. Business intelligence license. Live connections.

Which automatically created dimension type can you delete from an analytic data model?. Generic. Date. Version. Organization.

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

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

Which filter type can you select when you enable watch Exporting for PDF files? Please choose the correct answer. Page filter. Chart filter. Story filter. Measure filter.

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

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

If you share a story with Access mode Edit, what can recipients do to the story? Note: There are 2 correct Answers to this question. Delete comments. Copy the story. Share the story. Add comments.

What are the main components of Analytics cloud Business Intelligence? There are 3 correct answers to this question. Models. Analytic Applications. Predictive Scenario. Planning. Stories.

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.

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

In basic story design, which mathematical predictions can you choose manually to create a forecast? There are 2 correct answers to this question. Linear regression. Extrapolation. Moving average. Exponential smoothing.

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.

You want to total several income and expense accounts using the account type property. Note: There are 2 correct answers to this question. Data action. Value lock management. Multi action. Calendar task.

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