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

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

Add to Whishlist

List of questions

Question 391

Report Export Collapse

HOTSPOT

You use Microsoft Power B1 Desktop to review the data shown in the following exhibit.

Microsoft PL-300 image Question 21 63881986188426886884122


Become a Premium Member for full access
  Unlock Premium Member

Question 392

Report Export Collapse

DRAG DROP

You have a semantic model.

You need to configure row level security (RLS) to restrict data access for users that have the Viewer permissions.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to tie answer area and arrange them in the correct order.


Become a Premium Member for full access
  Unlock Premium Member

Question 393

Report Export Collapse

You have a semantic model named Model1 that contains sales data.

You need to ensure that Modell is refreshed on the first day of each month to include last month's sales data. What should you configure?

Become a Premium Member for full access
  Unlock Premium Member

Question 394

Report Export Collapse

Vou have a Microsoft Power Bl Desktop report named Report! that uses an Azure SQL database as a data source. A user named User1 plans to create a report by using the same data source as Report1.

You need to simplify the connection to the data source for User1.

Which type of file should you create?

Become a Premium Member for full access
  Unlock Premium Member

Question 395

Report Export Collapse

HOTSPOT

You use Power Query Editor to review the query shown in the following exhibit.

Microsoft PL-300 image Question 25 63881986188426886884122


Become a Premium Member for full access
  Unlock Premium Member

Question 396

Report Export Collapse

HOTSPOT

You have the Performance analyzer results shown in the following exhibit.

Microsoft PL-300 image Question 26 63881986188426886884122


Become a Premium Member for full access
  Unlock Premium Member

Question 397

Report Export Collapse

HOTSPOT

You have a query that contains customer data in Power Query Editor as shown in the following exhibit.

Microsoft PL-300 image Question 27 63881986188442510748242


Become a Premium Member for full access
  Unlock Premium Member

Question 398

Report Export Collapse

HOTSPOT

You use Power Query Editor to preview the data shown in the following exhibit.

Microsoft PL-300 image Question 28 63881986188442510748242


Become a Premium Member for full access
  Unlock Premium Member

Question 399

Report Export Collapse

DRAG DROP

You use Power Query Editor to Import three tables named Customers. Address, and Country.

In the source system, not every customer has a related address, but every address has a related country.

You need to merge all the tables into a single query. The solution must optimise query refresh performance.

Which type of join should you use for each merge operation? To answer, drag the appropriate join types to the correct operations. Each join type 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 it worth one point.


Become a Premium Member for full access
  Unlock Premium Member

Question 400

Report Export Collapse

You have a Power B1 semantic model that contains tour queries named Query 1, Query2, Query3, and Query4, Query1 loads customer data Into the model and is referenced by the other three queries. You discover that data refresh for the model is slow.

You need to improve the data refresh time. The solution must minimi2e costs. What should you do?

Become a Premium Member for full access
  Unlock Premium Member
Total 414 questions
Go to page: of 42
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.