Back to Subject

Unit 2: Connecting and Preparing Data - Practice Quiz

INT374 — Data Analytics With Power Bi 50 Questions
0 Correct 0 Wrong 50 Left
0/50

1 In the context of Power BI, what represents the 'Back-End' of the application?

A. Power Query Editor
B. Power BI Service
C. The Model View
D. The Report View

2 Which programming language is used behind the scenes in Power Query?

A. SQL
B. Python
C. DAX
D. M Language

3 What is the primary function of the 'Navigator' window when connecting to data?

A. To preview and select tables or sheets to import
B. To merge datasets
C. To create visualizations
D. To write SQL queries

4 Which connector would you use to import multiple Excel files with the same structure from a single directory?

A. Folder
B. Excel Workbook
C. SharePoint List
D. Text/CSV

5 In Power Query, what does the 'Applied Steps' pane track?

A. The DAX formulas used in the report
B. The user's login history
C. The list of available data sources
D. Every data transformation action performed on the query

6 What is the best way to clean a text column that contains unnecessary leading and trailing whitespace?

A. Replace Values
B. Clean
C. Format -> Lowercase
D. Trim

7 What is the purpose of the 'Clean' transformation in the Text tools?

A. Removes non-printable control characters
B. Removes duplicate rows
C. Removes spaces
D. Removes null values

8 When connecting to a SQL Database, which mode allows data to remain in the database without caching it in Power BI?

A. Dual
B. Live Connection
C. Import
D. DirectQuery

9 You have a column 'OrderDate' formatted as 'Text' (e.g., '12/31/2022'). How should you fix this for time intelligence?

A. Split the column
B. Leave it as Text
C. Replace the slashes with hyphens
D. Change Type to Date

10 Which feature helps you extract data from a website table just by providing the URL?

A. OData Feed
B. Web Connector
C. Azure Blob Storage
D. JSON Connector

11 Which Data Profiling tool displays the percentage of Empty, Error, and Valid values in a column?

A. Column Distribution
B. Monospace
C. Column Profile
D. Column Quality

12 What does 'Column Distribution' show in the View tab?

A. The applied steps
B. A frequency histogram and count of distinct/unique values
C. The statistical average
D. The data type of the column

13 If you need to change a text date '15-Jan-2023' to a Date type, but your system settings are US (MM/DD/YYYY), which feature should you use?

A. Change Type -> Date
B. Using Locale
C. Format -> Uppercase
D. Split Column

14 What is the result of using 'Unpivot Columns' on a dataset?

A. It turns selected columns into attribute-value pairs (rows)
B. It removes duplicate columns
C. It aggregates data
D. It turns rows into columns

15 What is the purpose of an 'Index Column'?

A. To index the data for faster search
B. To group duplicate rows
C. To sort data alphabetically
D. To add a unique sequential number to each row

16 Which tool allows you to create a new column based on 'If-Then-Else' logic without writing code?

A. Index Column
B. Conditional Column
C. Example Column
D. Custom Column

17 You want to combine two tables by stacking them vertically (adding rows from one table to another). Which operation is this?

A. Group By
B. Transpose
C. Merge Queries
D. Append Queries

18 You want to combine two tables based on a common column (similar to a VLOOKUP or SQL JOIN). Which operation is this?

A. Pivot Column
B. Transpose
C. Merge Queries
D. Append Queries

19 In a 'Left Outer' join merge, what is the result?

A. All rows from the first table and matching rows from the second
B. All rows from the second table and matching rows from the first
C. Only matching rows from both tables
D. All rows from both tables

20 What does the 'Fill Down' transformation do?

A. Copies the header to the first row
B. Removes empty rows
C. Fills null values with zero
D. Replaces null values with the value from the cell above

21 How can you extract the domain name from an email address column in Power Query?

A. Unpivot
B. Transpose
C. Change Type
D. Split Column by Delimiter (@)

22 Which transformation turns rows into columns (e.g., turning a column of 'Year' values into individual column headers)?

A. Transpose
B. Pivot Column
C. Reverse Rows
D. Unpivot

23 What happens if you change the file location of your data source on your computer?

A. The data becomes static
B. Power BI deletes the dataset
C. Power BI automatically finds the new location
D. The query breaks and returns an error

24 Where can you update the file path if a source file is moved?

A. Applied Steps
B. Manage Relationships
C. Data Source Settings
D. Advanced Editor

25 What does the 'Group By' feature do?

