QUESTION: 13 Exam Topic: Question Set 1

HOTSPOT (Drag and Drop is not supported)
You have two CSV files named Products and Categories.
The Products file contains the following columns:
-ProductID
-ProductName
-SupplierID
-CategoryID

The Categories file contains the following columns:
-CategoryID
-CategoryName
-CategoryDescription

From Power BI Desktop, you import the files into Power Query Editor.
You need to create a Power BI dataset that will contain a single table named Product. The Product will table includes the following columns:
-ProductID
-ProductName
-SupplierID
-CategoryID
-CategoryName
-CategoryDescription

How should you combine the queries, and what should you do on the Categories query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

See Explanation section for answer.

Answer(s): A

Explanation:

Box 1: Merge
There are two primary ways of combining queries: merging and appending.
* When you have one or more columns that you'd like to add to another query, you merge the queries.
* When you have additional rows of data that you'd like to add to an existing query, you append the query.

Box 2: Disable the query load

Managing loading of queries
In many situations, it makes sense to break down your data transformations in multiple queries. One popular example is merging where you merge two queries into one to essentially do a join. In this type of situations, some queries are not relevant to load into Desktop as they are intermediate steps, while they are still required for your data transformations to work correctly. For these queries, you can make sure they are not loaded in Desktop by un-checking 'Enable load' in the context menu of the query in Desktop or in the Properties screen:

Reference:

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

Reveal Solution Next Question

QUESTION: 14 Exam Topic: Question Set 1

You have an Azure SQL database that contains sales transactions. The database is updated frequently.
You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.
How should you configure the data connection?

Add a SQL statement.
Set the Command timeout in minutes setting.
Set Data Connectivity mode to Import.
Set Data Connectivity mode to DirectQuery.

Answer(s): D

Explanation:

DirectQuery: No data is imported or copied into Power BI Desktop. For relational sources, the selected tables and columns appear in the Fields list. For multi- dimensional sources like SAP Business Warehouse, the dimensions and measures of the selected cube appear in the Fields list. As you create or interact with a visualization, Power BI Desktop queries the underlying data source, so you're always viewing current data.

Reference:

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

Reveal Solution Next Question

QUESTION: 15 Exam Topic: Question Set 1

DRAG DROP (Drag and Drop is not supported)
You have a folder that contains 100 CSV files.
You need to make the file metadata available as a single dataset by using Power BI. The solution must NOT store the data of the CSV files.
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:

Step 1: From Power BI Desktop, Select Get Data, and then Select Folder.
Open Power BI Desktop and then select Get Data\Moreג€¦ and choose Folder from the All options on the left.

Enter the folder path, select OK, and then select Transform data to see the folder's files in Power Query Editor.
Step 2: From Power Query Editor, expand the Attributes column.
Step 3: From Power Query Editor, combine the Content column.

Combine files behavior
To combine binary files in Power Query Editor, select Content (the first column label) and select Home > Combine Files. Or you can just select the Combine Files icon next to Content.

Reference:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-combine-binaries

Reveal Solution Next Question

QUESTION: 16 Exam Topic: Question Set 1

A business intelligence (BI) developer creates a dataflow in Power BI that uses DirectQuery to access tables from an on-premises Microsoft SQL server. The Enhanced Dataflows Compute Engine is turned on for the dataflow.

You need to use the dataflow in a report. The solution must meet the following requirements:
-Minimize online processing operations.
-Minimize calculation times and render times for visuals.
-Include data from the current year, up to and including the previous day.

What should you do?

Create a dataflows connection that has DirectQuery mode selected.
Create a dataflows connection that has DirectQuery mode selected and configure a gateway connection for the dataset.
Create a dataflows connection that has Import mode selected and schedule a daily refresh.
Create a dataflows connection that has Import mode selected and create a Microsoft Power Automate solution to refresh the data hourly.

Answer(s): C

Explanation:

A daily update is adequate.
When you set up a refresh schedule, Power BI connects directly to the data sources using connection information and credentials in the dataset to query for updated data, then loads the updated data into the dataset. Any visualizations in reports and dashboards based on that dataset in the Power BI service are also updated.

Reference:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-local-drive

Reveal Solution Next Question

Free PL-300 Exam Braindumps (page: 4)

QUESTION: 13 Exam Topic: Question Set 1

Explanation:

Reference:

QUESTION: 14 Exam Topic: Question Set 1

Explanation:

Reference:

QUESTION: 15 Exam Topic: Question Set 1

Explanation:

Reference:

QUESTION: 16 Exam Topic: Question Set 1

Explanation:

Reference: