1In the context of Power BI, what represents the 'Back-End' of the application?
A.Power BI Service
B.The Model View
C.Power Query Editor
D.The Report View
Correct Answer: Power Query Editor
Explanation:
Power Query Editor represents the back-end (the kitchen) where data is extracted, transformed, and loaded, while the Report view is the front-end visualization.
Incorrect! Try again.
2Which programming language is used behind the scenes in Power Query?
A.SQL
B.Python
C.DAX
D.M Language
Correct Answer: M Language
Explanation:
Power Query uses the M formula language for data transformation steps, whereas DAX is used for calculations in the front-end model.
Incorrect! Try again.
3What is the primary function of the 'Navigator' window when connecting to data?
A.To preview and select tables or sheets to import
B.To write SQL queries
C.To merge datasets
D.To create visualizations
Correct Answer: To preview and select tables or sheets to import
Explanation:
The Navigator window allows users to see a preview of the data within a source (like an Excel file or database) and select which tables to load.
Incorrect! Try again.
4Which connector would you use to import multiple Excel files with the same structure from a single directory?
A.Folder
B.SharePoint List
C.Text/CSV
D.Excel Workbook
Correct Answer: Folder
Explanation:
The Folder connector allows you to target a specific directory and combine/transform all matching files within that directory.
Incorrect! Try again.
5In Power Query, what does the 'Applied Steps' pane track?
A.The list of available data sources
B.The DAX formulas used in the report
C.Every data transformation action performed on the query
D.The user's login history
Correct Answer: Every data transformation action performed on the query
Explanation:
The Applied Steps pane records every transformation step (like filtering, renaming, or changing types) sequentially, allowing you to undo or modify them.
Incorrect! Try again.
6What is the best way to clean a text column that contains unnecessary leading and trailing whitespace?
A.Clean
B.Replace Values
C.Trim
D.Format -> Lowercase
Correct Answer: Trim
Explanation:
The 'Trim' function specifically removes white spaces from the beginning and end of a text string.
Incorrect! Try again.
7What is the purpose of the 'Clean' transformation in the Text tools?
A.Removes duplicate rows
B.Removes non-printable control characters
C.Removes null values
D.Removes spaces
Correct Answer: Removes non-printable control characters
Explanation:
'Clean' is used to remove non-printable characters (like line breaks or tab characters) that may appear in data imported from other systems.
Incorrect! Try again.
8When 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.DirectQuery
D.Import
Correct Answer: DirectQuery
Explanation:
DirectQuery queries the data source directly at query time and does not import a copy of the data into the Power BI file.
Incorrect! Try again.
9You 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.Change Type to Date
D.Replace the slashes with hyphens
Correct Answer: Change Type to Date
Explanation:
To use Time Intelligence functions and correct sorting, date columns must be strictly defined as the 'Date' or 'Date/Time' data type.
Incorrect! Try again.
10Which feature helps you extract data from a website table just by providing the URL?
A.Azure Blob Storage
B.Web Connector
C.JSON Connector
D.OData Feed
Correct Answer: Web Connector
Explanation:
The Web Connector allows you to input a URL, and Power BI will attempt to scrape HTML tables found on that page.
Incorrect! Try again.
11Which Data Profiling tool displays the percentage of Empty, Error, and Valid values in a column?
A.Column Profile
B.Column Distribution
C.Column Quality
D.Monospace
Correct Answer: Column Quality
Explanation:
Column Quality provides a quick visual summary of the validity of the data in the top 1,000 rows (or entire dataset) via a bar showing valid, error, and empty percentages.
Incorrect! Try again.
12What does 'Column Distribution' show in the View tab?
A.The statistical average
B.The applied steps
C.A frequency histogram and count of distinct/unique values
D.The data type of the column
Correct Answer: A frequency histogram and count of distinct/unique values
Explanation:
Column Distribution shows how values are distributed, including the count of distinct values (total different values) and unique values (values appearing only once).
Incorrect! Try again.
13If 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.Format -> Uppercase
B.Change Type -> Date
C.Split Column
D.Using Locale
Correct Answer: Using Locale
Explanation:
'Using Locale' allows you to specify the region (e.g., English (UK)) of the source data so Power BI understands how to interpret the date string correctly.
Incorrect! Try again.
14What is the result of using 'Unpivot Columns' on a dataset?
A.It turns selected columns into attribute-value pairs (rows)
B.It turns rows into columns
C.It aggregates data
D.It removes duplicate columns
Correct Answer: It turns selected columns into attribute-value pairs (rows)
Explanation:
Unpivoting converts a 'wide' table (many columns for similar attributes, like Jan, Feb, Mar) into a 'tall' table (Attribute and Value columns).
Incorrect! Try again.
15What is the purpose of an 'Index Column'?
A.To add a unique sequential number to each row
B.To group duplicate rows
C.To sort data alphabetically
D.To index the data for faster search
Correct Answer: To add a unique sequential number to each row
Explanation:
An Index Column generates a sequence of integers (starting from 0 or 1), effectively creating a unique row identifier.
Incorrect! Try again.
16Which tool allows you to create a new column based on 'If-Then-Else' logic without writing code?
A.Custom Column
B.Example Column
C.Conditional Column
D.Index Column
Correct Answer: Conditional Column
Explanation:
The Conditional Column dialog box provides a GUI to set up rules (If column X equals Y, then output Z) without writing M code manually.
Incorrect! Try again.
17You want to combine two tables by stacking them vertically (adding rows from one table to another). Which operation is this?
A.Transpose
B.Append Queries
C.Group By
D.Merge Queries
Correct Answer: Append Queries
Explanation:
Append Queries takes two tables with similar structures and stacks them to create a longer list of rows.
Incorrect! Try again.
18You want to combine two tables based on a common column (similar to a VLOOKUP or SQL JOIN). Which operation is this?
A.Merge Queries
B.Pivot Column
C.Transpose
D.Append Queries
Correct Answer: Merge Queries
Explanation:
Merge Queries joins two tables horizontally based on a matching key column.
Incorrect! Try again.
19In a 'Left Outer' join merge, what is the result?
A.All rows from both tables
B.Only matching rows from both tables
C.All rows from the second table and matching rows from the first
D.All rows from the first table and matching rows from the second
Correct Answer: All rows from the first table and matching rows from the second
Explanation:
Left Outer is the standard join type in Power BI, keeping everything from the primary (left) table and bringing in data from the secondary table where it matches.
Incorrect! Try again.
20What does the 'Fill Down' transformation do?
A.Copies the header to the first row
B.Fills null values with zero
C.Replaces null values with the value from the cell above
D.Removes empty rows
Correct Answer: Replaces null values with the value from the cell above
Explanation:
Fill Down is used when data has headers or categories only in the first row of a group; it propagates that value down to subsequent null cells.
Incorrect! Try again.
21How can you extract the domain name from an email address column in Power Query?
A.Unpivot
B.Change Type
C.Transpose
D.Split Column by Delimiter (@)
Correct Answer: Split Column by Delimiter (@)
Explanation:
Splitting by the '@' delimiter separates the username and the domain into two distinct columns.
Incorrect! Try again.
22Which transformation turns rows into columns (e.g., turning a column of 'Year' values into individual column headers)?
A.Pivot Column
B.Reverse Rows
C.Unpivot
D.Transpose
Correct Answer: Pivot Column
Explanation:
Pivot Column takes the unique values in a column and creates new columns for each value, aggregating the associated data.
Incorrect! Try again.
23What happens if you change the file location of your data source on your computer?
A.The query breaks and returns an error
B.Power BI automatically finds the new location
C.Power BI deletes the dataset
D.The data becomes static
Correct Answer: The query breaks and returns an error
Explanation:
Power BI relies on the specific file path defined in the query. If the file moves, the path must be updated in 'Data Source Settings'.
Incorrect! Try again.
24Where can you update the file path if a source file is moved?
A.Data Source Settings
B.Applied Steps
C.Advanced Editor
D.Manage Relationships
Correct Answer: Data Source Settings
Explanation:
Data Source Settings allows you to change the file path or credentials for existing connections globally for that file.
Incorrect! Try again.
25What does the 'Group By' feature do?
A.Sorts data into folders
B.Summarizes data at a higher level of granularity
C.Colors rows based on groups
D.Merges two tables
Correct Answer: Summarizes data at a higher level of granularity
Explanation:
Group By aggregates data based on selected category columns (e.g., grouping Sales by Region to get total sales per region).
Incorrect! Try again.
26Which of the following is NOT a valid aggregation in the 'Group By' window?
A.Count Rows
B.Average
C.Split
D.Sum
Correct Answer: Split
Explanation:
Split is a transformation, not an aggregation. Sum, Count, and Average are standard aggregations.
Incorrect! Try again.
27If you import a CSV and the headers appear as 'Column1', 'Column2' in the first row of data, what step should you apply?
A.Remove Top Rows
B.Transpose
C.Use First Row as Headers
D.Pivot
Correct Answer: Use First Row as Headers
Explanation:
This promotes the first row of data to become the actual column headers.
Incorrect! Try again.
28What is the purpose of 'Remove Top Rows'?
A.To sample the data
B.To filter out low sales
C.To delete the headers
D.To remove metadata or blank lines often found at the top of reports
Correct Answer: To remove metadata or blank lines often found at the top of reports
Explanation:
It is commonly used to clean up files that contain title rows or disclaimer text before the actual data table starts.
Incorrect! Try again.
29Which Date tool calculates the age of a record based on the current date?
A.Year
B.Month
C.Earliest
D.Age
Correct Answer: Age
Explanation:
The Age transformation calculates the duration between the date in the column and the current system date/time.
Incorrect! Try again.
30When extracting data from a web page, 'Add Table Using Examples' allows you to:
A.Define the data you want by typing sample values
B.Write HTML code
C.Download images
D.Hack the website
Correct Answer: Define the data you want by typing sample values
Explanation:
It uses AI to infer which parts of the webpage you want to extract based on a few examples you type manually.
Incorrect! Try again.
31What 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
Correct Answer: A new query that sources its data from the output of an existing query
Explanation:
Referencing creates a new query that depends on the original. If the original changes, the reference updates. It does not re-process the original steps.
Incorrect! Try again.
32What is the difference between 'Duplicate' and 'Reference' query?
A.Reference creates a static table
B.Reference copies the steps; Duplicate depends on output
C.Duplicate copies the steps; Reference depends on the original query's output
D.They are identical
Correct Answer: Duplicate copies the steps; Reference depends on the original query's output
Explanation:
Duplicate creates an independent copy with all the M code steps. Reference creates a dependency chain starting where the original left off.
Incorrect! Try again.
33Which numeric transformation would you use to find the remainder of a division operation?
A.Round
B.Absolute Value
C.Divide
D.Modulo
Correct Answer: Modulo
Explanation:
Modulo returns the remainder after dividing a number by a divisor.
Incorrect! Try again.
34To convert a column of values like 'USD 50', 'USD 100' into pure numbers, what is the best approach?
A.Replace 'USD ' with nothing, then Change Type
B.Change Type to Whole Number immediately
C.Format as Currency
D.Filter out USD
Correct Answer: Replace 'USD ' with nothing, then Change Type
Explanation:
You must remove the non-numeric text characters first before the column can be successfully converted to a numeric type.
Incorrect! Try again.
35What does the 'Transpose' function do?
A.Moves columns to the left
B.Sorts data
C.Deletes empty columns
D.Rotates the table 90 degrees (rows become columns)
Correct Answer: Rotates the table 90 degrees (rows become columns)
Explanation:
Transpose flips the table orientation so that rows become columns and columns become rows.
Incorrect! Try again.
36Which View tab option allows you to see the exact code generated by your transformations?
A.Advanced Editor
B.Parameters
C.Monospaced
D.Query Dependencies
Correct Answer: Advanced Editor
Explanation:
The Advanced Editor displays the full M script for the current query.
Incorrect! Try again.
37In 'Column Profile', what does 'Value Distribution' display?
A.The database source
B.A graph showing the frequency of specific values in the column
C.The column name
D.The count of errors
Correct Answer: A graph showing the frequency of specific values in the column
Explanation:
It provides a visual representation (bar chart) of how often each unique value appears in the column.
Incorrect! Try again.
38You 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.Split by Delimiter
C.Format -> Trim
D.Merge Columns
Correct Answer: Extract -> Text Between Delimiters
Explanation:
Extract Text Between Delimiters allows you to specify the start ('-') and end ('-') delimiters to pull out the middle content.
Incorrect! Try again.
39What is the primary benefit of 'Query Folding' in database connections?
A.It compresses the file size
B.It pushes transformation logic back to the source database for performance
C.It folds columns into rows
D.It creates folders for queries
Correct Answer: It pushes transformation logic back to the source database for performance
Explanation:
Query Folding translates Power Query steps into native SQL (or source language) so the processing happens on the server, not locally.
Incorrect! Try again.
40If a step in Power Query results in an 'Error' value in a cell, how can you handle it to prevent breaking the load?
A.Replace Errors
B.Filter the error
C.Ignore it
D.Delete the column
Correct Answer: Replace Errors
Explanation:
The 'Replace Errors' feature allows you to swap error values with a default value (like null or 0) to ensure the dataset loads successfully.
Incorrect! Try again.
41Which feature helps visualize the relationship and flow between different queries in Power Query?
A.Query Dependencies
B.Data Model
C.Lineage View
D.Relationship Manager
Correct Answer: Query Dependencies
Explanation:
The Query Dependencies view provides a visual diagram showing sources, queries, and referenced queries.
Incorrect! Try again.
42When merging queries, what happens if there are multiple matches for a row in the secondary table?
A.It returns an error
B.It creates duplicate rows in the primary table (Cartesian product)
C.It takes the first match only
D.It takes the last match only
Correct Answer: It creates duplicate rows in the primary table (Cartesian product)
Explanation:
A one-to-many join results in the row from the 'one' side being repeated for every match found in the 'many' side.
Incorrect! Try again.
43How do you combine three columns (Day, Month, Year) into a single Date column?
A.Pivot
B.Merge Columns
C.Split Column
D.Transpose
Correct Answer: Merge Columns
Explanation:
Merge Columns allows you to concatenate text from multiple columns into one, optionally using a separator.
Incorrect! Try again.
44Which numerical tool calculates the total of a column without using Group By?
A.Information -> Sign
B.Scientific -> Power
C.Statistics -> Sum
D.Standard -> Add
Correct Answer: Statistics -> Sum
Explanation:
Under the Transform tab, Statistics -> Sum calculates a single scalar value for the column (though usually, this is done via Group By for tables).
Incorrect! Try again.
45In Power Query, 'Disable Load' is used to:
A.Hide the query in the editor
B.Delete the query
C.Stop the query from being loaded into the Report/Data Model
D.Stop the query from refreshing
Correct Answer: Stop the query from being loaded into the Report/Data Model
Explanation:
Disable Load keeps the query in Power Query (often for use as a reference) but does not pull the data into the main Power BI memory model.
Incorrect! Try again.
46What does 'Close & Apply' do?
A.Saves the M code but does not load data
B.Closes Power Query Editor and loads the transformed data into the model
C.Deletes all steps
D.Closes Power BI Desktop
Correct Answer: Closes Power Query Editor and loads the transformed data into the model
Explanation:
This is the standard action to finish data preparation and return to the main Power BI interface to build reports.
Incorrect! Try again.
47Which option allows you to input data manually to create a small static table?
A.Recent Sources
B.DirectQuery
C.Enter Data
D.New Source -> Text
Correct Answer: Enter Data
Explanation:
The 'Enter Data' button opens a grid where you can type or paste small amounts of static data directly.
Incorrect! Try again.
48You want to create a column that says 'High' if Sales > 100 and 'Low' otherwise. You should use:
A.Conditional Column
B.Index Column
C.Split Column
D.Duplicate Column
Correct Answer: Conditional Column
Explanation:
This requires logic (If/Else), which is handled by the Conditional Column feature.
Incorrect! Try again.
49What is the file extension for a Power BI Template file?
A..xls
B..pbit
C..pbix
D..sql
Correct Answer: .pbit
Explanation:
.pbix is the standard file, while .pbit is a template file that contains report structure and queries but no data.
Incorrect! Try again.
50When using 'Date & Time' tools, what does 'Date Only' do?
A.Removes the time component from a DateTime column
B.Deletes the column
C.Extracts the year
D.Changes the time zone
Correct Answer: Removes the time component from a DateTime column
Explanation:
It transforms a Date/Time column to keep only the Date portion, effectively setting the time to midnight or removing it entirely from the data type.