A. Sorts data into folders
B. Colors rows based on groups
C. Summarizes data at a higher level of granularity
D. Merges two tables

26 Which of the following is NOT a valid aggregation in the 'Group By' window?

A. Count Rows
B. Split
C. Sum
D. Average

27 If you import a CSV and the headers appear as 'Column1', 'Column2' in the first row of data, what step should you apply?

A. Transpose
B. Use First Row as Headers
C. Pivot
D. Remove Top Rows

28 What is the purpose of 'Remove Top Rows'?

A. To sample the data
B. To delete the headers
C. To filter out low sales
D. To remove metadata or blank lines often found at the top of reports

29 Which Date tool calculates the age of a record based on the current date?

A. Age
B. Earliest
C. Month
D. Year

30 When extracting data from a web page, 'Add Table Using Examples' allows you to:

A. Download images
B. Write HTML code
C. Hack the website
D. Define the data you want by typing sample values

31 What is a 'Reference' query?

A. A new query that sources its data from the output of an existing query
B. A duplicate copy of a query
C. A query linked to a website
D. A backup query

32 What is the difference between 'Duplicate' and 'Reference' query?

A. Duplicate copies the steps; Reference depends on the original query's output
B. They are identical
C. Reference creates a static table
D. Reference copies the steps; Duplicate depends on output

33 Which numeric transformation would you use to find the remainder of a division operation?

A. Divide
B. Absolute Value
C. Modulo
D. Round

34 To convert a column of values like 'USD 50', 'USD 100' into pure numbers, what is the best approach?

A. Format as Currency
B. Change Type to Whole Number immediately
C. Replace 'USD ' with nothing, then Change Type
D. Filter out USD

35 What does the 'Transpose' function do?

A. Sorts data
B. Rotates the table 90 degrees (rows become columns)
C. Deletes empty columns
D. Moves columns to the left

36 Which View tab option allows you to see the exact code generated by your transformations?

A. Query Dependencies
B. Advanced Editor
C. Monospaced
D. Parameters

37 In 'Column Profile', what does 'Value Distribution' display?

A. A graph showing the frequency of specific values in the column
B. The database source
C. The count of errors
D. The column name

38 You have a 'Product ID' column like 'AB-123-XY'. You want only the middle number '123'. Which Text tool is best?

A. Extract -> Text Between Delimiters
B. Format -> Trim
C. Merge Columns
D. Split by Delimiter

39 What is the primary benefit of 'Query Folding' in database connections?

A. It creates folders for queries
B. It pushes transformation logic back to the source database for performance
C. It compresses the file size
D. It folds columns into rows

40 If a step in Power Query results in an 'Error' value in a cell, how can you handle it to prevent breaking the load?

A. Delete the column
B. Ignore it
C. Filter the error
D. Replace Errors

41 Which feature helps visualize the relationship and flow between different queries in Power Query?

A. Data Model
B. Lineage View
C. Relationship Manager
D. Query Dependencies

42 When merging queries, what happens if there are multiple matches for a row in the secondary table?

A. It creates duplicate rows in the primary table (Cartesian product)
B. It takes the last match only
C. It returns an error
D. It takes the first match only

43 How do you combine three columns (Day, Month, Year) into a single Date column?

A. Merge Columns
B. Pivot
C. Split Column
D. Transpose

44 Which numerical tool calculates the total of a column without using Group By?

A. Standard -> Add
B. Statistics -> Sum
C. Information -> Sign
D. Scientific -> Power

45 In Power Query, 'Disable Load' is used to:

A. Delete the query
B. Hide the query in the editor
C. Stop the query from refreshing
D. Stop the query from being loaded into the Report/Data Model

46 What does 'Close & Apply' do?

A. Deletes all steps
B. Closes Power BI Desktop
C. Closes Power Query Editor and loads the transformed data into the model
D. Saves the M code but does not load data

47 Which option allows you to input data manually to create a small static table?

A. New Source -> Text
B. DirectQuery
C. Enter Data
D. Recent Sources

48 You want to create a column that says 'High' if Sales > 100 and 'Low' otherwise. You should use:

A. Duplicate Column
B. Index Column
C. Conditional Column
D. Split Column

49 What is the file extension for a Power BI Template file?

A. .pbit
B. .sql
C. .pbix
D. .xls

50 When using 'Date & Time' tools, what does 'Date Only' do?

A. Deletes the column
B. Removes the time component from a DateTime column
C. Extracts the year
D. Changes the time zone
Previous MCQ
Unit 1
Next MCQ
Unit 3