QUESTION: 41

You use Power Query Editor to preview a column named Date as shown in the following exhibit.
You need to change the Date column to contain only the year. The solution must minimize administrative effort.
What should you do?

Split the column by delimiter.
Split the column by number of characters.
Extract the text after the delimiter.
Transform the column to contain only the year.

Answer(s): D

Reveal Solution Next Question

QUESTION: 42

HOTSPOT (Drag and Drop is not supported)
You are designing the data model for a Power BI semantic model.
You have the following tables in the star schema.
Which table is the fact table of the star schema, and which column in the Patient table is the surrogate key of the star schema? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

See Explanation section for answer.

Answer(s): A

Explanation:

Reveal Solution Next Question

QUESTION: 43

You use Power BI Desktop to import two tables named Customer and Contacts.
The Customer table contains the following columns:
• Customer_Name
• Customer ID
• Website
The Contacts table contains the following columns:
• Contact ID
• Contact Email
• Contact Name
• Customer Name
A web-based contact form is used to fill the Contacts table. The data is not sanitized.
You need to create a merge for the Customer and Contacts tables.
What should you do?

Disable fuzzy matching.
Enable fuzzy matching.
Set Join Kind to Left Outer.

Answer(s): B

Reveal Solution Next Question

QUESTION: 44

HOTSPOT (Drag and Drop is not supported)
You are using Microsoft Power BI Desktop to profile data in Power Query Editor.
Table data is displayed as 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.