Verified Microsoft DA-100 Free Question Online

NEW QUESTION 1

You need to create a visual as shown in the following exhibit.

The indicator color for Total Sales will be based on % Growth to Last Year. The solution must use the existing calculations only.
How should you configure the visual? 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 2

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 3

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 4

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 measure
• B. a trendline
• C. a forecast
• D. an Average line

Answer: B

NEW QUESTION 5

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 6

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 7

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 8

You need to create a visualization to meet the reporting requirements of the sales managers.
How should you create the visualization? 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 9

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 10

You have a query that returns the data shown in the following exhibit.

You need to configure the query to display the data as shown in the following exhibit.

Which step should you use in the query?

• A. =Table.ExpandListColum(Table.TransformColunins(Source, {{"classes".Splitter.SplitTextByDelimiter('','', QuoteStyle.None), let itemType - (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "classes")
• B. = Table.Unpivot(Source, {"classes"}, "Attribute", "Value")
• C. = Table.SplitColumn(Source, "classes". Splitter.SplitTextByDelimiterf",", QuoteStyle.None),{"classes.1"})
• D. = Table.SplitColumn(Source, "classes". Splitter.SplitTextByPositions({10}), {"classes.1"})

Answer: D

NEW QUESTION 11

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 12

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 13

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 14

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. Select Column profile, and then select the sales_amount column.
• D. Transform the sales_amount column to replace negative values with 0.

Answer: A

NEW QUESTION 15

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 16

You have a report page that contains the visuals shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 17

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 18

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