Big Halloween Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

  1. Home
  2. Microsoft
  3. Microsoft Certified: Power BI Data Analyst Associate
  4. PL-300
  5. Microsoft Power BI Data Analyst Questions and Answers

Pass the Microsoft Microsoft Certified: Power BI Data Analyst Associate PL-300 Questions and answers with CertsForce

 Microsoft Exams      Go to Exam Detail      Get Premium Access
Viewing page 3 out of 5 pages
Viewing questions 21-30 out of questions
Questions # 21:

You are using Power Bi Desktop to connect to an Azure SQL database The connection is configured as shown in the following exhibit.

Question # 21

Question # 21

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 solution is worth one point

Question # 21

Expert Solution
Questions # 22:

What is the minimum number of datasets and storage modes required to support the reports?

Options:
A.

two imported datasets

B.

a single DirectQuery dataset

C.

two DirectQuery datasets

D.

a single imported dataset

Expert Solution
Questions # 23:

You need to create a DAX measure in the data model that only allows users to see projections at the appropriate levels of granularity.

How should you complete the measure? 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.

Question # 23

Expert Solution
Questions # 24:

You need to minimize me size of the dataset. The solution must meet the report requirements What should you do?

Options:
A.

Change lite OrderlD column in the Orders table to the text data type.

B.

Filter out discontinued products while importing the Product table.

C.

Remove the QuantityPerUnit column from the Products table

D.

Group the Categories table by the CategorylD column.

Expert Solution
Questions # 25:

You need to create a relationship in the data model for RLS.

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

NOTE: Each correct selection is worth one point.

Question # 25

Expert Solution
Questions # 26:

In Power Query Editor, you have three queries named ProductCategory, ProductSubCategory, and Product.

Every Product has a ProductSubCategory.

Not every ProductsubCategory has a parent ProductCategory.

You need to merge the three queries into a single query. The solution must ensure the best performance in Power Query.

How should you merge the tables? To answer, drag the appropriate merge types to the correct queries. Each merge 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 is worth one point.

Question # 26

Expert Solution
Questions # 27:

You need to create relationships to meet the reporting requirements of the customer service department.

What should you create?

Options:
A.

an additional date table named ShipDate, a one-to-many relationship fromSales[sales_date_id] to Date[date_id], and a one-to-many relationship fromSales[sales_ship_date_id] to ShipDate[date_id]

B.

an additional date table named ShipDate, a many-to-many relationship fromSales[sales_date_id] to Date[date_id], and a many-to-many relationship fromSales[sales_ship_date_id] to ShipDate[date_id]

C.

a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]

D.

a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-manyrelationship from Sales[sales_ship_date_id] to Date[date_id]

E.

a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Sales[sales_ship_date_id]

Expert Solution
Questions # 28:

You need to address the data concerns before creating the data model. What should you do in Power Query Editor?

Options:
A.

Select Column distribution.

B.

Select the sales_amount column and apply a number filter.

C.

Select Column profile, and then select the sales_amount column.

D.

Transform the sales_amount column to replace negative values with 0.

Expert Solution
Questions # 29:

You have five sales regions. Each region is assigned a single salesperson.

You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson.

Salespeople must see only the data from their region.

You publish the dataset to powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople.

A salesperson reports that she believes she should see more data.

You need to verify what data the salesperson currently sees.

What should you do?

Options:
A.

Use the Test as role option to view data as the salesperson's user account.

B.

Use the Test as role option to view data as the Sales role.

C.

Instruct the salesperson to open the report in Microsoft Power Bl Desktop.

D.

Filter the data in the reports to match the intended logic in the filter on the sales transaction table.

Expert Solution
Questions # 30:

You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports.

What should you recommend?

Options:
A.

Create a shared dataset for each standardized entity.

B.

Create dataflows for the standardized data and make the dataflows available for use in all imported datasets.

C.

For every report, create and use a single shared dataset that contains the standardized data.

D.

For the three entities, create exports of the data from the Power Bl model to Excel and store the data in Microsoft OneDrive for others to use as a source.

Expert Solution
Viewing page 3 out of 5 pages
Viewing questions 21-30 out of questions