PL-300英文版

更新时间：试题数量：购买人数：提供作者：

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 练习进度 0 / 0

随机练习 自定义设置练习量

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

学习资料 考试学习相关信息

搜索

题库预览

Question #39You are creating a Power BI model that contains a table named Store. Store contains the following fields.

（含图）

You plan to create a map visual that will show store locations and provide the ability to drill down from Country toState/Province to City.What should you do to ensure that the locations are mapped properly?

Question #40You are building a data model for a Power BI report.You have data formatted as shown in the following table.

（含图）

You need to create a clustered bar chart as shown in the following exhibit.

（含图）

What should you do?

Question #42Note: This question is part of a series of questions that present the same scenario. Each question in the series contains aunique solution that might meet the stated goals. Some question sets might have more than one correct solution, while othersmight 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 inthe 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 salestable has the following date foreign keys:Due DateOrder DateDelivery DateYou need to support the analysis of sales over time based on all the date foreign keys.Solution: You create measures that use the USERELATIONSHIP DAX function to filter sales on the active relationship betweenthe sales table and the date table.Does this meet the goal?

Question #43-1HOTSPOT -You have a Power BI report that contains a measure named Total Sales.You need to create a new measure that will return the sum of Total Sales 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.Hot Area:1、Measure =：

（含图）

Question #43-2HOTSPOT -You have a Power BI report that contains a measure named Total Sales.You need to create a new measure that will return the sum of Total Sales 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.Hot Area:2、[Total Sales],：

（含图）

Question #45You have a Power BI report for the procurement department. The report contains data from the following tables.

（含图）

There is a one-to-many relationship from Suppliers to LineItems that uses the ID and Supplier ID columns.The report contains the visuals shown in the following table.

（含图）

You need to minimize the size of the dataset without affecting the visuals.What should you do?

Question #47-1HOTSPOT-You are creating a quick measure as shown in the following exhibit.

（含图）

You need to create a monthly rolling average measure for Sales over time.How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.1、Base value:

（含图）

Question #47-2HOTSPOT-You are creating a quick measure as shown in the following exhibit.

（含图）

Question #47-3HOTSPOT-You are creating a quick measure as shown in the following exhibit.

（含图）

Question #48You have the Power BI data model shown in the following exhibit.

（含图）

The Sales table contains records of sales by day from the last five years up until today’s date.You plan to create a measure to return the total sales of March 2021 when March 2022 is selected.Which DAX expression should you use?

Question #50Note: This question is part of a series of questions that present the same scenario. Each question in the series contains aunique solution that might meet the stated goals. Some question sets might have more than one correct solution, while othersmight 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 inthe review screen.From Power Query Editor, you profile the data shown in the following exhibit.

（含图）

The IoT GUID and IoT ID columns are unique to each row in the query.You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.Solution: You split the IoT DateTime column into a column named Date and a column named Time.Does this meet the goal?

Question #51Note: This question is part of a series of questions that present the same scenario. Each question in the series contains aunique solution that might meet the stated goals. Some question sets might have more than one correct solution, while othersmight 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 inthe review screen.From Power Query Editor, you profile the data shown in the following exhibit.

（含图）

The IoT GUID and IoT ID columns are unique to each row in the query.You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.Solution: You remove the IoT GUID column and retain the IoT ID column.Does this meet the goal?

Question #52Note: This question is part of a series of questions that present the same scenario. Each question in the series contains aunique solution that might meet the stated goals. Some question sets might have more than one correct solution, while othersmight 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 inthe review screen.From Power Query Editor, you profile the data shown in the following exhibit.

（含图）

The IoT GUID and IoT ID columns are unique to each row in the query.You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.Solution: You change the IoT DateTime column to the Date data type.Does this meet the goal?

Question #53You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace inshared capacity of powerbi.com.The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset isscheduled to refresh twice a day at 08:00 and 17:00.The report is a single page that contains 15 AppSource 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?

Question #56You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace inshared capacity of powerbi.com.The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset isscheduled to refresh twice a day at 08:00 and 17:00.The report is a single page that contains 15 AppSource 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?

Question #57-1HOTSPOT-You have a Power BI data model that contains a table named Stores. The table has the following columns:• Store Name• Open Date• Status• State• CityYou need to create a calculated column named Active Store Name that meets the following requirements:• When the value of the Status column is “A”, the value in the Store Name column must be returned.• When the value of the Status column is NOT “A”, the value in the Store Name column that is prefixed with "Inactive - " must bereturned.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.1、Box 1:

（含图）

Question #57-2HOTSPOT-You have a Power BI data model that contains a table named Stores. The table has the following columns:• Store Name• Open Date• Status• State• CityYou need to create a calculated column named Active Store Name that meets the following requirements:• When the value of the Status column is “A”, the value in the Store Name column must be returned.• When the value of the Status column is NOT “A”, the value in the Store Name column that is prefixed with "Inactive - " must bereturned.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.2、Box 2:

（含图）

Question #58You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date andtime each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.What should you do?

Question #59Note: This question is part of a series of questions that present the same scenario. Each question in the series contains aunique solution that might meet the stated goals. Some question sets might have more than one correct solution, while othersmight 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 inthe review screen.From Power Query Editor, you profile the data shown in the following exhibit.

（含图）

The IoT GUID and IoT ID columns are unique to each row in the query.You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.Solution: You create a custom column that concatenates the IoT GUID column and the IoT ID column and then delete the IoTGUID and IoT ID columns.Does this meet the goal?

Question #60You have a Power BI model that contains a table named Employee. The table contains the following data.

（含图）

Each employee has one manager as shown in the ParentEmployeeID column.All reporting paths lead to the CEO at the top of the organizational hierarchy.You need to create a calculated column that returns the count of levels from each employee to the CEO.Which DAX expression should you use?

1 4 5 6 7 8 22