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 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?

  1. Merge queries
  2. Combine files
  3. Append queries

Answer(s): A



You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.

You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.
What should you do?

  1. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
  2. Change the data type of the Logged column to Date.
  3. Split the Logged column by using at as the delimiter.
  4. Apply the Parse function from the Date transformations options to the Logged column.

Answer(s): C



You are creating a report in Power BI Desktop.
You load a data extract that includes a free text field named coll.
You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model.
What should you do?

  1. In the report, add a DAX calculated column that calculates the length of col1
  2. In the report, add a DAX function that calculates the average length of col1
  3. From Power Query Editor, add a column that calculates the length of col1
  4. From Power Query Editor, change the distribution for the Column profile to group by length for col1

Answer(s): A

Explanation:

The LEN DAX function returns the number of characters in a text string.
Note: DAX is a collection of Power BI functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values.
Stated more simply, DAX helps you create new information from data already in your model.


Reference:

https://docs.microsoft.com/en-us/dax/len-function-dax
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quickstart-learn-dax-basics



You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions.
Each sales region has an HR manager.
You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports.
How should you provision access to the reports for the HR managers?

  1. Publish the reports in an app and grant the HR managers access permission.
  2. Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.
  3. Publish the reports to a different workspace other than the one hosting the datasets.
  4. Add the HR managers as members of the existing workspace that hosts the reports and the datasets.

Answer(s): A


Reference:

https://kunaltripathy.com/2021/10/06/bring-your-power-bi-to-power-apps-portal-part-ii/




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


kris J.
Now my dream has come true. I thank you a million times for the best study guides that you provided to a poor kid like me....I got it. Finally MCSE. Best regards,
- GERMANY
Upvote


Jason
I passed my CCNA exam yesterday. I would like to make some comments. "Excellent Study Guide, Excellent Support Service, Excellent Examination Web Site" Best Regards
- UNITED STATES
Upvote


Micheal
Thanks for your study guides, i have passed it. All questions in your material, we study this only 2 days. Thanks very very much!!!!!
- UNITED STATES
Upvote


L. Woo
Thanks very much for your study guides, with your help i only use 3 weeks to take the MCSE. Your study guides are very very good.
- China
Upvote


Mick H.
I passed the CCIE Written exam 350-001 last Friday, Thanks very much for your study guide and your help.
- UNITED STATES
Upvote


Hagit
i ust wanted to thank you folks at braindumgalaxy.com for your assistance. I used your CCNP exams for practice and to identify my weak areas. Passed the CCNP recert on Tuesday without any big problems.
- Israel
Upvote


Cisco Engineer
I have found that your resources are probably the best on the market...and I work at Cisco.
- UNITED STATES
Upvote


Koshani
A well Good morning Dear braindumpgalaxy.com Team I wanna say that I passed the 000-888 yesterday and i am happy
- UNITED STATES
Upvote


Aized
I took the A+ hardware exam yesterday and thanks to your excellent and helping preparation material. I got a nice score.
- Pakistan
Upvote

Read more ...