Free Microsoft DA-100 Questions and Answers

Question 1

You are working with a sizable dataset that has more than a million rows. The table contains a Date datetime field.
Without sacrificing data access, the data model needs to be shrunk.
What ought you to do?

Accepted Answer

Split the Date column into two columns, one that contains only the time and another that contains only the date.

Answer

Change the data type of the Date column to Text.

Answer

Trim the Date column.

Answer

Round the hour of the Date column to startOfHour.

Question 2

You use Power Query Editor to generate the next step.
Table.ReplaceValue(SalesLT_Address,""1318"",""1319"",Replacer.ReplaceText, ""AddressLine1""
21318 Lasalle Street is the value for a row in the AddressLine1 column.
What will the value be after applying the step?

Accepted Answer

21319 Lasalle Street

Answer

1319

Answer

21318 Lasalle Street

Answer

1318

Question 3

You have a report from Microsoft Power BI. The PBIX file is 550 MB in size. By using an App workspace in a shared capacity on powerbi.com, one can see the report.
One fact table from an imported dataset is used in the report. There are 12 million rows in the fact table. At 8:00 and 17:00, the dataset will refresh twice daily.
The report is one page long and has 10 default visuals in addition to 15 AppSource visuals.
When users access and engage with the report, they complain that the visuals take a long time to load.
You must offer a suggestion for enhancing the report's functionality.
What ought to you suggest?

Accepted Answer

Change the imported dataset to DirectQuery.

Answer

Implement row-level security (RLS).

Answer

Increase the number of times that the dataset is refreshed.

Answer

Split the visuals onto multiple pages.

Question 4

You use the Microsoft Power BI Service to generate a dashboard. A card visual on the dashboard displays the overall sales for the current year.
Using the Viewer role on the workspace, you may provide users access to the dashboard.
The user requests daily alerts for the number displayed on the card visual.
Notifications must be automated.
What ought you to do?

Accepted Answer

Create a subscription.

Answer

Tag the user in a comment.

Answer

Create a data alert.

Answer

Share the dashboard to the user.

Question 5

Using Microsoft Power BI, you are modeling data that includes a sizable Microsoft SQL Server table called Order with more than 100 million records.
You must import a portion of the Order table's data during the development process.
Solution: Import the table from Power Query Editor, then add a filter step to the query.
Is the objective being met?

Accepted Answer

No

Answer

Yes

Question 6

A Microsoft Excel data source's file name and location are stored in a parameter you construct called DataSourceExcel.
Instead of using numerous copies of the location that are hard-coded into each query definition, you must edit the query to reference the parameter.
Solution: Replace all references to the Excel file in the Power Query M code with references to DataSourceExcel.
Is the objective being met?

Accepted Answer

No

Answer

Yes

Question 7

Using Microsoft Power BI, you are modeling data that includes a sizable Microsoft SQL Server table called Order with more than 100 million records.
You must import a portion of the Order table's data during the development process.
Solution: You modify the SQL statement by include a WHERE clause.
Is the objective being met?

Accepted Answer

Yes

Answer

No

Question 8

The creation of a Power BI dashboard is required. What instrument should you use?

Accepted Answer

The Power BI service

Answer

Power Query Editor

Answer

Power BI Desktop

Answer

The Power BI mobile app

Question 9

A Power BI dashboard must be made from a published report. Which report choice should you choose?

Accepted Answer

Pin visual

Answer

Spotlight

Answer

Copy visual as image

Answer

Export data

Question 10

You intend to certify a Power BI dataset. You must determine at what organizational level the authority to verify a dataset is delegated. Which level should you choose?

Accepted Answer

Tenant

Answer

Workspace

Answer

Dataset

Answer

Workbook