Microsoft
Amazon
CompTIA
Salesforce
Cisco®
SAP
PMI
ISC
ISACA
VMware
HP
Palo Alto Networks
EC-Council
LPI
Google
Fortinet
All Vendors
  2. Home
  3. Exam List
  4. Microsoft
  5. PL-300

Microsoft Power BI Data Analyst
PL-300 Exam

HOTSPOT (Drag and Drop is not supported)
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:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: Dual
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.

Box 2: 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 datasetfor example, DAX queriesand 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.


Reference:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-storage-mode



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?

  1. Microsoft Teams Personal Analytics
  2. SQL Server database
  3. Dataverse
  4. Dataflows

Answer(s): C

Explanation:

Data sources in Power BI Desktop.
The Power Platform category provides the following data connections:
Power BI datasets
Power BI dataflows
Common Data Service (Legacy)
Dataverse
Dataflows
Other data sources include Microsoft Teams Personal Analytics (Beta).


Reference:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-sources



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?

  1. Power BI dataset
  2. a SharePoint folder
  3. Power BI dataflows
  4. an Excel workbook

Answer(s): B

Explanation:

Connect to a SharePoint folder from Power Query Desktop
To connect to a SharePoint folder:
1. From Get Data, select SharePoint folder.
2. Paste the SharePoint site URL you copied in Determine the site URL to the Site URL text box in the SharePoint folder dialog box. In this example, the site URL is https://contoso.sharepoint.com/marketing/data. If the site URL you enter is invalid, a warning icon. warning icon will appear next to the URL text box.

Select OK to continue.
3. If this is the first time you've visited this site address, select the appropriate authentication method. Enter your credentials and choose which level to apply these settings to. Then select Connect.
4. When you select the SharePoint folder you want to use, the file information about all of the files in that SharePoint folder are displayed. In addition, file information about any files in any subfolders is also displayed.

5. Etc.


Reference:

https://docs.microsoft.com/en-us/power-query/connectors/sharepointfolder



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
Address contains the following columns:
-Address ID
-Address Line 1
-Address Line 2
-City
-State/Region
-Country
-Postal Code
Each Customer ID represents a unique customer in the Customer table. Each Address ID represents a unique address in the Address table.
You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer.
What should you do?

  1. Merge the Customer and Address tables.
  2. Group the Customer and Address tables by the Address ID column.
  3. Transpose the Customer and Address tables.
  4. Append the Customer and Address tables.

Answer(s): A

Explanation:

A merge queries operation joins two existing tables together based on matching values from one or multiple columns. You can choose to use different types of joins, depending on the output you want.


Reference:

https://docs.microsoft.com/en-us/power-query/merge-queries-overview




Lin Tzu
QUESTION: 154 - answer (D) - Transit gateway is wrong, should be C & E. Below are the components of the site to site VPN: Customer Gateway: A customer gateway is a physical device or software application on your side of the Site-to-Site VPN connection. Virtual Private Gateway: A virtual private gateway is the VPN concentrator on the AWS side of the Site-to-Site VPN connection. You create a virtual private gateway and attach it to the VPC from which you want to create the Site-to-Site VPN connection.
- Anonymous
Upvote


saritha
I have passed the exam thankyou
- UNITED STATES
Upvote


Tzu Lin
What are the benefits of consolidated billing for AWS Cloud services? (Choose two.) Answer(s): C,E C) One bill for multiple accounts E) Custom cost and usage budget creation E seems incorrect, should be A = Volume discounts (Combined usage – You can combine the usage across all accounts in the organization to share the volume pricing discounts)
- UNITED STATES
Upvote


Niraj
Questions are valid. I just passed.
- India
Upvote


Sarah
Fantastic effort on the practice exam!
- UNITED STATES
Upvote


Marcus
Impressive work on this exam dumps. Love the free version.
- CANADA
Upvote


Emily
Great job on these practice exam questions! You guys are the best.
- CANADA
Upvote


seagal
I just passed (310-025) SCJP test yesterday. Your guide is right on the money and almost covers every question word for word. Great work !
- Edmonton
Upvote


Illya
I passed my exam today with a score of 964. This was a difficult test but the preparation guide was very good. I would not have passed without the materials. Thank you very much for giving me the opportunity to better my life.
- Alberta
Upvote


Jackson
Exam syo-101 Exam I passed my exam today with no problem whatsoever. I just wanted to say a sincere thank you for the outstanding study guide. You guys are a phenomenal help when it comes to study assistance. Thanks and definitely expect to see me again.
- MJ
Upvote

Read more ...