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? 

It returns a year’s quarter as a number extracted from the Date column.Correct Answer

It creates a column from the Year column of the Date table.

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?

11Correct Answer

QUESTION 3 OF 58

What role did the RELATED function perform when you created the Yearly Sales calculated table? Select all that apply.

It referenced a column from the date table within the data model to retrieve the year information.Correct Answer

It referenced a column from the Sales table to retrieve the year information. 

It referenced a column from an unconnected table within the data model to retrieve the year information.

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.

Data typesCorrect Answer

SyntaxCorrect Answer

OperatorsCorrect Answer

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.

True

FalseCorrect Answer

QUESTION 6 OF 58

What is the purpose of using variables in DAX?

To temporarily store and reuse values within a DAX expression.Correct Answer

To create dynamic visualizations using DAX in Power BI.

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.

Calculated tables can only be created from a single data source.

Changes to the original data source will always be reflected in the cloned calculated tables.

Calculated tables combine data from different sources to facilitate deeper data analysis.Correct Answer

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?

It visualizes data in various formats such as charts and graphs.

It sorts and filters data based on user-defined criteria.

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.

Creating a column that flags high-value customers.Correct Answer

Calculating the average sales per region.Correct Answer

Filtering the data to display only this year’s sales.Correct Answer

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.

TrueCorrect Answer

False

QUESTION 11 OF 58

What is the purpose of the RELATED function in DAX?

To filter data based on specific criteria.

To retrieve data from a related table.Correct Answer

To establish relationships between tables.

QUESTION 12 OF 58

Why should you clone a table in Power BI for use as a calculated table?

To reduce the size of your data model.

To keep a backup of your original dataset.

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?

The visualization and charts created by DAX formulas.

The set of filters and context that influence DAX calculations.Correct Answer

The connection between Power BI and external data sources.

QUESTION 14 OF 58

Which of the following statements about the measures is correct?

Measures can reference columns directly.

Measures store values in the model.

Measures can reference other measures directly.Correct Answer

QUESTION 15 OF 58

Which DAX function can summarize the number of entries in a table?

SUM

COUNTROWSCorrect Answer

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.

TrueCorrect Answer

False

QUESTION 17 OF 58

Which of the following DAX functions modifies the evaluation context of a specific calculation? Select all that apply.

CALCULATETABLECorrect Answer

MEDIAN

DIVIDE

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.

AVERAGEX, CALCULATE

RELATED, FILTER

FILTER, CALCULATECorrect Answer

QUESTION 19 OF 58

Why are measures used in Power BI?

To filter and categorize data.

To perform calculations and aggregations.Correct Answer

To store descriptive attributes.

QUESTION 20 OF 58

Which of the following business dimensions can Adventure Works aggregate using additive measures?

Total revenueCorrect Answer

TimeCorrect Answer

Product categoryCorrect Answer

RegionCorrect Answer

QUESTION 21 OF 58

What is the COUNT function in DAX used for?

To count the number of non-blank cells in a column.

To count the number of rows in a column.Correct Answer

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.

TrueCorrect Answer

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?

The Order date column from the Sales table.

The Year column from the Date table.

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.

Access the feature from the drop-down menu using the ellipses under the Data pane.Correct Answer

Select the New measure option from the Model view of Power BI desktop.

Select the Quick Measure option from the Power BI Home tab.Correct Answer

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.

True

FalseCorrect Answer

QUESTION 26 OF 58

What is the benefit of creating quick measures in Power BI?

To accelerate the creation of calculations.Correct Answer

To facilitate the writing of DAX expressions.

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.

TrueCorrect Answer

False

QUESTION 28 OF 58

How can measures help with data analysis in Power BI?

By creating new tables and relationships between data tables in your models.

By performing calculations and aggregations for data visualization and analysis.Correct Answer

By combining data from various external data sources.

QUESTION 29 OF 58

In which scenario might the CROSSFILTER function be useful?

When establishing relationships within the tables.

When applying complex calculations within a measure.

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.

True

FalseCorrect Answer

QUESTION 31 OF 58

Which of the following are the DAX modifier functions? Select all that apply.

CROSSFILTERCorrect Answer

