TheEnhanced Dataflows Compute Engine is turned on for the dataflow.

You need to use the dataflow in a report. The solution must meet the following requirements:

✑ Minimize online processing operations.

✑ Minimize calculation times and render times for visuals.

✑ Include data from the current year, up to and including the previous day.

What should you do?

16.商业智能（BI）开发人员在Power BI中创建数据流，该数据流使用DirectQuery从本地Microsoft SQL服务器访问表。

数据流的增强型数据流计算引擎已打开。

您需要在报告中使用数据流。解决方案必须满足以下要求：

✑ 最小化在线处理操作。

✑ 最小化视觉效果的计算时间和渲染时间。

✑ 包括从当前年份到前一天（包括前一天）的数据。

你该怎么办？

You publish a dataset that contains data from an on-premises Microsoft SQL Server database.

The dataset must be refreshed daily.

You need to ensure that the Power BI service can connect to the database and refresh the dataset.

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.

发布包含本地Microsoft SQL Server数据库中数据的数据集。

数据集必须每天刷新。

您需要确保Power BI服务可以连接到数据库并刷新数据集。

你应该依次执行哪四个动作？要回答此问题，请从以下列表中移动相应的操作

并按照正确的顺序排列。

（含图）

From the Get Data connector list, you discover that there is no specific connector for the Cassandra database.

You need to select an alternate data connector that will connect to the database.

Which type of connector should you choose?

18.您尝试将Power BI Desktop连接到Cassandra数据库。

从Get Data连接器列表中，您发现Cassandra数据库没有特定的连接器。

您需要选择将连接到数据库的备用数据连接器。

您应该选择哪种类型的连接器？

You receive annual sales data that must be included in Power BI reports.

您收到的年度销售数据必须包含在Power BI报告中。

From Power Query Editor, you connect to the Microsoft Excel source shown in the following exhibit.

从Power Query Editor，您可以连接到下图所示的Microsoft Excel源。

（含图）

You need to create a report that meets the following requirements:

您需要创建满足以下要求的报告：

• Visualizes the Sales value over a period of years and months

可视化几年和几个月内的销售价值

• Adds a slicer for the month

添加当月切片器

• Adds a slicer for the year

添加年度切片器

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.

你应该依次执行哪三个动作？要回答，请将适当的动作从动作列表移动到回答区域，并按正确的顺序排列。

（含图）

20.您正在使用Power BI Desktop连接到Azure SQL数据库。

The connection is configured as shown in the following exhibit.

连接配置如下图所示。

（含图）

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 solution is worth one point.

注意：每一个正确的解决方案值一分。

（含图）

1.您计划创建展示中所示的Power BI模型。（单击“展示”选项卡。）

（含图）

The data has the following refresh requirements:

数据具有以下刷新要求：

✑ Customer must be refreshed daily.

 必须每天刷新客户。

✑ Date must be refreshed once every three years.

日期必须每三年刷新一次。

✑ Sales must be refreshed in near real time.

 必须近实时刷新销售。

✑ SalesAggregate must be refreshed once per week.

 SalesAggregate必须每周刷新一次。

You need to select the storage modes for the tables. The solution must meet the following requirements:

您需要选择表的存储模式。解决方案必须满足以下要求：

✑ Minimize the load times of visuals.

 最小化视觉效果的加载时间。

✑ Ensure that the data is loaded to the model based on the refresh requirements.

 确保根据刷新要求将数据加载到模型中。

Which storage mode should you select for each table? To answer, select the appropriate options in the answer area.

您应该为每个表选择哪种存储模式？要回答，请在回答区域中选择适当的选项。

NOTE: Each correct selection is worth one point.

注：每一个正确的选择值一分。

Hot Area:

热点区域：

（含图）

1-2.您有一个完全托管在Microsoft团队中的项目管理应用程序。该应用程序是使用Microsoft Power Apps开发的。

You need to create a Power BI report that connects to the project management app.

您需要创建连接到项目管理应用程序的Power BI报告。

Which connector should you select?

您应该选择哪个连接器？

1-3.对于贵公司的销售部门，您可以发布Power BI报告，该报告从Microsoft SharePoint文件夹中的Microsoft Excel文件导入数据。

The data model contains several measures.

数据模型包含几个度量。

You need to create a Power BI report from the existing data. The solution must minimize development effort.

您需要从现有数据创建Power BI报告。解决方案必须尽量减少开发工作。

Which type of data source should you use?

您应该使用哪种类型的数据源？

将两个名为Customer和Address的Microsoft Excel表导入Power Query。客户包含以下列：

✑ Customer ID客户ID

✑ Customer Name客户名称

✑ Phone 电话

✑ Email Address电子邮件地址

✑ Address ID地址ID

Address contains the following columns:

地址包含以下列：

✑ Address ID地址ID

✑ Address Line 1 地址行1

✑ Address Line 2地址行2

✑ City城市

✑ State/Region州/地区

✑ Country国

✑ Postal Code邮政编码

Each Customer ID represents a unique customer in the Customer table. Each Address ID represents a unique address in the Address table.

每个Customer ID表示Customer表中的唯一客户。每个地址ID表示地址表中的唯一地址。

You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer.

您需要创建一个每个客户有一行的查询。每行必须包含每个客户的城市、州/地区和国家。

What should you do?

你该怎么办？

您有两个包含相同表和列的Azure SQL数据库。

For each database, you create a query that retrieves data from a table named Customer.

对于每个数据库，创建一个查询，从名为Customer的表中检索数据。

You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com.

