PL300-Quiz16

Category: None

PL300-Q526

From Power Query Editor, you attempt to execute a query and receive the following error message.

Datasource. Error: Could not find file.

What are two possible causes of the error? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

You do not have permissions to the file.

An incorrect privacy level was used for the data source.

The file is locked.

The referenced file was moved to a new location.

Category: None

PL300-Q527

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.

Remove the rows in which Sales[Status] has a value of Canceled.

Remove Sales[Sales_Date].

Change the data type of Sale[Delivery_Time] to Integer.

Split Sales[Sale_Date] into separate date and time columns.

Remove Sales[Canceled Date].

Category: None

PL300-Q528

Which two actions should you perform? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function.

Create a single role that filters Country[Manager_Email] by using the USEROBJECTID DAX function.

For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.

Create one role for each country.

For the relationship between Purchase and Purchase Detail, change the Cross filter direction to Single.

Category: None

PL300-Q529

Name	Used field	Filter
Top 10 blog posts of all time	Posts[Title] Traffic[DateTime]	None
Top 10 blog posts from the last seven days	Posts[Title] Traffic[DateTime]	Traffic[DateTime] is in the last 7 days
Blog visits over time	Traffic[DateTime] Traffic[URL Visited]	Traffic[URL Visited] contains “blog”
Top 10 external referrals to the blog of all time	Traffic[Referring URL]	Traffic[URL Visited] contains “blog” AND Traffic[Referring URL] does not start with “/”

The dataset takes a long time to refresh.

You need to modify Posts and Traffic queries to reduce load times.

Which two actions will reduce the load times? Each correct answer presents part of the solution.

NOTE:

Each correct selection is worth one point.

Remove the rows in Posts in which Posts[Publish Date] is in the last seven days.

Remove the rows in Traffic in which Traffic[URL Visited] does not contain €ablog.€a

Remove Traffic[IP Address], Traffic[Browser Agent], and Traffic[Referring URL].

Remove Posts[Full Text] and Posts[Summary].

Remove the rows in Traffic in which Traffic[Referring URL] does not start with .€a/€a

Remove the rows in Traffic in which Traffic[Referring URL] does not start with .€a/€a

詢問 ChatGPT

Category: None

PL300-Q530

You have a Power BI data model that imports data from a Microsoft Excel spreadsheet.

You use Power Query to load a query that contains both renamed and custom columns.

Later, you attempt to reload the query and receive the following error message.

Expression.Error: The column ‘Category’ of the table wasn’t found.

What are two possible causes of the error? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

The column was removed from the source file.

The column was renamed in the source file.

The file is no longer in the specified location.

The data type of the column was changed.

Category: None

PL300-Q531

Name	Data type
Sale date	Date
Product ID	Whole number
Product name	Text
Product category	Text
Customer ID	Whole number

In Power Query Editor, you have a query named Sales Data that contains

You need to create two queries named Product Dimension and

Sales Fact based on the Sales Data query. The solution must

minimize maintenance effort and the size of the dataset.

Which two actions should you perform? Each correct answer

presents part of the solution.

NOTE: Each correct selection is worth one point.

<span><span>Reference the Sales Data query to create the new queries.</span></span>

Disable the load for the Sales Fact query.

Duplicate the Sales Data query to create the new queries.

Clear Include in report refresh for the Sales Data query.

Disable the load for the Sales Data query.

Category: None

PL300-Q532

You use Power Query Editor to import and preview sales data from the years 2020 and 2021 in a Microsoft Excel file as shown in the following exhibit.

You need to shape the query to display the following three columns:

Month
Sales
Year

What should you select in Power Query Editor?

Merge columns

Transpose

Unpivot columns

Category: None

PL300-Q533

A user creates a Power BI report named ReportA that uses a custom theme.

You create a dashboard named DashboardA.

You need to ensure that DashboardA uses the custom theme. The solution must minimize development effort.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Publish ReportA to Power BI.

From ReportA save the current theme.

Publish ReportA to the Microsoft Power BI Community theme gallery.

From DashboardA, create a custom theme.

From DashboardA, upload a JSON theme.

Category: None

PL300-Q534

You are building a Power BI report.
Users will view the report by using their mobile device.
You need to configure the report to display data based on each user’s location.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

From Power Query Editor, detect the data types of the relevant columns.

In Data Category, set the geographic data category for the relevant columns.

Create a hierarchy for columns of the geography data type.

Use the columns of the geography data type in all visuals.

For the relevant columns, set synonyms to match common geographical terms.

Category: None

PL300-Q535

You have two Power BI reports named ReportA and ReportB that each uses a distinct color palette.

You are creating a Power BI dashboard that will include two visuals from each report.

You need to use a consistent dark theme for the dashboard. The solution must preserve the original colors of the reports.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Upload a snapshot.

For the browser, set the color preference to dark mode.

When pinning visuals to the dashboard, select Use destination theme.

Select the dark dashboard theme.

Turn on tile flow.

Category: None

PL300-Q536

You have a Power B1 report named ReportA.

You have a Power B1 tenant that allows users to export data.

You need to ensure that consumers of ReportA cannot effort any data from visuals.

Which two actions should you perform? Each correct answer presents a complete solution.

NOTE Each correct selection is worth one point.

From Power B1 Desktop, modify the Data Load settings

From the answer B1 service modify the Report settings.

From Power B1 Desktop modify the Report settings

From the Power B1 service, modify the dataset permissions.

Category: None

PL300-Q537

You have a Microsoft Power BI dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exhibit. (Click the Exhibit tab.)

A user pressed F5

A new transaction was added to the data source.

A user added a comment to a tile.

The dashboard tile cache refreshed.

Category: None

PL300-Q538

You create the following step by using Power Query Editor.

= Table.ReplaceValue(SalesLT_Address,’1318″,’1319″,Replacer.ReplaceText,{“AddressLine1”})

A row has a value of 21318 Lasalle Street in the AddressLine1 column. What will the value be when the step is

applied?

1318

1319

21318 Lasalle Street

21319 Lasalle Street

Category: None

PL300-Q539

In most cases, data is aggregated by ____ in Power Bl.

city

address

date

email

PL300-Q540

Power BI desktop has a _____ tool, found under the View tab, which can be used to record the time taken for each of the processes required to render a report to complete.

Simulation

Performance Analyzer

Reporting Analytics

DAX Studio

PL300-Q611

Solution:

Box1:Table.RemoveColumns

When you do”Remove Columns”Power Query

uses the Table.RemoveColumns function Box 2:

List.Select

Get a list of columns.

Box 3:Text.EndsWith

Does this meet the goal?

Yes

No

PL300-Q612

You need tocreate a solution to meet the notification requirements of thewarehouse shipping department.What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct select is worth one point:

Does this meet the goal?

Yes

No

PL300-Q613

You need to create a relationship in the dataset for RLS.

What should you do? To answer select the appropriate options in the answer area.

NOTE:Each correct selection is worth one point.

Does this meet the goal?

Yes

No

PL300-Q614

You have the line chart shown in the exhibit. (Click the Exhibit tab.)

You need to modify the chart to meet the following requirements:

Identify months that have order counts above the mean.

Display the mean monthly order count.

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.

Solution:

*1. Select the line chart

*2. Add the average line

*3. Turn on Data Label

Does this meet the goal?

Yes

No

PL300-Q615

Does this meet the goal?

Yes

No

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question

7. Question

8. Question

9. Question

10. Question

11. Question

12. Question

13. Question

14. Question

15. Question

16. Question

17. Question

18. Question

19. Question

20. Question