Free Microsoft DA-100 Exam Dumps Questions & Answers

You need to address the data concerns before creating the data model. What should you do in Power Query Editor?

• A.Select Column distribution.
• B.Select the sales_amount column and apply a number filter.
• C.Transform the sales_amount column to replace negative values with 0.
• D.Select Column profile, and then select the sales_amount column.

You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers?

• A.Publish the reports to a different workspace other than the one hosting the datasets.
• B.Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.
• C.Add the HR managers as members of the existing workspace that hosts the reports and the datasets.
• D.Publish the reports in an app and grant the HR managers access permission.

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 section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: You add a WHERE clause to the SQL statement.
Does this meet the goal?

• A.No
• B.Yes

You have the visual shown in the Original exhibit. {Click the Original tab.)

You need to configure the visual as shown in the Modified exhibit. (Click the Modified tab.)

What should you add to the visual?

• A.a forecast
• B.a measure
• C.a trendline
• D.an Average line

You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product.
The Sales table contains purchase and ship dates.
Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.
You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source.
Which data modeling design should you use?

• A.On the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view.
• B.Use the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Date table.
• C.Create an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship date.
• D.Duplicate the Date query in Power Query and use active relationships between both Date tables.