您需要将Customer表合并为一个表。该解决方案必须最小化数据模型的大小，并支持powerbi.com中的定时刷新。

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

你该怎么办？要回答，请在回答区域中选择适当的选项。

NOTE: Each correct selection is worth one point.

注：每一个正确的选择值一分。

（含图）

拖放-

In Power Query Editor, you have three queries named ProductCategory, ProductSubCategory, and Product.

在Power Query Editor中，有三个名为ProductCategory、ProductSubCategory和Product的查询。

Every Product has a ProductSubCategory.

每个产品都有一个ProductSubCategory。

Not every ProductsubCategory has a parent ProductCategory.

并非每个ProductsubCategory都有父ProductCategory。

You need to merge the three queries into a single query. The solution must ensure the best performance in Power Query.

您需要将这三个查询合并为一个查询。解决方案必须确保Power Query中的最佳性能。

How should you merge the tables? To answer, drag the appropriate merge types to the correct queries. Each merge type 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.

注：每一个正确的选择值一分。

Select and Place:

选择并放置：

（含图）

您正在构建Power BI报告，该报告使用名为erp1的Azure SQL数据库中的数据。

You import the following tables.

您可以导入下表。

（含图）

You need to perform the following analyses:

您需要执行以下分析：

✑ Orders sold over time that include a measure of the total order value

随时间售出的订单，包括订单总价值的度量

✑ Orders by attributes of products sold

按销售产品属性排序的订单

The solution must minimize update times when interacting with visuals in the report.

解决方案必须在与报告中的视觉效果交互时尽量缩短更新时间。

What should you do first?

你应该先做什么？

您的Microsoft SharePoint Online网站包含多个文档库。

One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.

其中一个文档库包含保存为Microsoft Excel文件的制造报告。所有制造报告都具有相同的数据结构。

You need to use Power BI Desktop to load only the manufacturing reports to a table for analysis.

您需要使用Power BI Desktop仅将制造报告加载到表中进行分析。

What should you do?

你该怎么办？

You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2.

您的Microsoft Excel工作簿包含两个名为Sheet1和Sheet2的工作表。

Sheet1 contains the following table named Table1.

Sheet1包含名为Table1的下表。

（含图）

Sheet2 contains the following table named Table2.

Sheet2包含名为Table2的下表。

（含图）

You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values.

您需要使用Power Query Editor将Table1和Table2的产品组合到下表中，该表有一列不包含重复值。

（含图）

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.

你应该依次执行哪三个动作？要回答，请将适当的动作从动作列表移动到回答区域，并按正确的顺序排列。

Select and Place:

选择并放置：

（含图）

您需要能够根据记录的日期分析投诉，并使用内置的日期层次结构。

What should you do?

你该怎么办？

您需要能够根据记录的日期分析投诉，并使用内置的日期层次结构。

What should you do?

你该怎么办？

您在Microsoft OneDrive文件夹中有一个Microsoft Excel文件。

The file must be imported to a Power BI dataset.

必须将文件导入Power BI数据集。

You need to ensure that the dataset can be refreshed in powerbi.com.

您需要确保数据集可以在powerbi.com中刷新。

Which two connectors can you use to connect to the file? Each correct answer presents a complete solution.

您可以使用哪两个连接器连接到文件？每一个正确的答案都提供了一个完整的解决方案。

NOTE: Each correct selection is worth one point.

注：每一个正确的选择值一分。

您正在使用Power Query Editor分析数据。

You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data in State is shown in the following exhibit.

您有一个名为Reports的表，其中包含名为State的列。状态数据的分布和质量数据指标如下图所示。

（含图）

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.

注：每一个正确的选择值一分。

Hot Area:

热点区域：

（含图）

您有两个名为Products和Categories的CSV文件。

The Products file contains the following columns:

产品文件包含以下列：

✑ ProductID产品ID

✑ ProductName产品名称

✑ SupplierID供应商ID

✑ CategoryID类别ID

The Categories file contains the following columns:

类别文件包含以下列：

✑ CategoryID类别ID

✑ CategoryName 类型名

✑ CategoryDescription类别说明

From Power BI Desktop, you import the files into Power Query Editor.

从Power BI Desktop将文件导入Power Query Editor。

You need to create a Power BI dataset that will contain a single table named Product. The Product will table includes the following columns:

您需要创建一个Power BI数据集，其中包含一个名为Product的表。产品列表包括以下列：

✑ ProductID产品ID

✑ ProductName 产品名称

✑ SupplierID 供应商ID

✑ CategoryID类别ID

✑ CategoryName类型名

✑ CategoryDescription类别说明

How should you combine the queries, and what should you do on the Categories query? To answer, select the appropriate options in the answer area.

应该如何组合查询，以及应该对Categories查询执行什么操作？要回答，请在回答区域中选择适当的选项。

NOTE: Each correct selection is worth one point.

注：每一个正确的选择值一分。

Hot Area:

热点区域：

（含图）

您有一个包含销售事务的Azure SQL数据库。数据库经常更新。

You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.

您需要根据数据生成报告以检测欺诈交易。数据必须在更新后五分钟内可见。

How should you configure the data connection?

您应该如何配置数据连接？

拖放-

You have a folder that contains 100 CSV files.

您有一个包含100个CSV文件的文件夹。

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.

您需要使用Power BI使文件元数据作为单个数据集可用。解决方案不能存储CSV文件的数据。

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.

你应该依次执行哪三个动作。要回答，请将适当的动作从动作列表移动到回答区域，并按正确的顺序排列。

Select and Place:

选择并放置：

（含图）