PL-300英文版_在线真题试卷与模拟练习_PL-300英文版

Question #1-1HOTSPOT -You plan to create the Power BI model shown in the exhibit. (Click the Exhibit tab.)

（含图）The data has the following refresh requirements: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.A SalesAggregate must be refreshed once per week.You need to select the storage modes for the tables. The solution must meet the following requirements:& Minimize the load times of visuals.M 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、Customer:

Question #1-2HOTSPOT -You plan to create the Power BI model shown in the exhibit. (Click the Exhibit tab.)

（含图）The data has the following refresh requirements: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.A SalesAggregate must be refreshed once per week.You need to select the storage modes for the tables. The solution must meet the following requirements:& Minimize the load times of visuals.M 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:

（含图）2、Date:

Question #1-3HOTSPOT -You plan to create the Power BI model shown in the exhibit. (Click the Exhibit tab.)

（含图）The data has the following refresh requirements: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.A SalesAggregate must be refreshed once per week.You need to select the storage modes for the tables. The solution must meet the following requirements:& Minimize the load times of visuals.M 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:

（含图）3、Sales:

Question #1-4HOTSPOT -You plan to create the Power BI model shown in the exhibit. (Click the Exhibit tab.)

（含图）The data has the following refresh requirements: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.A SalesAggregate must be refreshed once per week.You need to select the storage modes for the tables. The solution must meet the following requirements:& Minimize the load times of visuals.M 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:

（含图）

4、SalesAggregate:

Question #2You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft PowerApps.You need to create a Power BI report that connects to the project management app.Which connector should you select?

Question #3For the sales department at your company, you publish a Power BI report that imports data from a Microsoft Excel file locatedin a Microsoft SharePoint folder.The data model contains several measures.You need to create a Power BI report from the existing data. The solution must minimize development effort.Which type of data source should you use?

Question #4You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the followingcolumns:Customer IDCustomer NamePhoneEmail AddressAddress IDAddress contains the following columns:Address IDAddress Line 1Address Line 2CityState/RegionCountryPostal CodeEach Customer ID represents a unique customer in the Customer table. Each Address ID represents a unique address in theAddress table.You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for eachcustomer.What should you do?

Question #5-1HOTSPOT -You have two Azure SQL databases that contain the same tables and columns.For each database, you create a query that retrieves data from a table named Customer.You need to combine the Customer tables into a single table. The solution must minimize the size of the data model andsupport scheduled refresh in powerbi.com.What should you do? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:（含图）

1、Option to use to combine the Customer tables:

Question #5-2HOTSPOT -You have two Azure SQL databases that contain the same tables and columns.For each database, you create a query that retrieves data from a table named Customer.You need to combine the Customer tables into a single table. The solution must minimize the size of the data model andsupport scheduled refresh in powerbi.com.What should you do? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:（含图）

2、Action to perform on the original two SQL database queries:

Question #7You are building a Power BI report that uses data from an Azure SQL database named erp1.You import the following tables.

（含图）

You need to perform the following analyses:Orders sold over time that include a measure of the total order valueOrders by attributes of products soldThe solution must minimize update times when interacting with visuals in the report.What should you do first?

Question #8You have a Microsoft SharePoint Online site that contains several document libraries.One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reportshave the same data structure.You need to use Power BI Desktop to load only the manufacturing reports to a table for analysis.What should you do?

Question #10You 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 #12-1HOTSPOT -You are profiling data by using Power Query Editor.You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data inState is shown in the following exhibit.

（含图）

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:

（含图）

1、There are [answer choice] different values in State including nulls：

Question #12-2HOTSPOT -You are profiling data by using Power Query Editor.You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data inState is shown in the following exhibit.

（含图）

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、There are [answer choice] non - null values that occur only once in State:

Question #13-1HOTSPOT -You have two CSV files named Products and Categories.The Products file contains the following columns:ProductIDProductNameSupplierIDCategoryIDThe Categories file contains the following columns:CategoryIDCategoryNameCategoryDescriptionFrom Power BI Desktop, you import the files into Power Query Editor.You need to create a Power BI dataset that will contain a single table named Product. The Product will table includes thefollowing columns:ProductIDProductNameSupplierIDCategoryIDCategoryNameCategoryDescriptionHow should you combine the queries, and what should you do on the Categories query? To answer, select the appropriateoptions in the answer area.NOTE: Each correct selection is worth one point.Hot Area:

（含图）

Combine the queries by performing a:

Question #13-2HOTSPOT -You have two CSV files named Products and Categories.The Products file contains the following columns:ProductIDProductNameSupplierIDCategoryIDThe Categories file contains the following columns:CategoryIDCategoryNameCategoryDescriptionFrom Power BI Desktop, you import the files into Power Query Editor.You need to create a Power BI dataset that will contain a single table named Product. The Product will table includes thefollowing columns:ProductIDProductNameSupplierIDCategoryIDCategoryNameCategoryDescriptionHow should you combine the queries, and what should you do on the Categories query? To answer, select the appropriateoptions in the answer area.NOTE: Each correct selection is worth one point.Hot Area:

（含图）

On the Categories query:

Question #14You have an Azure SQL database that contains sales transactions. The database is updated frequently.You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes ofan update.How should you configure the data connection?

Question #16A business intelligence (BI) developer creates a dataflow in Power BI that uses DirectQuery to access tables from an onpremises Microsoft SQL server. 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?

Question #18You attempt to connect Power BI Desktop to a Cassandra database.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?

Question #20-1HOTSPOT-You are using Power BI Desktop to connect to an Azure SQL database.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 inthe graphic.NOTE: Each correct solution is worth one point.

（含图）

1、The default timeout for the connection from.Power BI Desktop to the database will be: