Fabric Analytics Engineer Power Query Transformation

1. In Fabric, which tool is used for real-time data ingestion and processing?

Dataflows

Eventstreams

Pipelines

Notebooks

Submit

3. Which transformation removes leading and trailing spaces from text?

Text.Clean

Text.Trim

Text.Strip

Text.Format

Submit

5. Which Fabric workspace role allows users to create and edit content?

Viewer

Contributor

Admin

Member

Submit

7. Which function would you use to group data and calculate aggregate values?

Table.Group

Table.Aggregate

Table.Summarize

Table.Pivot

8. In Power Query, what does 'lazy evaluation' mean?

Queries execute immediately upon creation

Transformations execute only when data is needed

All steps run in parallel

Queries wait for user confirmation

9. Which M function extracts text between two delimiters?

Text.BetweenDelimiters

Text.Middle

Text.Range

Text.Extract

Submit

11. Which Power Query function is used to remove duplicate rows based on specific columns?

Table.Distinct

Table.RemoveDuplicates

Table.Unique

Table.FilterRows

12. What is the purpose of the 'Merge Queries' function in Power Query?

Combine columns from two tables

Stack rows from multiple tables

Remove duplicate entries

Pivot data from rows to columns

13. Which data type in Power Query represents whole numbers without decimals?

Decimal

Integer

Whole Number

Long

14. In Power Query, how do you handle errors in a transformation step?

Replace Error with null value

Delete the entire row

Use Try-Catch function

Both a and c

15. What does the 'Append Queries' operation do in Power Query?

Combines rows from two tables

Merges columns horizontally

Filters data based on conditions

Sorts data in ascending order

16. Which Fabric component stores and manages large-scale data for analytics?

Lakehouse

Warehouse

Datamart

All of the above

17. In Power Query, which function converts text to a number data type?

Number.FromText

Text.ToNumber

Value.FromText

Int.Parse

18. What is the primary purpose of the Power Query Editor in Fabric?

Create visualizations

Transform and clean data before loading

Generate SQL queries

Design dashboard layouts

19. Which transformation step would you use to split a column containing 'FirstName LastName' into separate columns?

Split Column by Delimiter

Merge Columns

Unpivot Columns

Group By

20. In Power Query, what does the M language stand for?

Markup

Mashup

Metadata

Module

Fabric Analytics Engineer Power Query Data Transformation Quiz

1. In Fabric, which tool is used for real-time data ingestion and processing?

2.

What first name or nickname would you like us to use?

2. In Fabric, a ______ is a curated subset of data from a lakehouse optimized for specific business scenarios.

3. Which transformation removes leading and trailing spaces from text?

4. In Power Query, the 'Table.TransformColumnTypes' function is used to ______.

5. Which Fabric workspace role allows users to create and edit content?

6. The default encoding for text files in Power Query is ______.

7. Which function would you use to group data and calculate aggregate values?

8. In Power Query, what does 'lazy evaluation' mean?

9. Which M function extracts text between two delimiters?

10. The 'Pivot Column' transformation converts ______ into columns.

11. Which Power Query function is used to remove duplicate rows based on specific columns?

12. What is the purpose of the 'Merge Queries' function in Power Query?

13. Which data type in Power Query represents whole numbers without decimals?

14. In Power Query, how do you handle errors in a transformation step?

15. What does the 'Append Queries' operation do in Power Query?

16. Which Fabric component stores and manages large-scale data for analytics?

17. In Power Query, which function converts text to a number data type?

18. What is the primary purpose of the Power Query Editor in Fabric?

19. Which transformation step would you use to split a column containing 'FirstName LastName' into separate columns?

20. In Power Query, what does the M language stand for?