pl-300_without_discussion_1-299

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

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 练习进度 0 / 0

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

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

From Power Query Editor, you attempt to execute a query and receive the following error message. Datasource.Error: Could not find file. What are two possible causes of the error? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

You have a PBIX file that imports data from a Microsoft Excel data source stored in a file share on a local network. You are notified that the Excel data source was moved to a new location. You need to update the PBIX file to use the new location. What are three ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

You have a Microsoft Excel file in a Microsoft OneDrive folder. The file must be imported to a Power BI semantic model. You need to ensure that the semantic model can be refreshed in 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.

You are using Microsoft Power BI Desktop to profile data in Power Query Editor. Table data is displayed 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 selection is worth one point. Before you can transform the date column to show only the day, you must To fix the error displayed for the data.Entries.menuAmount column, you must（含图）

You have a Power BI semantic model named Model1 that contains a table named Sales. Sales contains 10 million records and the following data. The related report displays the weekly sales per region. You need to minimize the size of Model1. How should you modify the CustomerID column and the PurchaseDateTime column? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.（含图）

You need to create a semantic model in Power BI Desktop. The solution must meet the following requirements: • The model must contain a table named Orders that has one row per order. Each row will contain the total amount per order. • The orders must be filtered to the selected CustomerID value. • Users must select the CustomerID value from a list. • The list of customers must come from an OData source. Which three objects should you create in Power Query Editor? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

You have a table named DIMCountries that contains a column named Country as shown in the following table. | Country | | ---- | | Afghanistan | | afghanistan | | Albania | | Algeria | | American Samoa | | Andorra | | andorra | | Antarctica | | Argentina | You plan to use DIMCountries as a dimension in a report. You need to ensure that the Country column in DIMCountries lists each country only once. Which two actions should you perform on the Country column? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.（含图）

HOTSPOT You use Power Query Editor to create a query named Products. Products return the results shown in the following table. You need to shape the data to display a single combination of ProductCategory and ProductID on each row. How should you configure the ProductIDList column? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.（含图）

HOTSPOT You plan to create a Power BI semantic model named Model1 that will contain data from an Azure SQL database. Model1 will have the following tables. You create DimDate and DimProduct by using import storage mode. You need to configure the storage mode for each remaining table. The solution must meet the following requirements: • The data in FactSales must be available within five minutes of being available in the source data. • The query response time for reports connected to the model must be minimized. Which storage mode should you configure for each table? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.（含图）

You have a Power BI query named Sales that imports the columns shown in the following table. Users only use the date part of the Sales_Date field. Only rows with a Status of Finished are used in analysis. You need to reduce the load times of the query without affecting the analysis. Which two actions achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.（含图）

You have a Power BI query named Sales that imports the columns shown in the following table. | Name | Description | Sample value | | ---- | ---- | ---- | | ID | A unique value that represents a sale | 10253 | | Sale_Date | Sales date<br>A column to extract the date of the sale | 2021-11-23T09:53:00 | | Customer_ID | Represents a unique customer ID number | 13158 | | Delivery_Time | Elapsed delivery time in hours<br>Can contain null values | 51.52 | | Status | Sales status<br>Contains only the following two values: Finished and Canceled | Finished | | Canceled_Date | Cancellation date and time<br>Can contain null values | 2021-11-24T14:11:23 | Users only use the date part of the Sales_Date field. Only rows with a Status of Finished are used in analysis. You need to reduce the load times of the query without affecting the analysis. Which two actions achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.（含图）

You have the Power BI model shown in the following exhibit. A manager can represent only a single country. You need to use row-level security (RLS) to meet the following requirements: The managers must only see the data of their respective country. The number of RLS roles must be minimized. Which two actions should you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.（含图）

You have the tables shown in the following table. The Impressions table contains approximately 30 million records per month. You need to create an ad analytics system to meet the following requirements: Present ad impression counts for the day, campaign, and site_name. The analytics for the last year are required. Minimize the data model size. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.（含图）（含图）

HOTSPOT - 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 one product 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 the answer area. NOTE: Each correct selection is worth one point.（含图）（含图）（含图）

DRAG DROP - You receive revenue data that must be included in Microsoft Power BI reports. You preview the data from a Microsoft Excel source in Power Query as shown in the following exhibit. You plan to create several visuals from the data, including a visual that shows revenue split by year and product. You need to transform the data to ensure that you can build the visuals. The solution must ensure that the columns are named appropriately for the data that they contain. 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 are creating a sales report in Power BI 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: | ID | ProductKey | OrderDate | ShipDate | CustomerKey | SalesTerritoryRegion | SalesOrderNumber | SalesOrderLineNumber | OrderQuantity | UnitPrice | SalesAmount | TaxAmount | Freight | |----|-----------|----------|---------|------------|---------------------|-----------------|---------------------|--------------|----------|------------|----------|--------| | 1 | 310 | 2010-12-29 | 2011-01-05 | 21768 | Canada | SO43697 | 1 | 1 | 3578.27 | 3578.27 | 286.2616 | 89.4568 | | 2 | 346 | 2010-12-29 | 2011-01-05 | 21768 | France | SO43698 | 1 | 1 | 3399.99 | 3399.99 | 271.9992 | 84.9998 | | 3 | 346 | 2010-12-29 | 2011-01-05 | 76537 | NorthWest | SO43699 | 1 | 1 | 3399.99 | 3399.99 | 271.9992 | 84.9998 | | 4 | 336 | 2010-12-29 | 2011-01-05 | 34256 | SouthWest | SO43700 | 1 | 1 | 699.0982 | 699.0982 | 55.9279 | 17.4775 | | 5 | 346 | 2010-12-29 | 2011-01-05 | 34253 | Australia | SO43701 | 1 | 1 | 3399.99 | 3399.99 | 271.9992 | 84.9998 | | 6 | 311 | 2010-12-30 | 2011-01-06 | 12543 | SouthWest | SO43702 | 1 | 1 | 3578.27 | 3578.27 | 286.2616 | 89.4568 | | 7 | 310 | 2010-12-30 | 2011-01-06 | 76545 | Australia | SO43703 | 1 | 1 | 3578.27 | 3578.27 | 286.2616 | 89.4568 | 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. A. Set the data type for SalesOrderNumber to Decimal Number. B. Remove the CustomerKey and ProductKey columns. C. Remove the TaxAmt and Freight columns. D. Filter the data to only the NorthWest region sales territory.（含图）

You have a Power BI report for the marketing department. The report reports on web traffic to a blog and contains data from the following tables. There is a one-to-many relationship from Posts to Traffic that uses the URL and URL Visited columns. The report contains the visuals shown in the following table. The dataset takes a long time to refresh. You need to modify Posts and Traffic queries to reduce load times. Which two actions will reduce the load times? NOTE: Each correct selection is worth one point.（含图）（含图）

You use Power BI Desktop to load data from a Microsoft SQL Server database. While waiting for the data to load, you receive the following error. ERROR [08001] timeout expired You need to resolve the error. What are two ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

You have a Power BI data model that analyzes product sales over time. The data model contains the following tables. A one-to-many relationship exists between the tables. The auto date/time option for the data model is enabled. You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.（含图）

To replace all the implicit DAX measures used in the visual, [answer choice] must be created. To change how the Product Cost field is aggregated in additional visuals, you must change the [answer choice].

1 6 7 8 9 10 11

更多题库