exam questions

Exam DA-100 All Questions

View all questions & answers for the DA-100 exam

Exam DA-100 topic 1 question 7 discussion

Actual exam question from Microsoft's DA-100
Question #: 7
Topic #: 1
[All DA-100 Questions]

DRAG DROP -
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.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
Step 1: Expand the records.
First Open Power BI desktop and navigate to Power Query, import the JSON file, then load the data, click on the record to expand it and to see the record and list.
Step 2: Add columns that use data type conversions.
Step 3: Convert the list to a table

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
NS1992
Highly Voted 2 years, 11 months ago
Convert the list to a table Expand the Columns Set the Data types
upvoted 57 times
...
NK19
Highly Voted 2 years, 10 months ago
See this SO post: https://stackoverflow.com/a/62227450 It is: Convert the list to a table Expand the Columns Set the Data types
upvoted 10 times
...
SamAlex3824
Most Recent 1 year, 1 month ago
GPT suggests these 3 options 1. Expand the record 2. Convert the list to a table 3. Set the Data type What do you guys think?
upvoted 1 times
...
Mampers
2 years ago
I am confused. Is is the steps above as shown or the steps below as everyone else has mentioned.
upvoted 1 times
...
Mona00
2 years, 10 months ago
Cover list to a table Expand the record Set the Data type
upvoted 2 times
Davico93
2 years, 10 months ago
"Expand the record" doesn't exist as a power bi step, it's "Expand the Columns"
upvoted 3 times
...
...
canon12000
2 years, 10 months ago
Convert list to table Expand the records Expand the columns
upvoted 1 times
...
usmanbinihsan
2 years, 11 months ago
Convert list to table Expand Columns Set the Data types
upvoted 2 times
...
Bhushan_M
2 years, 11 months ago
Convert List to Table Expand the column set the Data Types
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago