What Downloadable DA-100 Free Exam Questions Is

NEW QUESTION 1

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

Answer: D

NEW QUESTION 2

You have a report that contains four pages. Each page contains slicers for the same four fields. Users report dthat when they select values on a slicer on one page, the visuals are not updated on all the pages. You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages. What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

• A. Sync the slicers across the pages.
• B. Replace the slicers with page-level filters.
• C. Replace the slicers with visual-level filters.
• D. Create a bookmark for each slicer value.
• E. Replace the slicers with report-level filters.

Answer: BD

NEW QUESTION 3

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 4

You receive revenue data that must be included in Microsoft Power Bl reports.
You perform an initial load of the data from a Microsoft Excel source as shown in the following exhibit.

You plan to create several visuals from the data, including a visual that shows revenue split by year and product.
You need to transform the data to ensure that you can build the visuals. The solution must ensure that the columns are named appropriately for the data that they contain.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 5

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 6

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 7

You create the following step by using Power Query Editor.
= Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"})
A row has a value of 21318 Lasalle Street in the AddressLine1 column. What will the value be when the step is applied?

• A. 1318
• B. 1319
• C. 21318 Lasalle Street
• D. 21319 Lasalle Street

Answer: B

NEW QUESTION 8

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 9

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 10

You view a query named Transactions as shown in the following exhibit.

The query gets CSV files from a folder.
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 11

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 12

You are creating a column chart visualization.
You configure groups as shown in the Groups exhibit. {Click the Groups tab.)

The visualization appears as shown in the Chart exhibit. (Click the Chart 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 13

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 14

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 15

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 16

You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exhibit. (Click the Exhibit tab.)

What occurred at 12:03:06 PM?

• A. A user pressed F5
• B. A new transaction was added to the data source.
• C. A user added a comment to a tile.
• D. The dashboard tile cache refreshed.

Answer: A

NEW QUESTION 17
......