PL-300 Exam Questions

Your company has a security policy stating that proprietary data must not be transferred over the Internet. During a security audit, auditors discover that executives use the Power...

You have a Power BI Desktop project that uses DirectQuery to access an on-premises Microsoft SQL Server database. From Power BI Desktop, you can query the database. When you publis...

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different...

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different...

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different...

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different...

You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organization...

You plan to use Power BI Desktop optimized for Power BI Report Server to create a report. The report will be published to Power BI Report Server. You need to ensure that all the vi...

You plan to create a dashboard in the Power BI service that will retrieve data from a tabular database in Microsoft SQL Server Analysis Services (SSAS). The dashboard will be share...

You plan to use Power BI Desktop to create a report. The report will consume data from an on- premises tabular database named SalesDB in Microsoft SQL Server Analysis Services (SSA...

You plan to join a fact table named ActivityLog to a Date dimension named ActivityDate. The date value in ActivityLog is a datetime column named ActivityStart. The date value in Ac...

You have a table in Power BI Desktop as shown in the following exhibit. You pivot the columns as shown in the following exhibit. You need to resolve the error in row 3. The solutio...

You attempt to publish a Microsoft Excel file to Power BI, and you receive the error message shown in the exhibit. (Click the Exhibit button.) The file is in c:\data\. You need to...

You have two tables named Customer and Orders. A sample of the Data in Customer is shown in the following table. A sample of the data in Orders is shown in the following table. You...

You have a Power BI model for sales data. You create a measure to calculate the year-to-date sales. You need to compare the year-to-date sales with the previous year for the same t...

You have a Power BI Desktop project that has the model shown in the exhibit. (Click the Exhibit tab.) Customer Count is a measure that uses the CountRows function to calculate the...

You create a dashboard that displays the results of a customer satisfaction survey. You need to embed a tweet from your company's Twitter feed into the dashboard. What should you d...

You have a Power BI report that contains a visual. The visual contains a measure. You need to ensure that the report meets the following requirements: - All values must be set to t...

You have a Power BI dataset and a connected report. You need to ensure that users can analyze data in Microsoft Excel only by connecting directly to the dataset. You grant the user...

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some q...

You have the following table named Location. The GeoCode column represents the country where each customer is located. You create a map visualization as shown in the exhibit. (Clic...

Case Study 2 - Contoso Ltd Overview Existing Environment Contoso, Ltd. is a manufacturing company that produces outdoor equipment Contoso has quarterly board meetings for which fin...

Case Study 2 - Contoso Ltd Overview Existing Environment Contoso, Ltd. is a manufacturing company that produces outdoor equipment Contoso has quarterly board meetings for which fin...

Case Study 1 - Litware, Inc. Overview Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The company plans to leverage data from Microsoft SQL...

Case Study 1 - Litware, Inc. Overview Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The company plans to leverage data from Microsoft SQL...

You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date. You need to reduce the size of the data model. What should you do?

You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned. You...

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 f...

Your company has training videos that are published to Microsoft Stream. You need to surface the videos directly in a Microsoft Power BI dashboard. Which type of tile should you ad...

You open a query in Power Query Editor. You need to identify the percentage of empty values in each column as quickly as possible. Which Data Preview option should you select?

You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields: - First name - Last name - Email address - State/Region - Phone numbe...

You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns: Customer ID Customer Name Phone Email Address Address ID...

You have the following three versions of an Azure SQL database: - Test - Production - Development You have a dataset that uses the development database as a data source. You need t...

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each compliant occurred. The data in Logged is in the...

You 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. T...

You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date and Orders and between City and O...

You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product. The Sales table contains purchase and ship dates. Most often, you will use...

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some q...

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some q...

You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an on- premises Oracle database and an Azure SQL database by using one query. You have admin...

You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege. Which role should you assign to the user?

You create a dataset sourced from dozens of flat files in Azure Blob storage. The dataset uses incremental refresh. From powerbi.com, you deploy the dataset and several related rep...

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some q...

Your company has employees in 10 states. The company recently decided to associate each state to one of the following three regions: East, West, and North. You have a data model th...

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some q...

You need to create a visualization that compares revenue and cost over time. Which type of visualization should you use?

You are developing a sales report that will have multiple pages. Each page will answer a different business question. You plan to have a menu page that will show all the business q...

You use an R visual to produce a map of 500,000 customers. You include the values of CustomerID, Latitude, and Longitude in the fields sent to the visual. Each customer ID is uniqu...

You have a line chart that shows the number of employees in a department over time. You need to see the total salary costs of the employees when you hover over a data point. What s...

You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer segment. The column chart shows sales by month. You need to ensure th...