Introduction to PowerQuery

Quiz Summary

0 of 13 questions completed

Questions:

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 13 questions answered correctly

Your time:

You have reached 0 of 0 point(s), (0)

Average score
Your score

Current
Review
Answered
Correct
Incorrect

Question 1 of 13

1. Question
Which of the following features are not yet included in the Excel version of PowerQuery?
- Add values from example – From Web connector
- Python Script
- R Script
- SQL Server direct query mode
- SQL Server import mode
- Import from folder
- Query dependency view
- Query diagnostics
Correct 5 / 5 Points

Incorrect / 5 Points
Question 2 of 13

2. Question
PowerQuery can be used to write data back to the data source and is used often to implement write-back functionality for the SQL server.
- False
- True
Correct

Incorrect
Question 3 of 13

3. Question
Sort in ascending order PowerQuery introductions.
- Dataflows
- Common Data Service
- Excel
- PowerBI desktop
Correct

Incorrect
Question 4 of 13

4. Question
For which program was PowerQuery initially created?
- Excel 2013
- Excel 2010
- Office 365
- PowerBI
- PowerApps
- VBA
Correct

Incorrect
Question 5 of 13

5. Question
Match the features with the corresponding tab.
Sort elements
- Change incorrect data source credentials
- Pivot Column
- Index Column
- Show Query Settings (Applied steps pane)
- Query Diagnostics
- Home
- Transform
- Add Column
- View
- Tools
Correct

Incorrect
Question 6 of 13

6. Question
Why is the number filtering option missing from the Target volumes column?
- Column formatting is set to the wrong type
- Values in Target volumes column use wrong decimal number separator (should be comma instead of a dot)
- Values in the Target volumes column are not sorted. you can only filter on sorted values.
Correct

Incorrect
Question 7 of 13

7. Question
What is PowerQuery generally used for?
- Data extraction
- Changing data in the source destination
- Data transformation
- Data loading
- Analytics
Correct 3 / 3 Points

Incorrect / 3 Points
Question 8 of 13

8. Question
Put the following PowerBI parts into the usual use order.
- PowerQuery
- Connecting the data model with relationships
- Data loading
- Data visualization
- Source data
- Adding measures and calculated columns
Correct

Incorrect
Question 9 of 13

9. Question
In which of the following situations you can take advantage of PowerQuery?
- Scraping data from the web store.
- Cleaning messy Excel workbook.
- Entering data directly into a PowerBI data model.
- Connecting to a secured on-premise database.
- Setting automatic refresh intervals.
- Loading data from SQL Database.
- Setting row-level security.
Correct 4 / 4 Points

Incorrect / 4 Points
Question 10 of 13

10. Question
Which of the following best describes the PowerQuery tool?
- PowerQuery is a tool used to create predictions about future data.
- PowerQuery is mostly used to create an ad-hoc analysis.
- PowerQuery is an ETL tool used to shape, clean, store, and transform data using intuitive interfaces without having to use coding.
- PowerQuery is a simple ETL tool that can also be used to create powerful M language scripts that can join or append data from multiple data sources.
Correct

Incorrect
Question 11 of 13

11. Question
You made some changes in the PowerQuery applied steps area (you changed the ordering of the applied steps), which resulted in a corrupted script. What can you do?
- Click on undo button to return the script to a working state.
- Copy the script to a notepad and switch applied steps.
- Manually return applied steps in the correct order using Move up/Move down arrows.
- You script is corrupted and you need to record it again.
Correct

Incorrect
Question 12 of 13

12. Question
In which situation/s the refresh button is not needed in PowerQuery editor since it is synchronizing the data changes preview automatically?
- Connecting to SQL database in import mode.
- Connecting to SQL database in Direct Query mode.
- Connecting to a locally hosted Excel file.
- Connecting to Excel file hosted on OneDrive.
- None of the above.
Correct

Incorrect
Question 13 of 13

13. Question
Connect available connections with the correct PowerQuery version (PowerBI or both Excel and PowerBI)
Sort elements
- Web from Examples connector, Python Scripts, R Scripts, Azure live connection
- SQL database, One drive for business, One drive Personal
- PowerBI
- Both
Correct

Incorrect

Power Query Fundamentals Course

Introduction to PowerQuery

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

Sort elements

6. Question

7. Question

8. Question

9. Question

10. Question

11. Question

12. Question

13. Question

Sort elements