ExamGecko
Login
Home / Microsoft / PL-300 / List of questions
Ask Question

Microsoft PL-300 Practice Test - Questions Answers, Page 12

List of questions

Question 111

Report
Export
Collapse

You need to design the data model to meet the report requirements. What should you do m Power Bl Desktop?

From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.

From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.

From Power Bi Desktop, use the Auto date/time option when creating the reports.

From Power Bi Desktop, use the Auto date/time option when creating the reports.

From Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.

From Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.

From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column

From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column
Suggested answer: B
asked 05/10/2024
Gaston Cruz
37 questions

Question 112

Report
Export
Collapse

You need to create the Top Customers report.

Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area. NOTE; Each correct selection is worth one point.

Microsoft PL-300 image Question 79 106336 10052024010716000000







Suggested answer:

Explanation:

.

Answer as below

Microsoft PL-300 image Question 79 explanation 106336 10052024010716000000

asked 05/10/2024
ERIC LUM
40 questions

Question 113

Report
Export
Collapse

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.

Microsoft PL-300 image Question 80 106337 10052024010716000000







Suggested answer:

Explanation:

.

Answer as below

Microsoft PL-300 image Question 80 explanation 106337 10052024010716000000

asked 05/10/2024
Ida Aasvistad
35 questions

Question 114

Report
Export
Collapse

You need to create a measure that will return the percentage of late orders.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Microsoft PL-300 image Question 81 106338 10052024010716000000







Suggested answer:

Explanation:

.

Answer as below

Microsoft PL-300 image Question 81 explanation 106338 10052024010716000000

asked 05/10/2024
sicnarep sicnarep
44 questions

Question 115

Report
Export
Collapse

ion have a Power BI dataset that contains a table named Temperature Readings. Temperature Readings contains the columns shown in the following table.

Microsoft PL-300 image Question 82 106339 10052024010716000000

The table has 12 million rows. All the columns are needed for analysis.

You need to optimize the dataset to decrease the model size. The solution must not affect the precision of the data. What should you do?

Split the DateTime column into separate date and time columns.

Split the DateTime column into separate date and time columns.

Disable the Power Query load.

Disable the Power Query load.

Round the Longitude column two decimal places.

Round the Longitude column two decimal places.

Change the data type of the TempCelsius column to Integer

Change the data type of the TempCelsius column to Integer
Suggested answer: B

Explanation:

Disable Power Query load.

Power Query queries that are intended support data integration with other queries should not be loaded to the model. To avoid loading the query to the model, take care to ensure that you disable query load in these instances.

Reference:

https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction#disablepower-query-query-load

asked 05/10/2024
Feras Al Babtain
27 questions

Question 116

Report
Export
Collapse

In Power Bi Desktop, you are creating visualizations in a report based on an imported dataset You need to allow Power Bi users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying data What should you do?

From Power BI Desktop, configure the Data Load settings for the current file.

From Power BI Desktop, configure the Data Load settings for the current file.

From the Power BI service, configure the dataset permissions.

From the Power BI service, configure the dataset permissions.

From Power BI Desktop, configure the Report settings for the current file.

From Power BI Desktop, configure the Report settings for the current file.

From Power BI Desktop, modify the data source permissions.

From Power BI Desktop, modify the data source permissions.
Suggested answer: C

Explanation:

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export- data?tabs=powerbi-desktopThe export functionality can be disabled on several levels. First, Power BI Service admins can disable this functionality on tenant level. With that, nobody will be able to export the data. More about that later. Second, as a dataset owner you can decide if you allow your users to export the data. This is managed in dataset settings, but only changeable in Power BI desktop.No matter what settings are applied in Power BI desktop, the tenant settings will overrule this. In the end the Power BI Service admin decides what options are possible to use.https://data-marc.com/2020/04/13/power-bi-governance- why-you-should-consider-to-disable- export-to-excel/

asked 05/10/2024
Kong Yew Kuen
38 questions

Question 117

Report
Export
Collapse

You have a Power BI report. The report contains visualizations that have interactions. You need to identify which visualizations take the longest to complete. What should you use?

SQL Server Profiler

SQL Server Profiler

Performance Analyzer in Power BI Desktop

Performance Analyzer in Power BI Desktop

Query Diagnostics in Power BI

Query Diagnostics in Power BI

Microsoft Edge DevTools

Microsoft Edge DevTools
Suggested answer: B

Explanation:

Use Power BI Desktop Performance Analyzer to optimize reports.

In Power BI Desktop you can find out how each of your report elements, such as visuals and DAX formulas, are performing. Using the Performance Analyzer, you can see and record logs that measure how each of your report elements performs when users interact with them, and which aspects of their performance are most (or least) resource intensive.

Reference:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer

asked 05/10/2024
SAM E REYES
34 questions

Question 118

Report
Export
Collapse

You are building a Power BI report to analyze customer segments.

You need to identify customer segments dynamically based on the Bounce Rate across dimensions such as source, geography, and demographics. The solution must minimize analysis effort. Which type of visualization should you use?

decomposition tree

decomposition tree

funnel chart

funnel chart

Q&A

Q&A

key influencers

key influencers
Suggested answer: A

Explanation:

The key influencers visual is a great choice if you want to:

See which factors affect the metric being analyzed.

Contrast the relative importance of these factors. For example, do short-term contracts affect churn more than long-term contracts? Note: The key influencers visual helps you understand the factors that drive a metric you're interested in. It analyzes your data, ranks the factors that matter, and displays them as key influencers. For example, suppose you want to figure out what influences employee turnover, which is also known as churn. One factor might be employment contract length, and another factor might be commute time. https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers

asked 05/10/2024
Chaston Williams
33 questions

Question 119

Report
Export
Collapse

You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product. The Sales table contains purchase and ship dates. Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together. You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source. Which data modeling design should you use?

Use the Auto Date/Time functionality in Microsoft Power Bl and do NOT import the Date table.

Use the Auto Date/Time functionality in Microsoft Power Bl and do NOT import the Date table.

Duplicate the Date query in Power Query and create active relationships between Sales and both Date tables in the modeling view.

Duplicate the Date query in Power Query and create active relationships between Sales and both Date tables in the modeling view.

On the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view.

On the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view.

Import the Date table twice in Power Query and create active relationships between Sales and both Date tables in the modeling view.

Import the Date table twice in Power Query and create active relationships between Sales and both Date tables in the modeling view.
Suggested answer: D

Explanation:

Microsoft recommends defining active relationships whenever possible. They widen the scope and potential of how your model can be used by report authors, and users working with Q&A. Refactoring methodology (example): Here's a methodology to refactor a model from a single roleplaying dimension-type table, to a design with one table per role. Remove any inactive relationships.

Consider renaming the role-playing dimension-type table to better describe its role. In the example, the Airport table is related to the ArrivalAirport column of the Flight table, so it's renamed as Arrival Airport. Create a copy of the role-playing table, providing it with a name that reflects its role. If it's an Import table, we recommend defining a calculated table. If it's a DirectQuery table, you can duplicate the Power Query query. Only one relationship can be active.

Note: If you query two or more tables at the same time, when the data is loaded, Power BI Desktop attempts to find and create relationships for you. The relationship options Cardinality, Cross filter direction, and Make this relationship active are automatically set.

Reference:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-managerelationships

https://docs.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive

asked 05/10/2024
Arnold Bronson TCHOFFO
44 questions

Question 120

Report
Export
Collapse

In Power BI Desktop, you are building a sales report that contains two tables. Both tables have rowQuestions & Answers PDF P-145 level security (RLS) configured. You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings. What should you do?

Create an active relationship between the tables and select Assume referential integrity.

Create an active relationship between the tables and select Assume referential integrity.

Create an inactive relationship between the tables and select Assume referential integrity.

Create an inactive relationship between the tables and select Assume referential integrity.

Create an inactive relationship between the tables and select Apply security filter in both directions.

Create an inactive relationship between the tables and select Apply security filter in both directions.

Create an active relationship between the tables and select Apply security filter in both directions.

Create an active relationship between the tables and select Apply security filter in both directions.
Suggested answer: D

Explanation:

By default, row-level security filtering uses single-directional filters, whether the relationships are set to single direction or bi-directional. You can manually enable bi-directional cross-filtering with rowlevel security by selecting the relationship and checking the Apply security filter in both directions checkbox. Select this option when you've also implemented dynamic row-level security at the server level, where row-level security is based on username or login ID.

Microsoft PL-300 image Question 87 explanation 106344 10052024010716000000

Reference:

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

asked 05/10/2024
ELVIS KENVO
42 questions
Total 370 questions
Go to page: of 37
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

You have the tables shown in the following table. The Impressions table contains approximately 30 million records per month. You need to create an ad analytics system to meet the following requirements: Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required. Minimize the data model size. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars. You need to create a reference line to show which employees are above the median salary. Solution: You create a median line by using the Salary measure. Does this meet the goal?
You have a Power BI model that contains a table named Sales. The Sales table contains the following columns: * Order Line ID * Product ID * Unit Price * Order ID * Quantity Orders are uniquely identified by using the order ID and can have multiple order lines Each order line within an order contains a different product ID. You need to write a DAX measure that counts the number of orders. Which formula should you use?
HOTSPOT You have the Power Bl data model shown in the following exhibit. You need to create a measure to count the number of product categories that had products sold during a selected period. How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. From Power Query Editor, you profile the data shown in the following exhibit. The IoT GUID and IoT ID columns are unique to each row in query. You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance. Solution: You split the loT DateTime column into a column named Date and a column named Time. Does this meet the goal?
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?
You have a query that returns the data shown in the following exhibit. You need to configure the query to display the data as shown in the following exhibit. Which step should you use in the query?
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 m 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.
DRAG DROP You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones. You need to build the dashboard. Which four 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.
DRAG DROP You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date. The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table. You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent. How should you complete the calculation? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.