KEEPFILTERS (CORRECT

SUMX

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?

CALCULATECorrect Answer

SUMMARIZE

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.

TrueCorrect Answer

False

QUESTION 34 OF 58

Why might you want to override the default filter context?

To create new relationships between tables in the model.

To create measures that do not aggregate or average data.

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?

Create a calculated column in the Date table.

Clone the B table in DAX and name it Shipping date table.Correct Answer

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? 

To establish custom relationships between the Sales and the Date table.Correct Answer

To define default relationships between the Sales and Date table.

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?

TrueCorrect Answer

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?

Both Sales and Shipping data based on different perspectives without creating redundant structures.Correct Answer

Sales data related to origin location without creating redundant structures in the model.

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?

USERELATIONSHIP 

( TableName[ColumnName], TableName[ColumnName])Correct Answer

(ColumnName, TableName[ColumnName])

(TableName, ColumnName)

QUESTION 40 OF 58

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.

True

FalseCorrect Answer

QUESTION 41 OF 58

How can you use an inactive relationship in a single measure?

Use the USERELATIONSHIP function in DAX.Correct Answer

Change the active relationship in the modeling view of Power BI.

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?

It overrides the existing relationship state between tables.Correct Answer

It automatically generates relationships based on the column names.

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.

TrueCorrect Answer

False

QUESTION 44 OF 58

True or False: The CROSSFILTER function in DAX allows users to establish custom relationships between tables.

True

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.

You can delete the inactive relationship and use the Product dimension table for both analyses.

You can use the USERELATIONSHIP function.Correct Answer

You can use the CROSSFILTER function to get both analyses.

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.

Presence of calculated columns in the data model.

A date dimension table with a column of dates.Correct Answer

Properly defined relationships between the tables.Correct Answer

Data imported from multiple sources.

QUESTION 47 OF 58

What is the value of change in the sales measure (YoY%) for August 2018?

23.42%

-23.42%Correct Answer

-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?

TrueCorrect Answer

False

QUESTION 49 OF 58

What is the advantage of time intelligence in Power BI for businesses?

It enables businesses to create hierarchies based on date data for visualization.

It enables businesses to analyze data through real-time data processing.

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?

TOTALYTDCorrect Answer

CALCULATE

DATESBETWEEN

QUESTION 51 OF 58

True or False: The SAMEPERIODLASTYEAR function requires a separate Date dimension table.

True

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?

To enable the use of advanced data visualization techniques.

To create calculated columns and measures in the data model.

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.

Manual data entry

Data Analysis ExpressionsCorrect Answer

The Data modeling tab

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.

TrueCorrect Answer

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?

DATEADD

DATESYTDCorrect Answer

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.

DATEADDCorrect Answer

DATESINPERIODCorrect Answer

DATESBETWEENCorrect Answer

QUESTION 57 OF 58

True or False: The CALENDARAUTO function takes both the start and the end date from a dataset.

TrueCorrect Answer

False

QUESTION 58 OF 58

True or False: A data model must include a Date table to facilitate time intelligence functions.

True

FalseCorrect Answer

Ready to test your recall?

What does the DAX QUARTER function do when executed in the Date table? 

It returns a year’s quarter as a number extracted from the Date column.

It creates a column from the Year column of the Date table.

It converts the selected Date column data into a year’s quarter.

How confident are you in this answer?

Practice Quiz

What does the DAX QUARTER function do when executed in the Date table?&nbsp;

You have created a new table called Yearly Sales by Color. What is the total number of columns in the table?

What role did the RELATED function perform when you created the Yearly Sales calculated table? Select all that apply.

Identify the components of a data analysis expression. Select all that apply.

True or False: Filter context can only be applied to a calculation via writing a DAX expression.

What is the purpose of using variables in DAX?

Which of the following statements regarding calculated tables in Power BI and DAX are true? Select all that apply.

In Microsoft Power BI, what is the function of a calculated column?

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.

True or False: You can create a calculated table in DAX to generate a table based on the defined expression.

What is the purpose of the RELATED function in DAX?

Why should you clone a table in Power BI for use as a calculated table?

Regarding DAX, what does the term &#8220;evaluation context&#8221; refer to?

Which of the following statements about the measures is correct?

Which DAX function can summarize the number of entries in a table?

True or False: In DAX, a semi-additive measure can accumulate values over some dimension but typically not over time.

Which of the following DAX functions modifies the evaluation context of a specific calculation? Select all that apply.

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.

Why are measures used in Power BI?

Which of the following business dimensions can Adventure Works aggregate using additive measures?

What is the COUNT function in DAX used for?

True or False: The context in which your calculations are executed can give rise to variations in data.

In the exercise, you created a quick measure running total. Which of the following fields did you add as your base value?

What methods could you have used to access the Quick Measure feature in Power BI? Select all that apply.

True or False: You can use the SUM function instead of SUMX to calculate the Total Sales measure in DAX.

What is the benefit of creating quick measures in Power BI?

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.

How can measures help with data analysis in Power BI?

In which scenario might the CROSSFILTER function be useful?

True or False: Measures in Power BI are calculated columns that store results based on a specific DAX expression.

Which of the following are the DAX modifier functions? Select all that apply.

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?

True or False: The CROSSFILTER function can only be used with a DAX function that uses a filter as an argument.

Why might you want to override the default filter context?

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?

What was the purpose of the USERELATIONSHIP function in creating the August sales by shipping date measure for Adventure Works?&nbsp;

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?

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.

How can you use an inactive relationship in a single measure?

How does the USERELATIONSHIP function impact the relationship between tables in a data model?

True or False: Role-playing dimensions in Power BI are multiple instances of the same dimension used within a single fact table.

True or False: The CROSSFILTER function in DAX allows users to establish custom relationships between tables.

In Power BI, time intelligence DAX functions require which of the following to work properly? Select all that apply.

What is the value of change in the sales measure (YoY%) for August 2018?

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?

What is the advantage of time intelligence in Power BI for businesses?

Which DAX function is used to calculate running total over time?

True or False: The SAMEPERIODLASTYEAR function requires a separate Date dimension table.

Why is it important to have a properly defined date column in the data model to execute time intelligence functions?

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.

True or False: DAX time intelligence functions can be used with Power BI’s autogenerated date/time dimension.

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.

True or False: The CALENDARAUTO function takes both the start and the end date from a dataset.

True or False: A data model must include a Date table to facilitate time intelligence functions.

Ready to test your recall?

What does the DAX QUARTER function do when executed in the Date table?

Regarding DAX, what does the term “evaluation context” refer to?

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.

What was the purpose of the USERELATIONSHIP function in creating the August sales by shipping date measure for Adventure Works?