Free Microsoft PL-300 Exam Dumps - Page 3

MultipleChoice

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged

contains the date and time each compliant occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.

You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.

D18912E1457D5D1DDCBD40AB3BF70D5D

What should you do?

MultipleChoice

You have two CSV files named Products and Categories. The Products file contains the following columns:

* ProductID

* ProduetName

* SupplierID

* CategoryID

The Categories file contains the following columns:

From Power Bl Desktop, you import the files into Power Query Editor.

You need to create a Power Bl dataset that will contain a single table named Product. The Product will table includes the following columns:

Hotspot

You are enhancing a Power BI model that has DAX calculations.

You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.

Which DAX functions should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

OrderList

You publish a dataset lhat contains data from an on-premises Microsoft SQL Server database.

The dataset must be refreshed daily.

You need to ensure that the Power BI service can connect to the database and refresh the dataset.

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

MultipleChoice

You have a Power BI data model that analyzes product sales ever time. The data model contains the following tables.

A one-to-many relationship exists between the tables.

The auto date/time option for the data model enabled.

You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.

Which two actions should you perform?

MultipleChoice

support the reports?

MultipleChoice

You need to create a visualization to meet the reporting requirements of the sales managers.

HOW Should create the Visualization? TO answer, select the appropriate options in the answer are