Online Access Free DA-100 Exam Questions

You have a line chart that shows the number of employees in a department over time.
You need to see the total salary costs of the employees when you hover over a data point.
What is possible way to achieve this goal?

• A.Add salary to the drillthrough fields.
• B.Add a salary to the tooltips.
• C.Add a salary to the visual filters.

You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer segment. The column chart shows sales by month.
You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month belongs to the customer segment.
How should the visual interactions be set on the column chart when the bar chart is selected?

• A.highlight
• B.no impact
• C.filter

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.For the three entities, create exports of the data from the Power Bl model to Excel and store the data in Microsoft OneDrive for others to use as a source.
• B.Create dataflows for the standardized data and make the dataflows available for use in all imported datasets.
• C.For every report, create and use a single shared dataset that contains the standardized data.
• D.Create a shared dataset for each standardized entity.

You have an API that returns more than 100 columns. The following is a sample of column names.
client_notified_timestamp
client_notified_source
client_notified_sourceid
client_notified_value
client_responded_timestamp
client_responded_source
client_responded_sourceid
client_responded_value
You plan to include only a subset of the returned columns.
You need to remove any columns that have a suffix of sourceid.
How should you complete the Power Query M code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

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 answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create a constant line and set the value to .5.
Does this meet the goal?

• A.No
• B.Yes