Practice Free PL-300 Exam Online Questions
Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power BI.
You need to recommend an application lifecycle strategy. The solution must minimize access to production assets and prevent end users from viewing the development assets.
What should you recommend?
- A . Create production reports in a separate workspace that uses a shared dataset from the development
workspace. Grant the end users access to the production workspace. - B . Create one workspace for development. From the new workspace, publish an app for production.
- C . Create a workspace for development and a workspace for production. From the production workspace,
publish an app. - D . In one workspace, create separate copies of the assets and append DEV to the names of the copied assets. Grant the end users access to the workspace.
C
Explanation:
Use different work stages (Development, Test, and Production).
Deploy from the Development workspace.
Reference: https://visualbi.com/blogs/microsoft/powerbi/application-lifecycle-management-power-bi/
You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table.
You need to combine the tables into a single query that contains the unique columns of each table.
What should you select in Power Query Editor?
- A . Merge queries
- B . Append queries
- C . Combine files
You have a Power BI dashboard that displays different visualizations of company sales.
You enable Q&A on the dashboard.
You need to provide users with sample questions that they can ask when using Q&A.
Which settings should you modify from the Power BI Settings?
- A . Subscriptions
- B . Dashboards
- C . Datasets
- D . Workbooks
C
Explanation:
Reference: https://docs.microsoft.com/en-us/power-bi/service-q-and-a-create-featured-questions
You are creating a Power Bl report by using Power Bi Desktop.
You need to include a visual that shows trends and other useful information automatically. The visual must update based on selections in other visuals.
Which type of visual should you use?
- A . key influencers
- B . decomposition tree
- C . Q&A
- D . smart narrative
DRAG DROP
You are modifying a Power Bi model by using Power Bl Desktop.
You have a table named Sales that contains the following fields.
You have a table named Transaction Size that contains the following data.
You need to create a calculated column to classify each transaction as small, medium, or large based on the value in Sales Amount.
How should you complete the code? To answer, drag the appropriate values to the correct targets.
Each value 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.
Explanation:
FILTER | AND | CALCULATE
You have a Power 81 semantic model that contains a table named Table1. Table1 runs in Import storage mode. You need to update the model to change the storage mode of Table1 to DirectQuery.
What should you do?
- A . Delete Table1. and then add the table to the model again in DirectQuery storage mode.
- B . From Power Query Editor, duplicate the query for Table1.
- C . From Model view, change the storage mode of Table1 to DirectQuery
- D . Add an aggregation table to the model.
HOTSPOT
You plan to use Power Query Editor to get data from an API.
The API returns a JSON response.
You have a username and password tor the API.
Which data source and authentication method should you use to connect to the API? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
HOTSPOT
You plan to use Power Query Editor to get data from an API.
The API returns a JSON response.
You have a username and password tor the API.
Which data source and authentication method should you use to connect to the API? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You are building a Power Bl report.
Users will view the report by using their mobile device.
You need to configure the report to display data based on each user s location.
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A . For the relevant columns, set synonyms to match common geographical terms.
- B . From Power Query Editor, detect the data types of the relevant columns.
- C . Use the columns of the geography data type in all visuals.
- D . Create a hierarchy for columns of the geography data type.
- E . In Data Category, set the geographic data category for the relevant columns.
You have a Power BI workspace named BI Data that contains a dataset named BI Finance.
You have the Build permission for the 81 Finance dataset but you do NOT have permissions for the workspace,
You need to connect to BI Finance and create a report.
Which actions should you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
- A . From the Power BI service, create a dataflow to the dataset by using DirectQuery.
- B . From Power BI Desktop, connect to a Dataverse data source.
- C . From the Power BI service, create a new report and select a published dataset
- D . From Power Bl Desktop, connect to a shared dataset