DA-100 exam

You plan to create the chart shown in the following exhibit. How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?A . Create a horizontal line that has a fixed value of 24,000.B . Add a measure to the visual that...

HOTSPOT How should you distribute the reports to the board? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: Using a workspace membership Scenario: The company wants to provide a single package of reports to the...

You have a sales system that contains the tables shown in the following table. The Date table is marked as a date table. DatelD is the date data type. You need to create an annual sales growth percentage measure. Which DAX expression should you use?A . SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR('Date'[DatelD])B...

DRAG DROP Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? To answer, move the appropriate actions from the list of actions to the answer area and arrange them...

HOTSPOT You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer area....

You have a table that contains sales data and approximately 1,000 rows. You need to identify outliers in the table. Which type of visualization should you use?A . area chartB . donut chartC . scatter plotD . pie chartView AnswerAnswer: C

HOTSPOT You need to create a visual as shown in the following exhibit. The indicator color for Total Sales will be based on % Growth to Last Year. The solution must use the existing calculations only. How should you configure the visual? To answer, select the appropriate options in the...

You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success. Which type of visualization should you use?A . Key influencesB . Funnel chartC . Q&AD . Line and clustered...

You have the visual shown in the exhibit. (Click the Exhibit tab.) You need to show the relationship between Total Cost and Total Sales over time. What should you do?A . Add a play axis.B . Add a slicer for the year.C . From the Analytics pane, add an Average...

Topic 3, Misc. Questions Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a...