Pre-test ASCC - Data Analytics

What is the main function of Power Query in Power BI?

• Data visualization

• Data modeling

• Data transformation

• Creating KPIs

Which file format cannot be processed by Power Query in Power BI??

• .XLSX

• .EXE

• .CSV

• .XML

In the context of Power Query: Combining two tables or queries based on the same column is called ...

• Filtering

• Integrating

• Merging

• Sorting

What tool is commonly used to clean dirty or unstructured data in Power Query?

• Transformations

• Formulas

• Parameters

• DAX

The connection between tables that enables complex data analysis is called ...

• Data Relationship

• Data Comparison

• Data Integration

• Data Simplification

What is a "Star Schema" in the context of Data Modeling?

• 5. Data structure where there is a main table connected to several additional tables

• 5. Data structure with one exclusive table

• 5. Highly complex data structure

• 5. Data structure with no relationship between tables

What is meant by "Cardinality" in the context of Data Modeling?

• Number of columns in a table

• Relationship between two tables

• Type of visualization in Power BI

• Number of rows in a table

What is the abbreviation for DAX?

• Data Analytics Exceptions

• Data Analysis Expressions

• Data Access Expansions

• Data Assessment Exclusions

What DAX function is used to add up selected values?

• SUM

• ADD UP

• ADD

• MAX UP

What does the DAX function "AVERAGE" do?

• 10. Add up values in a column

• Calculate the mean of values in a column

• 10. Locate the average value in a column

• Determine the minimum value in a column