Microsoft PL-300 Power BI Data Analyst Exam Questions and Answers
-
You plan to create the Power BI model shown in the exhibit. (Click the Exhibit tab.)
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.
✑ 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.
✑ 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:
, Verified Answer
Customer should use the dual storage mode.
Dual: Tables with this setting can act as either cached or not cached, depending on the context of the query that's submitted to
the Power BI dataset. In some cases, you fulfill queries from cached data. In other cases, you fulfill queries by executing an on-
demand query to the data source.
Note: You set the Storage mode property to one of these three values: Import, DirectQuery, and Dual.
You can set the dimension tables (Customer, Geography, and Date) to Dual to reduce the number of limited relationships in the
dataset, and improve performance.
Box 3: DirectQuery-
, Sales should use the DirectQuery storage mode.
DirectQuery: Tables with this setting aren't cached. Queries that you submit to the Power BI dataset"for example, DAX
queries"and that return data from
DirectQuery tables can be fulfilled only by executing on-demand queries to the data source. Queries that you submit to the
data source use the query language for that data source, for example, SQL.
Box 4: Import -
Import: Imported tables with this setting are cached. Queries submitted to the Power BI dataset that return data from Import
tables can be fulfilled only from cached data.
The dual storage mode is between Import and DirectQuery. it is a hybrid approach, Like importing data, the dual storage mode
caches the data in the table. However, it leaves it up to Power BI to determine the best way to query the table depending on
the query context.
Sales Must be Refreshed in Near real time so "Direct Query"
Sales Aggregate is once per week so "Import" (performance also required)
Both Date and Customer has relationship with both Sales and SalesAggregate tables so "Dual"
because to support performance for DirectQuery(Sales) and Import(SalesAggregate)
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-storage-mode
Question: 2
You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps.
You need to create a Power BI report that connects to the project management app.
Which connector should you select?
Microsoft Teams Personal Analytics
SQL Server database
Dataverse
Answer: C Verified Answer
Data sources in Power BI Desktop.
The Power Platform category provides the following data connections:
Power BI datasets -
Power BI dataflows -
Dataverse -
Dataflows -
Other data sources include Microsoft Teams Personal Analytics (Beta).
You can use the Microsoft Power BI template to import data into Power BI from Project for the web and Project Online. When
you're using the template, you're connected to your Microsoft Dataverse instance, where your Microsoft Project web app data
is stored.
https://support.microsoft.com/en-us/office/use-power-bi-desktop-to-connect-with-your-project-data-df4ccca1 -68e9-418c-
9d0f-022ac05249a2
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-sources
Question:
For the sales department at your company, you publish a Power BI report that imports data from a Microsoft Excel file located in 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?
Power BI dataset
a SharePoint folder
-
You plan to create the Power BI model shown in the exhibit. (Click the Exhibit tab.)
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.
✑ 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.
✑ 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:
, Verified Answer
Customer should use the dual storage mode.
Dual: Tables with this setting can act as either cached or not cached, depending on the context of the query that's submitted to
the Power BI dataset. In some cases, you fulfill queries from cached data. In other cases, you fulfill queries by executing an on-
demand query to the data source.
Note: You set the Storage mode property to one of these three values: Import, DirectQuery, and Dual.
You can set the dimension tables (Customer, Geography, and Date) to Dual to reduce the number of limited relationships in the
dataset, and improve performance.
Box 3: DirectQuery-
, Sales should use the DirectQuery storage mode.
DirectQuery: Tables with this setting aren't cached. Queries that you submit to the Power BI dataset"for example, DAX
queries"and that return data from
DirectQuery tables can be fulfilled only by executing on-demand queries to the data source. Queries that you submit to the
data source use the query language for that data source, for example, SQL.
Box 4: Import -
Import: Imported tables with this setting are cached. Queries submitted to the Power BI dataset that return data from Import
tables can be fulfilled only from cached data.
The dual storage mode is between Import and DirectQuery. it is a hybrid approach, Like importing data, the dual storage mode
caches the data in the table. However, it leaves it up to Power BI to determine the best way to query the table depending on
the query context.
Sales Must be Refreshed in Near real time so "Direct Query"
Sales Aggregate is once per week so "Import" (performance also required)
Both Date and Customer has relationship with both Sales and SalesAggregate tables so "Dual"
because to support performance for DirectQuery(Sales) and Import(SalesAggregate)
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-storage-mode
Question: 2
You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps.
You need to create a Power BI report that connects to the project management app.
Which connector should you select?
Microsoft Teams Personal Analytics
SQL Server database
Dataverse
Answer: C Verified Answer
Data sources in Power BI Desktop.
The Power Platform category provides the following data connections:
Power BI datasets -
Power BI dataflows -
Dataverse -
Dataflows -
Other data sources include Microsoft Teams Personal Analytics (Beta).
You can use the Microsoft Power BI template to import data into Power BI from Project for the web and Project Online. When
you're using the template, you're connected to your Microsoft Dataverse instance, where your Microsoft Project web app data
is stored.
https://support.microsoft.com/en-us/office/use-power-bi-desktop-to-connect-with-your-project-data-df4ccca1 -68e9-418c-
9d0f-022ac05249a2
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-sources
Question:
For the sales department at your company, you publish a Power BI report that imports data from a Microsoft Excel file located in 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?
Power BI dataset
a SharePoint folder
