Coursera Microsoft Power BI Data Analyst • STUDY MODE
Practice Quiz
QUESTION 1 OF 58
What does the DAX QUARTER function do when executed in the Date table?
A
It returns a year’s quarter as a number extracted from the Date column.Correct Answer
B
It creates a column from the Year column of the Date table.
C
It converts the selected Date column data into a year’s quarter.
QUESTION 2 OF 58
You have created a new table called Yearly Sales by Color. What is the total number of columns in the table?
A
11Correct Answer
B
12
C
9
QUESTION 3 OF 58
What role did the RELATED function perform when you created the Yearly Sales calculated table? Select all that apply.
A
It referenced a column from the date table within the data model to retrieve the year information.Correct Answer
B
It referenced a column from the Sales table to retrieve the year information.
C
It referenced a column from an unconnected table within the data model to retrieve the year information.
D
It referenced a column from the product table within the data model to retrieve the color information.Correct Answer
QUESTION 4 OF 58
Identify the components of a data analysis expression. Select all that apply.
A
Data typesCorrect Answer
B
SyntaxCorrect Answer
C
OperatorsCorrect Answer
D
Column and table referencesCorrect Answer
QUESTION 5 OF 58
True or False: Filter context can only be applied to a calculation via writing a DAX expression.
A
True
B
FalseCorrect Answer
QUESTION 6 OF 58
What is the purpose of using variables in DAX?
A
To temporarily store and reuse values within a DAX expression.Correct Answer
B
To create dynamic visualizations using DAX in Power BI.
C
To store the values permanently within the data model.
QUESTION 7 OF 58
Which of the following statements regarding calculated tables in Power BI and DAX are true? Select all that apply.
A
Calculated tables can only be created from a single data source.
B
Changes to the original data source will always be reflected in the cloned calculated tables.
C
Calculated tables combine data from different sources to facilitate deeper data analysis.Correct Answer
D
Calculated tables are created within Power BI using DAX expressions.Correct Answer
QUESTION 8 OF 58
In Microsoft Power BI, what is the function of a calculated column?
A
It visualizes data in various formats such as charts and graphs.
B
It sorts and filters data based on user-defined criteria.
C
It performs calculations on data using a DAX formula.Correct Answer
QUESTION 9 OF 58
You are a data analyst working with a large sales dataset for an e-commerce company. You are employing Power BI as an analytical tool. In which of the following scenarios would it be beneficial to use DAX functions? Select all that apply.
A
Creating a column that flags high-value customers.Correct Answer
B
Calculating the average sales per region.Correct Answer
C
Filtering the data to display only this year’s sales.Correct Answer
D
Importing a new sales dataset.
QUESTION 10 OF 58
True or False: You can create a calculated table in DAX to generate a table based on the defined expression.
A
TrueCorrect Answer
B
False
QUESTION 11 OF 58
What is the purpose of the RELATED function in DAX?
A
To filter data based on specific criteria.
B
To retrieve data from a related table.Correct Answer
C
To establish relationships between tables.
QUESTION 12 OF 58
Why should you clone a table in Power BI for use as a calculated table?
A
To reduce the size of your data model.
B
To keep a backup of your original dataset.
C
To perform calculations that are not possible on the original dataset.Correct Answer
QUESTION 13 OF 58
Regarding DAX, what does the term “evaluation context” refer to?
A
The visualization and charts created by DAX formulas.
B
The set of filters and context that influence DAX calculations.Correct Answer
C
The connection between Power BI and external data sources.
QUESTION 14 OF 58
Which of the following statements about the measures is correct?
A
Measures can reference columns directly.
B
Measures store values in the model.
C
Measures can reference other measures directly.Correct Answer
QUESTION 15 OF 58
Which DAX function can summarize the number of entries in a table?
A
SUM
B
COUNTROWSCorrect Answer
C
AVERAGE
QUESTION 16 OF 58
True or False: In DAX, a semi-additive measure can accumulate values over some dimension but typically not over time.
A
TrueCorrect Answer
B
False
QUESTION 17 OF 58
Which of the following DAX functions modifies the evaluation context of a specific calculation? Select all that apply.
A
CALCULATETABLECorrect Answer
B
MEDIAN
C
DIVIDE
D
CALCULATECorrect Answer
QUESTION 18 OF 58
You want to calculate the total revenue for each product category in an Adventure Works sales dataset, but only for products over $1000. You can use the ___________ function to narrow down the products with a specified amount. You can then use the ____________ function to compute the final measure.
A
AVERAGEX, CALCULATE
B
RELATED, FILTER
C
FILTER, CALCULATECorrect Answer
QUESTION 19 OF 58
Why are measures used in Power BI?
A
To filter and categorize data.
B
To perform calculations and aggregations.Correct Answer
C
To store descriptive attributes.
QUESTION 20 OF 58
Which of the following business dimensions can Adventure Works aggregate using additive measures?
A
Total revenueCorrect Answer
B
TimeCorrect Answer
C
Product categoryCorrect Answer
D
RegionCorrect Answer
QUESTION 21 OF 58
What is the COUNT function in DAX used for?
A
To count the number of non-blank cells in a column.
B
To count the number of rows in a column.Correct Answer
C
To count the number of distinct values in a column.
QUESTION 22 OF 58
True or False: The context in which your calculations are executed can give rise to variations in data.
A
TrueCorrect Answer
B
False
QUESTION 23 OF 58
In the exercise, you created a quick measure running total. Which of the following fields did you add as your base value?
A
The Order date column from the Sales table.
B
The Year column from the Date table.
C
The Total Sales column from the Sales table.Correct Answer
QUESTION 24 OF 58
What methods could you have used to access the Quick Measure feature in Power BI? Select all that apply.
A
Access the feature from the drop-down menu using the ellipses under the Data pane.Correct Answer
B
Select the New measure option from the Model view of Power BI desktop.
C
Select the Quick Measure option from the Power BI Home tab.Correct Answer
D
Access the feature through Power Query editor.
QUESTION 25 OF 58
True or False: You can use the SUM function instead of SUMX to calculate the Total Sales measure in DAX.
A
True
B
FalseCorrect Answer
QUESTION 26 OF 58
What is the benefit of creating quick measures in Power BI?
A
To accelerate the creation of calculations.Correct Answer
B
To facilitate the writing of DAX expressions.
C
To eliminate the need for data modeling.
QUESTION 27 OF 58
True or False: When creating a measure in DAX, you need to establish active relationships between the tables within your dataset to make sure you obtain accurate results for your analysis.
A
TrueCorrect Answer
B
False
QUESTION 28 OF 58
How can measures help with data analysis in Power BI?
A
By creating new tables and relationships between data tables in your models.
B
By performing calculations and aggregations for data visualization and analysis.Correct Answer
C
By combining data from various external data sources.
QUESTION 29 OF 58
In which scenario might the CROSSFILTER function be useful?
A
When establishing relationships within the tables.
B
When applying complex calculations within a measure.
C
When creating visualizations with custom filtering behavior.Correct Answer
QUESTION 30 OF 58
True or False: Measures in Power BI are calculated columns that store results based on a specific DAX expression.
A
True
B
FalseCorrect Answer
QUESTION 31 OF 58
Which of the following are the DAX modifier functions? Select all that apply.
A
CROSSFILTERCorrect Answer
B
KEEPFILTERS (CORRECT
C
SUMX
D
FILTER
QUESTION 32 OF 58
You are analyzing a data model comprised of a Customers and an Orders tables. You want to analyze the number of customer orders from a specific region. Which of the following functions, combined with CROSSFILTER, can you use to generate these insights?
A
CALCULATECorrect Answer
B
SUMMARIZE
C
COUNTROWS
QUESTION 33 OF 58
True or False: The CROSSFILTER function can only be used with a DAX function that uses a filter as an argument.
A
TrueCorrect Answer
B
False
QUESTION 34 OF 58
Why might you want to override the default filter context?
A
To create new relationships between tables in the model.
B
To create measures that do not aggregate or average data.
C
To create measures that behave according to your intent.Correct Answer
QUESTION 35 OF 58
You added the date table as a role-playing dimension to analyze the August sales. What alternative method could you have used to perform the same analysis in Power BI?
A
Create a calculated column in the Date table.
B
Clone the B table in DAX and name it Shipping date table.Correct Answer
C
Create a calculated table by extracting data from the Sales and Date tables.
QUESTION 36 OF 58
What was the purpose of the USERELATIONSHIP function in creating the August sales by shipping date measure for Adventure Works?
A
To establish custom relationships between the Sales and the Date table.Correct Answer
B
To define default relationships between the Sales and Date table.
C
To filter the data based on specific conditions.
QUESTION 37 OF 58
True or False: In your Adventure Works data model, the default relationship between the Sales and Date tables is based on the order date. Could you make this relationship inactive? You can convert the default relationship between the sales and date table to inactive relationship in Power BI for a specific calculation?
A
TrueCorrect Answer
B
False
QUESTION 38 OF 58
Adventure Works’ data model includes a Location dimension table. This table is used twice. Once as the origin location, and again as the destination location. This design allows the company to analyze which of the following dimensions effectively?
A
Both Sales and Shipping data based on different perspectives without creating redundant structures.Correct Answer
B
Sales data related to origin location without creating redundant structures in the model.
C
Sales data based on destination location without creating redundant structures in the model.
QUESTION 39 OF 58
Which of the following best represents the syntax of the USERELATIONSHIP function in DAX?
True or False: The USERELATIONSHIP function in DAX establishes custom relationships between the tables in a data model, even if a relationship does not already exist between the tables.
A
True
B
FalseCorrect Answer
QUESTION 41 OF 58
How can you use an inactive relationship in a single measure?
A
Use the USERELATIONSHIP function in DAX.Correct Answer
B
Change the active relationship in the modeling view of Power BI.
C
Delete one relationship from the modeling tab of Power BI.
QUESTION 42 OF 58
How does the USERELATIONSHIP function impact the relationship between tables in a data model?
A
It overrides the existing relationship state between tables.Correct Answer
B
It automatically generates relationships based on the column names.
C
It creates a new relationship between tables.
QUESTION 43 OF 58
True or False: Role-playing dimensions in Power BI are multiple instances of the same dimension used within a single fact table.
A
TrueCorrect Answer
B
False
QUESTION 44 OF 58
True or False: The CROSSFILTER function in DAX allows users to establish custom relationships between tables.
A
True
B
FalseCorrect Answer
QUESTION 45 OF 58
An e-commerce company has a data model with an inactive relationship between the Product table and the Sales table. The active relationship is based on the Products sold column of the Product table, while the inactive relationship is based on the Products purchased column. You want to analyze sales data based on both Products sold and Products purchased. What are the possible solutions to analyze the data? Select all that apply.
A
You can delete the inactive relationship and use the Product dimension table for both analyses.
B
You can use the USERELATIONSHIP function.Correct Answer
C
You can use the CROSSFILTER function to get both analyses.
D
You create a separate calculated table based on the Product table and rename it as Products Purchased.Correct Answer
QUESTION 46 OF 58
In Power BI, time intelligence DAX functions require which of the following to work properly? Select all that apply.
A
Presence of calculated columns in the data model.
B
A date dimension table with a column of dates.Correct Answer
C
Properly defined relationships between the tables.Correct Answer
D
Data imported from multiple sources.
QUESTION 47 OF 58
What is the value of change in the sales measure (YoY%) for August 2018?
A
23.42%
B
-23.42%Correct Answer
C
-2.9%
QUESTION 48 OF 58
True or False: To calculate the Sales previous year measure in DAX, you used the Revenue measure for your calculation. Is it possible to create the Sales previous year measure without using the Revenue measure?
A
TrueCorrect Answer
B
False
QUESTION 49 OF 58
What is the advantage of time intelligence in Power BI for businesses?
A
It enables businesses to create hierarchies based on date data for visualization.
B
It enables businesses to analyze data through real-time data processing.
C
It enables businesses to analyze data based on time-related dimensions.Correct Answer
QUESTION 50 OF 58
Which DAX function is used to calculate running total over time?
A
TOTALYTDCorrect Answer
B
CALCULATE
C
DATESBETWEEN
QUESTION 51 OF 58
True or False: The SAMEPERIODLASTYEAR function requires a separate Date dimension table.
A
True
B
FalseCorrect Answer
QUESTION 52 OF 58
Why is it important to have a properly defined date column in the data model to execute time intelligence functions?
A
To enable the use of advanced data visualization techniques.
B
To create calculated columns and measures in the data model.
C
To ensure data accuracy and consistency in time-based calculations.Correct Answer
QUESTION 53 OF 58
Which of the following features of Power BI can you use to add a date or common-dimension table to the data model? Select all that apply.
A
Manual data entry
B
Data Analysis ExpressionsCorrect Answer
C
The Data modeling tab
D
Power Query and M languageCorrect Answer
QUESTION 54 OF 58
True or False: DAX time intelligence functions can be used with Power BI’s autogenerated date/time dimension.
A
TrueCorrect Answer
B
False
QUESTION 55 OF 58
You are tasked with evaluating a company’s year-to-date sales. You need to analyze YTD (year-to-date) values by integrating additional filter context to the calculations like the Product category, Region, and Reseller datasets. Which of the following DAX functions can you use to complete this task?
A
DATEADD
B
DATESYTDCorrect Answer
C
TOTALYTD
QUESTION 56 OF 58
A business recently launched a marketing campaign for its product line and wants to determine its impact on sales within a specific period. What time intelligence function can you employ to evaluate the campaign’s impact on sales? Select all that apply.
A
DATEADDCorrect Answer
B
DATESINPERIODCorrect Answer
C
DATESBETWEENCorrect Answer
QUESTION 57 OF 58
True or False: The CALENDARAUTO function takes both the start and the end date from a dataset.
A
TrueCorrect Answer
B
False
QUESTION 58 OF 58
True or False: A data model must include a Date table to facilitate time intelligence functions.
A
True
B
FalseCorrect Answer
Ready to test your recall?
What does the DAX QUARTER function do when executed in the Date table?
A
It returns a year’s quarter as a number extracted from the Date column.
B
It creates a column from the Year column of the Date table.
C
It converts the selected Date column data into a year’s quarter.