You have a Power 31 data model that contains a table named Stores. The table has the following columns:

* Store Name

* Open Date

* Status

* State

* City

You need to create a calculated column named Active Store Name that meets the following requirements:

You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?

You publish the dataset to powerbi.com.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

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?

You need to provide a solution to provide the sales managers with the required access.

What should you include in the solution?

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.

You need to address the data concerns before creating the data model. What should you do in Power Query Editor?

You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection'

What should you create to meet the reporting requirements of the sales department?

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

You need to create relationships to meet the reporting requirements of the customer service department.

What should you create?

You publish the semantic model to powerbi.com.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

You merge data from Sales.Region, Region_Manager, Sales_Manager, and Manager into a single table named Region. What should you do next to meet the reporting requirements of the executives?

What is the minimum number of datasets and storage modes required to support the reports?

You need to grant access to the business unit analysts.

What should you configure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You need to create a DAX measure in the data model that only allows users to see projections at the appropriate levels of granularity.

How should you complete the measure? To answer, drag the appropriate values to the correct targets. Each value 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.

You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports.

What should you recommend?

Which DAX expression should you use to get the ending balances in the balance sheet reports?

Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

You need to create the relationship between the product list and the revenue results. The solution must minimize the time it takes to render visuals.

What should you set as the relationship cardinality?

How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You need to ensure that the data is updated to meet the report requirements. The solution must minimize configuration effort.

What should you do?

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 have an on-premises data gateway.

You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode.

Solution: You configure incremental refresh.

Does this meet the goal?

Your company plans to use Power BI for 20 users in the sales department. The users will perform the following tasks:

Access a published Power BI app

Modify reports in an app workspace

Share dashboards created in My Workspace

You need to identify which Power BI licenses are required for the tasks. The solution must use the Power BI (free) licenses, whenever possible.

Which license should you identify for each task? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have a Power Bl report that contains a measure named Total Sales.

You need to create a new measure that will return the sum of Total Sates for a year up to a selected date. How should you complete the DAX expression? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:

First name

Last name

Email address

State/Region

Phone number

You import the list into Power Query Editor.

You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You have a Power B1 report that contains a card. The card displays the value for year-to-date revenue.

You need to ensure that screen reader users can read the value when initially interacting with the card. The value must stay updated as the dataset is refreshed.

What should you do?

You have a Power Bl report that contains five pages.

Pages 1 to 4 are visible and page 5 is hidden.

You need to create a solution that will enable users to quickly navigate from the first page to all the other visible pages. The solution must minimize development and maintenance effort as pages are added to the report.

What should you do first?

You have a Power BI semantic model.

You discover that he semantic model contains values that display as errors.

You need to use data profiling feature in Power Query to preview the date and identify the issues.

What should you select to gain into the number of errors in the model, and what should you select to resolve the errors? To answer, select the appropriate options in the answer area.

NOTE: Each correct answer is worth one point.

You have a Power B1 semantic model that contains two tables named Dim Location and Fact Deliveries. The relationships between the tables are configured as shown in the following table.

The model contains one measure that has the following formula.

Deliveries = COUNTROWS('fact Deliveries')

You plan to create a report that will display sales data from the last year for multiple regions

You need to restrict access to individual rows of the data on a per region-basis by using roles.

Which four 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.

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?

You have a query in Power Query Editor that contains the following data.

You need to transform the data to appear as shown in the following table.

What should you do?

You have a folder that contains 100 CSV files.

You need to make the file metadata available as a single dataset by using Power Bi The solution must NOT store the data of the CSV files.

Which three actions should you perform in sequence. To answer, mow the appropriate actions from the list of actions to the answer area and arrange them m the correct order.

NOTE; More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

You are configuring a Power BI report for accessibility as shown in the following table.

You need to change the default colors of all three visuals to make the report more accessible to users who have color vision deficiency.

Which two settings should you configure in the Customize theme window? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

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?

You are creating a sales report in Power Bl for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in the following table:

The report will facilitate the following analysis:

• The count of orders and the sum of total sales by Order Date

• The count of customers who placed an order

• The average quantity per order

You need to reduce data refresh times and report query times.

Which two actions should you perform? Each correct answer presents part of the solution

NOTE: Each correct selection is worth one point.

You are building a dataset from a JSON file that contains an array of documents.

You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in Microsoft Power BI reports.

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.

You have a semantic model that connects to a streaming data source. The data source is updated frequently. You need to create a Power B1 report that meets the following requirements:

• Supports real-time analytics

• Minimizes performance impact on the data source

• Displays the most recent data without performing a data refresh

Which connectivity mode should you use for the dataset?

You have a Power BI semantic model that contains a table named Table1. Table1 contains the following columns:

* WebsiteName

* URL

You need to create a report named Report1 that will contain a table visual. The solution must meet the following requirements.

* Display the website name

* Enable users to navigate to the website’s URL by selecting the website name.

What should you use?

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?

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 (PII). The solution must minimize configuration effort and impact on the dashboard design.

What should you use?

You need to create a solution to meet the notification requirements of the warehouse shipping department.

What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct select is worth one point:

You need to create the Top Customers report.

Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You need to minimize the size of the semantic model. The solution must meet the report requirements.

What should you do?

You need to create a measure that will return the percentage of late orders.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.