Microsoft DA-100 Free Practice Questions

NEW QUESTION 1

You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.
You need to load only the manufacturing reports to a table for analysis. What should you do in Microsoft Power Bl Desktop?

• A. Get data from a SharePoint Online list, enter the site URL and then select Combine & Load.
• B. Get data from a SharePoint Online folder and enter the site UR
• C. Edit the query and filter by folder path.
• D. Get data from a SharePoint Online folder, enter the site URL, and then select Combine & Load.
• E. Get data from a SharePoint Online list and enter the site UR
• F. Edit the query and filter by folder path.

Answer: A

NEW QUESTION 2

You import a large dataset to Power Query Editor.
You need to identify whether a column contains only unique values.
Which two Data Preview options can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point

• A. Show whitespace
• B. Column distribution
• C. Column profile
• D. Column quality
• E. Monospaced

Answer: AD

NEW QUESTION 3

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 Bl. 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. Yes
• B. No

Answer: A

NEW QUESTION 4

Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power Bl.
You need to recommend an application lifecycle strategy. The solution must minimize maintenance to update access and prevent end users from viewing the development assets.
What should you recommend?

• A. Create production reports in a separate workspace that uses a shared dataset from the development workspac
• B. Grant the end users access to the production workspace.
• C. In the same workspace, create separate copies of the assets and append DEV to the names of the copied asset
• D. Grant the end users access to the workspace.
• E. Create separate workspaces for development and productio
• F. Grant the end users access to the production workspace.
• G. Create one workspace for developmen
• H. From the workspace, publish an app for production.

Answer: C

NEW QUESTION 5

You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?

• A. In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table.
• B. Add the Weekly_Returns data to the Sales table by using related DAX functions.
• C. Create a new table based on the Date table where date-id is unique, and then create a many-to-many relationship to Weekly_Return.

Answer: A

NEW QUESTION 6

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 uses the following DAX expression.Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],©.40)
• C. Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
• D. Add a measure to the visual that uses the following DAX expression.Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)

Answer: D

NEW QUESTION 7

You have four sales regions. Each region has multiple sales managers.
You implement row-level security (RLS) in a data model. You assign the relevant distribution lists to each role.
You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions.
A sales manager changes to a different region.
You need to ensure that the sales manager can see the correct sales data. What should you do?

• A. From Microsoft Power Bl Desktop, edit the Row-Level Security setting for the reports.
• B. Change the Microsoft Power Bl license type of the sales manager.
• C. Manage the permissions of the underlying dataset
• D. Request that the sales manager be added to the correct Azure Active Directory group.

Answer: A

NEW QUESTION 8

You have a Microsoft Power Bl dashboard.
You need to ensure that consumers of the dashboard can give you feedback that will be visible to the other consumers of the dashboard.
What should you use?

• A. Feedback
• B. Subscribe
• C. Comments
• D. Mark as favorite

Answer: D

NEW QUESTION 9

You are creating an analytics report that will consume data from the tables shown in the following table.

There is a relationship between the tables.
There are no reporting requirements on employeejd and employee_photo. You need to optimize the data model
What should you configure for employeejd and employee.photo? To answer, select the appropriate options in the answer area.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 10

You build a report to analyze customer transactions from a database that contains the tables shown in the following table.

You import the tables.
Which relationship should you use to link the tables?

• A. one-to-many from Customer to Transaction
• B. one-to-one between Customer and Transaction
• C. one-to-many from Transaction to Customer
• D. many-to-many between Customer and Transaction

Answer: B

NEW QUESTION 11

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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.
Solution: In the Power Query M code, you replace references to the Excel file with DataSourceExcel. Does this meet the goal?

• A. Yes
• B. No

Answer: B

NEW QUESTION 12

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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.
Solution: You add a Power Apps custom visual to the report. Does this meet the goal?

• A. Yes
• B. No

Answer: A

NEW QUESTION 13

You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. CityData contains only the data shown in the following table.

Sales contains only the data shown in the following table.

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 14

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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.
Solution: You create a new query that references DataSourceExcel. Does this meet the goal?

• A. Yes
• B. No

Answer: B

NEW QUESTION 15

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 point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 16

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 chart
• B. donut chart
• C. scatter plot
• D. pie chart

Answer: D

NEW QUESTION 17

You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.
The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.
The report is a single page that contains 15 custom visuals and 10 default visuals.
Users say that the report is slow to load the visuals when they access and interact with the report You need to recommend a solution to improve the performance of the report.
What should you recommend?

• A. Split the visuals onto multiple pages.
• B. Implement row-level security (RLS).
• C. Replace the default visuals with custom visuals.
• D. Increase the number of times that the dataset is refreshed.

Answer: A

NEW QUESTION 18

You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?

• A. Change the data type of Sales[region_id] to Whole Number.
• B. In the Sales table, add a measure for sum(sales_amount).
• C. Change the data type of sales[sales_id] to Text.
• D. Change the data type of sales [region_id] to Decimal Number.

Answer: C

NEW QUESTION 19

You have a folder of monthly transaction extracts.
You plan to create a report to analyze the transaction data.
You receive the following email message: "Hi. I've put 24 files of monthly transaction data onto the shared drive. File Transactions202101.csv through Transactions202112.csv have the latest set of columns, but files Transactions202101.csv to Transactions202112.csv have an older layout without the extra fields needed for analysis. Each file contains 10 to 50 transactions."
You get data from the folder and select Combine & Load. The Combine Files dialog box is shown in the exhibit. (Click the Exhibit tab.)

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 20
......