You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date.
You need to reduce the size of the data model.
What should you do?

• A.Round the hour of the Date column to startOfHour.
• B.Change the data type of the Date column to Text.
• C.Trim the Date column.
• D.Split the Date column into two columns, one that contains only the time and another that contains only the date.

Comment: *

Name: *

Email: *

Verification: *

Hotspot Question
You have a table that contains the following three columns:
* City
* Total Sales
* Occupation
You need to create a key influencers visualization as shown in the exhibit. (Click the Exhibit tab.)

How should you configure the visualization? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
Box 1: Total Sales
Box 2: Occupation
Box 3: City
You can use Expand By to add fields you want to use for setting the level of the analysis without looking for new influencers.
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers

Comment: *

Name: *

Email: *

Verification: *

You are building a dataset from a JSON file that contains an array of documents.
You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in Microsoft Power BI reports.
Which three 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 order.

Correct Answer:

Explanation
1- Convert list to table
2- Expand Column
3- Set Date type
Here is an example: https://youtu.be/B4kzyxnhQfI
The definition of the function which expand columns:
https://docs.microsoft.com/en-us/powerquery-m/table-expandrecordcolumn

Comment: *

Name: *

Email: *

Verification: *

You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date.
You need to reduce the size of the data model.
What should you do?

• A.Round the hour of the Date column to startOfHour.
• B.Change the data type of the Date column to Text.
• C.Trim the Date column.
• D.Split the Date column into two columns, one that contains only the time and another that contains only the date.

Comment: *

Name: *

Email: *

Verification: *

You have the data lineage 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.

Correct Answer:

Explanation
Text, table Description automatically generated with medium confidence

Box 1: CONTOSO BIKES report
Box 2: three datasets
Images, tweets and the Contoso datasets.

Comment: *

Name: *

Email: *

Verification: *