Pass the Microsoft Certified: Power BI Data Analyst Associate PL-300 Questions and answers with ExamsMirror

You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements.

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

NOTE: Each correct selection is worth one point.

You need to create the semantic model.

Which storage mode should you use for the tables in the semantic model?

You are creating a query to be used as a Country dimension in a star schema.

A snapshot of the source data is shown in the following table.

You need to create the dimension. The dimension must contain a list of unique countries.

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

You have an on-premises Power BI Report Server.

You plan to create a report in Power BI Desktop and publish the report to the report server.

Which data source should the report use?

You are creating a Microsoft Power BI data model that has the tables shown in the following table.

The Products table is related to the ProductCategory table through the ProductCategoryID column.

You need to ensure that you can analyze sales by product category.

How should you configure the relationships from Products to ProductCategory? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You publish a semantic model to the Power Bl service. The semantic model contains a connection to an on-premises Microsoft SQL Server database.

You attempt to configure a scheduled refresh but cannot select the appropriate on-premises data gateway.

You confirm the following with the administrator of the gateway:

• You have the appropriate permissions to use the gateway.

• The data source was created on the gateway.

• The gateway has a status of Running.

What is the most likely reason the gateway is unavailable?

You ate creating a Power 81 report that will show the number of current employees over time. The report will use Import storage mode for all tables.

The employment data will be imported from Azure SQL Database in a monthly snapshot. The data will be stored in a table named Headcount and will contain the following:

• One row per employee for each month the employee is employed

• In each row, a date key that shows the first day of the month of each snapshot

You have a related date table that contains dates for the years 2020 to 2030.

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 a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:

• Due Date

• Order Date

• Delivery Date

You need to support the analysis of sales over time based on all three dates at the same time.

Solution; You create measures that use the uSEREIATIOHSHIP DAX function to filter sales on the inactive relationships between the sales table and the date table.

Does this meet the goal?

You need to use Power B1 to create a visual that will allow users to compare the sales performance of five sales regions for the current month.

Which visual should you use?

You have a sales system that contains the tables shown in the following table.

The Date table is marked as a date table.

DatelD is the date data type. You need to create an annual sales growth percentage measure.

Which DAX expression should you use?