CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. PL-300

Free PL-300 Exam Braindumps (page: 4)

Page 3 of 85
PDF with 356 Questions

DRAG DROP (Drag and Drop is not supported)
You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2.
Sheet1 contains the following table named Table1.
Sheet2 contains the following table named Table2.
You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:




  1. See Explanation section for answer.

Answer(s): A

Explanation:


Reference:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data



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 a transformation to extract the first 11 characters of the Logged column.

Answer(s): C



You have a Microsoft Excel file in a Microsoft OneDrive folder.
The file must be imported to a Power BI dataset.
You need to ensure that the dataset can be refreshed in powerbi.com.
Which two connectors can you use to connect to the file? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

  1. Excel Workbook
  2. Text/CSV
  3. Folder
  4. SharePoint folder
  5. Web

Answer(s): D,E



HOTSPOT (Drag and Drop is not supported)
You are profiling data by using Power Query Editor.
You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data in State is shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:


  1. See Explanation section for answer.

Answer(s): A

Explanation:


Box 1: 69
69 distinct/different values.
Note: Column Distribution allows you to get a sense for the overall distribution of values within a column in your data previews, including the count of distinct values (total number of different values found in a given column) and unique values (total number of values that only appear once in a given column).
Box 2: 4


Reference:

https://systemmanagement.ro/2018/10/16/power-bi-data-profiling-distinct-vs-unique/






Post your Comments and Discuss Microsoft PL-300 exam with other Community members:

PL-300 Exam Discussions & Posts