Microsoft Updated PL-300 Exam Questions and Answers by delilah-rose

You need to create a visualization that compares revenue and cost over time.

Which type of visualization should you use?

You have a report that contains a donut chart and a clustered column chart. Interactions between the visuals use the default settings.

You need to modify the report so that when you select a column m the column chart, the donut chart redraws by using the data from the selected column.

What should you do?

You have a folder of monthly transaction extracts.

You plan to create a report to analyze the transaction data.

You receive the following email message: "Hi. I've put 24 files of monthly transaction data onto the shared drive. File Transactions201901.csv through Transactions201912.csv have the latest set of columns, but files Transactions201801.csv to Transactions201812.csv have an older layout without the extra fields needed for analysis. Each file contains 10 to 50 transactions."

You get data from the folder and select Combine & Load. The Combine Files dialog box is shown in the exhibit. (Click the Exhibit tab.)

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Users only use the date portion of the TransactionDate value when performing data analysis. You need to minimize the model size without affecting the analysis.

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

NOTE: Each correct selection is worth one point.