PL-300: MICROSOFT LATEST
POWER BI DATA
ANALYST EXAM
You plan to get data from flat files for a Power BI dataset.
You need to select a location to store the files.
Which location requires an on-premises data gateway?
Shared folder on a local network.
You need to make changes to your data sources.
Which three changes are supported by the Data Source Settings in
the Power Query interface? Each correct answer presents a
complete solution.
1. Adding a column
2. Clearing permissions
3. Editing permissions
4. Modifying the file path
5. Renaming a column
2. Clearing permissions
3. Editing permissions
4. Modifying the file path
You have a Power BI dataset that gets data from a table in a SQL
Server database.
From which view in Power BI Desktop can you modify the storage
mode of the table?
1. Data view
2. Model view
END OF
PAGE
1
, PL-300: MICROSOFT LATEST
POWER BI DATA
ANALYST EXAM
3. Page view
4. Report view
2. Model view
You plan to add data to Power BI Desktop from a new data source.
You are evaluating whether you should use the DirectQuery storage
mode or the Import storage mode.
What are two benefits of using DirectQuery instead of Import?
Each correct answer presents a complete solution.
1. Full support for the Q&A Power BI service
2. Full support for the Quick Insights Power BI service
3. Minimized local disk space usage
4. Minimized need for data refresh
3. Minimized local disk space usage
4. Minimized need for data refresh
You plan to publish a dataset from Power BI Desktop.
You need to ensure that a server name can be changed after the
dataset has been published to the Power BI Service.
Which two actions should you perform? Each correct answer
presents part of the solution.
1. Create a parameter
2. Creat a query for the server name
3. From the Data source settings in Power BI Desktop, update the
permissions.
END OF
PAGE
2
, PL-300: MICROSOFT LATEST
POWER BI DATA
ANALYST EXAM
4. From the Data source settings, update the server source to use a
parameter.
5. Update the Source applied step of all related queries to reference
the server name query.
1. Create a parameter
3. From the Data source settings in Power BI Desktop, update the
permissions.
You create a Power BI data source which uses a SQL SELECT
statement. The SQL statement queries multiple tables in a SQL
Server database and includes subqueries.
When importing data from the data source into Power BI, you
receive the following error message: "Timeout expired."
You verify that network connection to the SQL Server has sufficient
available bandwidth and low latency.
You need to minimize the occurrences of the timeout issues
indicated by the message.
What should you do?
1. Divide the SQL statement into separate data sources.
2. Implement aggregations in the SQL statement.
3. Implement groupings in the SQL statement.
4. Replace subqueries with nested queries.
1. Divide the SQL statement into separate data sources.
END OF
PAGE
3
, PL-300: MICROSOFT LATEST
POWER BI DATA
ANALYST EXAM
Dividing the SQL statement into separate data sources would minimize
the amount of processing on the SQL Server side. This would minimize
or even eliminate the timeout issues. Groupings, aggregations, and using
nested queries would either have no impact on timeout issues or further
increase the amount of processing on the SQL Server side, resulting in
more frequent timeout issues.
From Power BI Desktop, you create a data source by importing an
Excel file that contains 10,000 rows.
You plan to identify data anomalies within the data source.
You need to ensure that column distribution considers all rows in
the Excel file.
What should you do?
1. In the Data Source Settings, modify the Advanced settings.
2. In the Data Source Settings, modify the Edit Permissions settings.
3. In the Power Query Editor window, enable the Column Profile
view.
4. In the Power Query Editor window, modify the Query Settings.
3. In the Power Query Editor window, enable the Column Profile view.
By default, Power BI uses the top 1,000 rows for profiling. To ensure
that column distribution considers all rows in the Excel file, you need to
modify the Power Query Editor profiling status setting. The Power
Query Editor settings, Advanced settings, and Permissions settings have
END OF
PAGE
4
POWER BI DATA
ANALYST EXAM
You plan to get data from flat files for a Power BI dataset.
You need to select a location to store the files.
Which location requires an on-premises data gateway?
Shared folder on a local network.
You need to make changes to your data sources.
Which three changes are supported by the Data Source Settings in
the Power Query interface? Each correct answer presents a
complete solution.
1. Adding a column
2. Clearing permissions
3. Editing permissions
4. Modifying the file path
5. Renaming a column
2. Clearing permissions
3. Editing permissions
4. Modifying the file path
You have a Power BI dataset that gets data from a table in a SQL
Server database.
From which view in Power BI Desktop can you modify the storage
mode of the table?
1. Data view
2. Model view
END OF
PAGE
1
, PL-300: MICROSOFT LATEST
POWER BI DATA
ANALYST EXAM
3. Page view
4. Report view
2. Model view
You plan to add data to Power BI Desktop from a new data source.
You are evaluating whether you should use the DirectQuery storage
mode or the Import storage mode.
What are two benefits of using DirectQuery instead of Import?
Each correct answer presents a complete solution.
1. Full support for the Q&A Power BI service
2. Full support for the Quick Insights Power BI service
3. Minimized local disk space usage
4. Minimized need for data refresh
3. Minimized local disk space usage
4. Minimized need for data refresh
You plan to publish a dataset from Power BI Desktop.
You need to ensure that a server name can be changed after the
dataset has been published to the Power BI Service.
Which two actions should you perform? Each correct answer
presents part of the solution.
1. Create a parameter
2. Creat a query for the server name
3. From the Data source settings in Power BI Desktop, update the
permissions.
END OF
PAGE
2
, PL-300: MICROSOFT LATEST
POWER BI DATA
ANALYST EXAM
4. From the Data source settings, update the server source to use a
parameter.
5. Update the Source applied step of all related queries to reference
the server name query.
1. Create a parameter
3. From the Data source settings in Power BI Desktop, update the
permissions.
You create a Power BI data source which uses a SQL SELECT
statement. The SQL statement queries multiple tables in a SQL
Server database and includes subqueries.
When importing data from the data source into Power BI, you
receive the following error message: "Timeout expired."
You verify that network connection to the SQL Server has sufficient
available bandwidth and low latency.
You need to minimize the occurrences of the timeout issues
indicated by the message.
What should you do?
1. Divide the SQL statement into separate data sources.
2. Implement aggregations in the SQL statement.
3. Implement groupings in the SQL statement.
4. Replace subqueries with nested queries.
1. Divide the SQL statement into separate data sources.
END OF
PAGE
3
, PL-300: MICROSOFT LATEST
POWER BI DATA
ANALYST EXAM
Dividing the SQL statement into separate data sources would minimize
the amount of processing on the SQL Server side. This would minimize
or even eliminate the timeout issues. Groupings, aggregations, and using
nested queries would either have no impact on timeout issues or further
increase the amount of processing on the SQL Server side, resulting in
more frequent timeout issues.
From Power BI Desktop, you create a data source by importing an
Excel file that contains 10,000 rows.
You plan to identify data anomalies within the data source.
You need to ensure that column distribution considers all rows in
the Excel file.
What should you do?
1. In the Data Source Settings, modify the Advanced settings.
2. In the Data Source Settings, modify the Edit Permissions settings.
3. In the Power Query Editor window, enable the Column Profile
view.
4. In the Power Query Editor window, modify the Query Settings.
3. In the Power Query Editor window, enable the Column Profile view.
By default, Power BI uses the top 1,000 rows for profiling. To ensure
that column distribution considers all rows in the Excel file, you need to
modify the Power Query Editor profiling status setting. The Power
Query Editor settings, Advanced settings, and Permissions settings have
END OF
PAGE
4
