QUESTION: 9 Exam Topic: Question Set 1

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:

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

Reveal Solution Next Question

QUESTION: 10 Exam Topic: Question Set 1

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?

Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
Change the data type of the Logged column to Date.
Split the Logged column by using at as the delimiter.
Apply a transformation to extract the first 11 characters of the Logged column.

Answer(s): D

Explanation:

Extract the date, which is the first 11 characters.
CSV files have no data types.
Note: A CSV is a comma-separated values file, which allows data to be saved in a tabular format. CSVs look like a garden-variety spreadsheet but with a . csv extension. CSV files can be used with most any spreadsheet program, such as Microsoft Excel or Google Spreadsheets.

Reference:

https://www.bigcommerce.com/ecommerce-answers/what-csv-file-and-what-does-it-mean-my-ecommerce-business/

Reveal Solution Next Question

QUESTION: 11 Exam Topic: Question Set 1

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.

Excel Workbook
Text/CSV
Folder
SharePoint folder
Web

Answer(s): A,C

Explanation:

A: Connect to an Excel workbook from Power Query Desktop
To make the connection from Power Query Desktop:
1. Select the Excel option in the connector selection.
2. Browse for and select the Excel workbook you want to load. Then select Open.
3. Etc.
C: Folder connector capabilities supported

Folder path
Combine
Combine and load
Combine and transform
Connect to a folder from Power Query Online
To connect to a folder from Power Query Online:
1. Select the Folder option in the connector selection.
2. Enter the path to the folder you want to load.
Note:

Reference:

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

Reveal Solution Next Question

QUESTION: 12 Exam Topic: Question Set 1

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:

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/

Reveal Solution Next Question

Free PL-300 Exam Braindumps (page: 3)

QUESTION: 9 Exam Topic: Question Set 1

Explanation:

Reference:

QUESTION: 10 Exam Topic: Question Set 1

Explanation:

Reference:

QUESTION: 11 Exam Topic: Question Set 1

Explanation:

Reference:

QUESTION: 12 Exam Topic: Question Set 1

Explanation:

Reference: