ERASED TEST, YOU MAY BE INTERESTED ON Reporting BI
COMMENTS |
STATISTICS |
RECORDS
|
|---|
TAKE THE TEST
|
Title of test:
Reporting BI Description: Reporting BI Author:
Creation Date: 20/02/2025 Category: Others Number of questions: 60 |
Share the Test:
New Comment
No comments about this test.
Content:
|
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. 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 data functions Use fewer IF statements Use fewer aggregation dimension functions. What type of predictive scenario can write back to a planning model? Regression Classification Time series forecast Value driver tree. How can you determine node relationships in a value driver tree? Note: There are 2 correct answers to this question. Use a dimension hierarchy Use a calculated member Use a story calculated measure Use a model converted measure. You are creating a new public version. Which categories can you use? Note: There are 2 correct answers to this question. Budget Actual Predictive Forecast. You input new data for a private version in a story. What must you do to ensure the new data is added to the model? Save Send Publish Nothing. What account types use the average rate type? Note: There are 2 correct answers to this question. INC AST EXP LEQ. Where can you create a blank planning version In a data cell In version management In the version dimension In the planning model. What must a data model contain in SAP Analytics Cloud? Note: There are 2 correct answers to this question. Calculations Dimensions Measures Hierarchies. Which of the following data sources can you use in SAP Analytics Cloud data analyzer? Note: There are 3 correct answers to this question. SAP Analytics Cloud public dataset SAP HANA view SAP Datasphere model SAP Analytics Cloud analytic model SAP BusinessObjects Universe. 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 data model. Create a calculated dimension in the story. Group the Firstname and Lastname in the data model. 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 Standalone Embedded Planning Analytic. Which SAP Analytics Cloud feature uses natural language processing Digital boardroom Data analyzer Smart insight Just Ask feature. Which automatically created dimension type can you delete from an analytic data model? Version Date . Organization Generic. You want to save your data analyzer result. What is it saved as? Story Insight Dataset Model. 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 dimension type can you use like a measure? Account Date Organization Entity. What features are supported by data analyzer? Note: There are 3 correct answers to this question. Linked dimensions Calculated measures Conditional formatting Input controls Charts. In a data model, what can you use to further describe a dimension? Data action Measure Property Variable. 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? 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. In a planning data model, what dimensions are included by default? Note: There are 2 correct Answers to this question. Date Version Entity Organization. Which tasks can you perform in data analyzer? Note: There are 2 correct answers to this question. Input data Filter data Drill down data 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 data set imported data model. Which programming language is used for scripting in an SAP Analytics Cloud story? Python wrangling express language ABAP Java Script. 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 Grid Responsive Composite Canvas. To which story elements can you apply conditional formatting? Note: There are 2 correct answers to this question. Table Line Chart Composite. 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. 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. 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. 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 Explorer. For which activities must you enable Advanced Mode in story design? 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 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. What can you use to perform cell-based calculations in a story? Calculated measures Dimension formulas Restricted measures Table formulas. 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. Which calculation types include dynamic date options? Note: There are 2 correct answers to this Question Aggregation Date Difference Restricted Measure Difference From. What is required to use version management in a story? Planning model Classic mode Analytic model Optimized mode. You want to display differences between measures in a chart. What can you use? Variance Restricted measure Threshold Reference line. How can you limit the refresh time of a story? Use canvas pages Collapse the hierarchy Create calculated measures Implement a value driver tree. How can you help a user enter data faster in a planning story? Note: There are 2 correct answers to this question. Enable Optimize Recommended Planning Area in the model. Select fluid data entry mode in the story. Set Size Limits for Planning Performance in the model. Enable unbooked data in the story. 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. 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. 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 Avaid tables with more than 500 rows and 60 columns Use conditional formatting Load widgets in the background Avaid prompts. 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 hyperlinks complex formating Many data sources Many story filters. What source system can you connect to with a live connection? SAP ERP Central Component SAP SuccessFactors SAP Business ByDesign Analytics SAP Datasphere. 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. 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 must you use to transform data in a dataset using if/then/else logic? Calculations editor Custom expression editor Formula bar Transform BAr. 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 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 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. 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 are the available connection types in SAP Analytics Cloud? Note: There are 2 correct answers to this question. Live Onpremise Cloud import. 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 are creating a script for an advanced data action. Which character designates a virtual variable member? % / * #. 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. 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 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 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. 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 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. |
Report abuse