Free Access Microsoft.PL-300.v2023-01-23.q95 Practice Test (Page 10)

Question 41

You build a report to analyze customer transactions from a database that contains the tables shown in the following table.

You import the tables.
Which relationship should you use to link the tables?

A.one-to-many from Customer to Transaction

B.one-to-one between Customer and Transaction

C.one-to-many from Transaction to Customer

D.many-to-many between Customer and Transaction

Question 42

You have a column named UnitslnStock as shown in the following exhibit

Question 43

You have the dataset shown in the following exhibit.

You need to ensure that the visual shows only the 10 cities that have the highest sales profit.
What should you do?

A.Add a Top N filter to the visual.

B.Configure the Sales Profit measure to use the RANKX function.

C.Add a calculated column to the table that uses the TOPN function. In the visual, replace Sales Profit with the calculated column.

D.Add a calculated column to the table that returns the city name if the city is in the top 10, otherwise the

Question 44

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.

Question 45

You have an app workspace that contains a dashboard and four reports. All the reports are generated from a single dataset that contains sales data for your company.
The reports display the data configured as shown in the following table.

You need to ensure that the users of the reports can locate the correct report by using natural language queries.
What should you do?

A.From the properties of the dataset, create four Featured Q&A Questions.

B.From the Format settings of the reports, modify the Page Information.

C.From the properties of the workspace, modify the Language Settings.

D.From the properties of the dataset, modify the Q&A and Cortana settings.

Other Version: 1358Microsoft.PL-300.v2025-08-09.q128; 2015Microsoft.PL-300.v2025-02-06.q388; 824Microsoft.PL-300.v2025-01-02.q198; 2677Microsoft.PL-300.v2023-04-01.q113; 1630Microsoft.PL-300.v2023-03-22.q84; 1272Microsoft.PL-300.v2023-03-09.q86; 1616Microsoft.PL-300.v2023-02-20.q102; 2520Microsoft.PL-300.v2022-11-30.q157; 3434Microsoft.PL-300.v2022-06-21.q103

Latest Upload: 113Google.Generative-AI-Leader.v2025-10-28.q15; 118EXIN.CDCP.v2025-10-28.q40; 154Huawei.H19-315-ENU.v2025-10-27.q108; 144Salesforce.CRT-550.v2025-10-27.q146; 138SAP.E-S4CPE-2405.v2025-10-27.q51; 136Microsoft.SC-200.v2025-10-27.q144; 276CompTIA.SY0-701.v2025-10-27.q603; 126MedicalTests.AAPC-CPC.v2025-10-27.q53; 116ICF.ICF-ACC.v2025-10-27.q28; 189Cisco.400-007.v2025-10-27.q275

Question 41

Question 42

Question 43

Question 44

Question 45

Download PDF File