QUESTION: 53

You have a Power BI query named Sales that imports the columns shown in the following table.
Users only use the date part of the Sales_Date field. Only rows with a Status of Finished are used in analysis.
You need to reduce the load times of the query without affecting the analysis.
Which two actions achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

Remove the rows in which Sales[Status] has a value of Canceled.
Remove Sales[Sales_Date].
Change the data type of Sale[Delivery_Time] to Integer.
Split Sales[Sale_Date] into separate date and time columns.
Remove Sales[Canceled Date].

Answer(s): A,E

Reveal Solution Next Question

QUESTION: 54

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?

one-to-many from Transaction to Customer
one-to-one between Customer and Transaction
many-to-many between Customer and Transaction
one-to-many from Customer to Transaction

Answer(s): D

Reveal Solution Next Question

QUESTION: 55

You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.
You build a report analyzing the internal networks of employees based on whom they send emails to.
You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.
What should you do?

From Model view, set the Subject and Body columns to Hidden.
Remove the Subject and Body columns during the import.
Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.

Answer(s): B

Reveal Solution Next Question

QUESTION: 56

HOTSPOT (Drag and Drop is not supported)
You create a Power BI dataset that contains the table shown in the following exhibit.
You need to make the table available as an organizational data type in Microsoft Excel.
How should you configure the properties of the table? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

See Explanation section for answer.

Answer(s): A

Explanation:

Box 1: Cost Center
The Row label field value is used in Excel so users can easily identify the row. It appears as the cell value for a linked cell, in the Data Selector pane, and in the
Information card.

Box 2: ID
The Key column field value provides the unique ID for the row. This value enables Excel to link a cell to a specific row in the table.
Box 3: Yes
In the Data Types Gallery in Excel, your users can find data from featured tables in your Power BI datasets.