DA-100 exam

HOTSPOT You are creating a quick measure as shown in the following exhibit. You need to create a monthly rolling average measure for Sales over time-How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one...

HOTSPOT You need to create a visualization to meet the reporting requirements of the sales managers. How should you create the visualization? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Scenario: The sales managers require a visual...

You need to create relationships to meet the reporting requirements of the customer service department. What should you create?A . an additional date table named ShipDate, a one-to-many relationship from Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]B . an additional date table named ShipDate, a many-to-many...

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 correct solution. After you...

You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports. What should you recommend?A . Create a shared dataset for each standardized entity.B . Create dataflows for the standardized data and make the dataflows available for...

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 correct solution. After you...

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 correct solution. After you...

HOTSPOT You are creating a column chart visualization. You configure groups as shown in the Groups exhibit. {Click the Groups tab.) The visualization appears as shown in the Chart exhibit. (Click the Chart tab.) For each of the following statements, select Yes if the statement is true. Otherwise, select No....

You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?A . FORMAT('Date'[date], "MMM YYYY")B . FORMAT('Date' [date], "M YY")C . FORMAT('Date'[date_id], "MMM") ""& & FORMAT('Date'[year], "#")D . FORMAT('Date' [date_id], "MMM YYYY")View AnswerAnswer: A Explanation: Scenario: In the Date...

Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.A . a line chart that shows balances by quarter filtered to account categories that are long-term...