Microsoft PL-300 Value Pack (Frequently Bought Together)

You have a Power BI model mat contains a table named Date. The Date table contains the fallowing columns:
; Date
; Fiscal year
; Fiscal Quartet
; Month Name
; Calendar Year
; Week Number
; Month Number
; Calendar Quarter
You need to create a calculated table based on the Date table. The calculated tab*e must contain only unique combinations of values for Calendar Year. Calendar Quarter and Calendar Month. Which DAX function should you include in the table deflation?

• A. ADDCOLUMS
• B. SUMMARIZE
• C. DATATABLE
• D. CALCULATE

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 fol-lowing 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. What should you do?

• A. Create a column by example that starts with 2018-12-31.
• B. split the Logged column by using at as the delimiter.
• C. Apply a transformation to extract the first 11 characters of the Logged column.
• D. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.

You plan to create a Power BI semantic model named ModeM that will contain data from an Azure SQL database. Model1 will have the following tables.

For the last three days, refresh in Power BI has failed, and you receive the following error message: " You have reached the maximum allowable memory allocation for your tier. Consider upgrading to a tier with more available memory. " You need to resolve the error and ensure that query response times are minimized for end users.
What should you do?

• A. Change the Invoice table to a DirectQuery table and read the data live from the source, retaining only the dimension tables as import tables.
• B. Merge the Sales person and Invoice tables based on the SalesPersonld column.
• C. Change the Invoice table to a composite table that contains historical data as a DirectQuery table and hot data as an import table, and then partition the table.
• D. Reduce the size of the Invoice table by summarizing sales by Product, Sales person, Calendar, and Customer.

You publish the semantic model to the Power BI service.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

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.