Abreast Of The Times Analyzing Data With Microsoft Power BI DA-100 Practice Exam

NEW QUESTION 1

You have a data model that contains many complex DAX expressions. The expressions contain frequent
references to the related and relatedtable functions. You need to recommend a solution to minimize the use of the related and relatedtable functions. What should you recommend?

• A. Merge tables by using Power Quer
• B. )
• C. Hide unused columns in the mode
• D. )
• E. Split the model into multiple models.
• F. Transpose.

Answer: A

NEW QUESTION 2

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 3

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_id],"WM YYYY")
• C. FORMAT('Date'[date],"M YY")
• D. FORMAT(‘Date’[date_id]-‘’MM") & " " & FORMAT ('Date' [year], "#")

Answer: D

NEW QUESTION 4

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 5

You are creating a visual to show the ranking of product categories by sales revenue.
Your company's security policy states that you cannot send data outside of your Microsoft Power Bl tenant Which approach provides the widest variety of visuals while adhering to the security policy?

• A. Use default visuals or custom visuals uploaded from a .pbiviz file.
• B. Use only default visuals.
• C. Use default or any custom visuals from the marketplace.
• D. Use default or certified custom visuals.

Answer: C

NEW QUESTION 6

You have multiple dashboards.
You need to ensure that when users browse the available dashboards from powerbi.com. they can see which dashboards contain Personally Identifiable Information (Pll). The solution must minimize configuration effort and impact on the dashboard design.
What should you use?

• A. Active Directory groups
• B. tiles
• C. data classifications
• D. comments

Answer: A

NEW QUESTION 7

You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success. Which type of visualization should you use?

• A. Key influences
• B. Funnel chart
• C. Q&A
• D. Line and clustered column chart

Answer: A

NEW QUESTION 8

You are modeling data in table named SalesDetail by using Microsoft Power Bl.
You need to provide end users with access to the summary statistics about the SalesDetail data. The users require insights on the completeness of the data and the value distributions.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 9

You have a Microsoft Power Bl workspace.
You need to grant the user capabilities shown in the following table.

The solution must use the principle of least privilege.
Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 10

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 11

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 12

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 13

You are configuring a Microsoft Power Bl data model to enable users to ask natural language questions by using Q&A. You have a table named Customer that has the following measure.
Customer Count = DISTINCTCOUNT(Customer[CustomerID]) Users frequently refer to customers as subscribers.
You need to ensure that the users can get a useful result for "subscriber count" by using Q&A. The solution
must minimize the size of the model. What should you do?

• A. Add a description of "subscriber count" to the Customer Count measure.
• B. Set Summarize By to None for the CustomerlD column.
• C. Add a description of "Subscriber" to the Customer table.
• D. Add a synonym of "subscriber" to the Customer table.

Answer: D

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: 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 15

You build a report about warehouse inventory data. The dataset has more than 10 million product records from 200 warehouses worldwide. You have a table named Products that contains the columns shown in the following table.

Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the ProductDescription column and is always the fourth value.
You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 16

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 17

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 18

You create a dashboard by using the Microsoft Power Bl Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the dashboard by using the viewer role on the workspace. A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications. What should you do?

• A. Share the dashboard to the user.
• B. Create a subscription.
• C. Create a data alert.
• D. Tag the user in a comment.

Answer: A

NEW QUESTION 19

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