PL-300英文版

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 练习进度 0 / 0

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

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Question #24-2HOTSPOT -You have a column named UnitsInStock as shown in the following exhibit.

（含图）

UnitsInStock has 75 non-null values, of which 51 are unique.Use the drop-down menus to select the answer choice that completes each statement based on the information presented inthe graphic.NOTE: Each correct selection is worth one point.Hot Area:2、Changing the Summarize by setting of the UnitsInStock column, and then adding the column to a table visual, will [answer choice] the number of rows in the table visual:

（含图）

Question #25-1HOTSPOT -You have a Power BI report.You have the following tables.

（含图）

You have the following DAX measure.Accounts :=CALCULATE (DISTINCTCOUNT (Balances[AccountID]),LASTDATE ('Date'[Date])For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point.Hot Area:1、StatementsA table visual that displays the date hierarchy at the year level and the [Accounts] measure will show the total number of accounts that were live throughout the year:

（含图）

Question #25-2HOTSPOT -You have a Power BI report.You have the following tables.

（含图）

You have the following DAX measure.Accounts :=CALCULATE (DISTINCTCOUNT (Balances[AccountID]),LASTDATE ('Date'[Date])For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point.Hot Area:2、StatementsA table visual that displays the date hierarchy at the month level and the [Accounts] measure will show the total number of accounts that were live throughout the month:

（含图）

Question #25-3HOTSPOT -You have a Power BI report.You have the following tables.

（含图）

You have the following DAX measure.Accounts :=CALCULATE (DISTINCTCOUNT (Balances[AccountID]),LASTDATE ('Date'[Date])For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point.Hot Area:3、StatementsA table visual that displays the date hierarchy at the day level and the [Accounts] measure will show the total number of accounts that were live that day:

（含图）

Question #27-1HOTSPOT -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. Each product has oneproduct category.You need to ensure that you can analyze sales by product category.How should you configure the relationship from ProductCategory to Products? To answer, select the appropriate options in theanswer area.NOTE: Each correct selection is worth one point.Hot Area:1、Cardinality:

（含图）

Question #27-2HOTSPOT -You are creating a Microsoft Power BI data model that has the tables shown in the following table.

（含图）

Question #28You import a Power BI dataset that contains the following tables:DateProductProduct InventoryThe Product Inventory table contains 25 million rows. A sample of the data is shown in the following table.

（含图）

The Product Inventory table relates to the Date table by using the DateKey column. The Product Inventory table relates to theProduct table by using theProductKey column.You need to reduce the size of the data model without losing information.What should you do?

Question #29-1HOTSPOT -You are enhancing a Power BI model that has DAX calculations.You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.Which DAX functions should you use? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:1、RETURN：

（含图）

Question #29-2HOTSPOT -You are enhancing a Power BI model that has DAX calculations.You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.Which DAX functions should you use? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:2、( Sales[sales] ),：

（含图）

Question #29-3HOTSPOT -You are enhancing a Power BI model that has DAX calculations.You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.Which DAX functions should you use? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:3、( 'Calendar'[Date], startyear, enddate ):

（含图）

Question #30Note: 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 are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Orderthat 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 report-level filter that filters based on the order date.Does this meet the goal?

Question #31Note: 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: For each date foreign key, you add inactive relationships between the sales table and the date table.Does this meet the goal?

Question #32Note: 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: From Power Query Editor, you rename the date query as Due Date. You reference the Due Date query twice to makethe queries for Order Date andDelivery Date.Does this meet the goal?

Question #33Note: 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: From the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date andDelivery Date as calculated tables.Does this meet the goal?

Question #35-1HOTSPOT -You have a Power BI report named Orders that supports the following analysis:Total sales over timeThe count of orders over timeNew and repeat customer countsThe data model size is nearing the limit for a dataset in shared capacity.The model view for the dataset is shown in the following exhibit.

（含图）

The data view for the Orders table is shown in the following exhibit.

（含图）

The Orders table relates to the Customers table by using the CustomerID column.The Orders table relates to the Date table by using the OrderDate column.For each of the following statements, select Yes if the statement is true, Otherwise, select No.NOTE: Each correct selection is worth one point.Hot Area:1、StatementsSummarizing Orders by the CustomerID, OrderID, and OrderDate columns will reduce themodel size while still supporting the current analysis：

（含图）

Question #35-2HOTSPOT -You have a Power BI report named Orders that supports the following analysis:Total sales over timeThe count of orders over timeNew and repeat customer countsThe data model size is nearing the limit for a dataset in shared capacity.The model view for the dataset is shown in the following exhibit.

（含图）

The data view for the Orders table is shown in the following exhibit.

（含图）

The Orders table relates to the Customers table by using the CustomerID column.The Orders table relates to the Date table by using the OrderDate column.For each of the following statements, select Yes if the statement is true, Otherwise, select No.NOTE: Each correct selection is worth one point.Hot Area:2、StatementsRemoving the CustomerID column from Orders will reduce the model size while stillsupporting the current analysis:

（含图）

Question #35-3HOTSPOT -You have a Power BI report named Orders that supports the following analysis:Total sales over timeThe count of orders over timeNew and repeat customer countsThe data model size is nearing the limit for a dataset in shared capacity.The model view for the dataset is shown in the following exhibit.

（含图）

The data view for the Orders table is shown in the following exhibit.

（含图）

The Orders table relates to the Customers table by using the CustomerID column.The Orders table relates to the Date table by using the OrderDate column.For each of the following statements, select Yes if the statement is true, Otherwise, select No.NOTE: Each correct selection is worth one point.Hot Area:3、StatementsRemoving the UnitPrice and Discount columns from Orders will reduce the model size whilestill supporting the current analysis:

（含图）

Question #36-1HOTSPOT -You are building a financial report by using Power BI.You have a table named financials that contains a column named Date and a column named Sales.You need to create a measure that calculates the relative change in sales as compared to the previous quarter.How should you complete the measure? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:1、Box 1:

（含图）

Question #36-2HOTSPOT -You are building a financial report by using Power BI.You have a table named financials that contains a column named Date and a column named Sales.You need to create a measure that calculates the relative change in sales as compared to the previous quarter.How should you complete the measure? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:2、Box 2:

（含图）

Question #36-3HOTSPOT -You are building a financial report by using Power BI.You have a table named financials that contains a column named Date and a column named Sales.You need to create a measure that calculates the relative change in sales as compared to the previous quarter.How should you complete the measure? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:3、Box 3:

（含图）

1 3 4 5 6 7 22