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

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?

  1. Viewer
  2. Admin
  3. Contributor
  4. Member

Answer(s): D

Explanation:

Member role allows adding members or other with lower permissions to the workspace.


Reference:

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-roles-new-workspaces



You have a Power BI query named Sales that imports the columns shown in the following table.

Users only use the date part of the Sales_Date field. Only rows with a Status of Finished are used in analysis.
You need to reduce the load times of the query without affecting the analysis.
Which two actions achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

  1. Remove the rows in which Sales[Status] has a value of Canceled.
  2. Remove Sales[Sales_Date].
  3. Change the data type of Sale[Delivery_Time] to Integer.
  4. Split Sales[Sale_Date] into separate date and time columns.
  5. Remove Sales[Canceled Date].

Answer(s): A,D

Explanation:

A: Removing uninteresting rows will increase query performance.
D: Splitting the Sales_Date column will make comparisons on the Sales date faster.



You build a report to analyze customer transactions from a database that contains the tables shown in the following table.

You import the tables.
Which relationship should you use to link the tables?

  1. one-to-many from Transaction to Customer
  2. one-to-one between Customer and Transaction
  3. many-to-many between Customer and Transaction
  4. one-to-many from Customer to Transaction

Answer(s): D

Explanation:

One on the primary Key side (customer table), many on the foreign key side (Transaction table) of the relation.



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 build a report analyzing the internal networks of employees based on whom they send emails to.
You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.
What should you do?

  1. From Model view, set the Subject and Body columns to Hidden.
  2. Remove the Subject and Body columns during the import.
  3. Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.

Answer(s): B

Explanation:

The Subject and the Body are not needed in the report. Dropping them resolves the security problem and minimizes the model.




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


CJ
Exam 1Z0-040: 1Z0-040 passed!!! I have passed my exam 59/60. You people are the boom. Thanks for the exam questions. They were so real!!
- UNITED STATES
Upvote


Oshrit
Dear Support, I passed (as you expected) the Sun Solaris Admin I (310-011) at first trial. Thank you so much.
- Israel
Upvote


Lee W.
Just thought I would let you know I took the CCDA test on Tuesday, like I planned and scored a 902!"
- China
Upvote


Micheal C.
I have used your Exams for preparation for 70-290, 70-291, 70-292, 70-296, 70-298, 70- 299, 70-300, 70-305, 70-310, 70-315, 70-316,70-320. I also passed all those on the first round. I'm currently preparing for the CCNA.
- ON
Upvote

Read more ...