Coursera Microsoft Power BI Data Analyst • STUDY MODE
Practice Quiz
QUESTION 1 OF 32
You are formatting the column properties of your data tables within your data model. In which section of Properties can you change the data type of the column?
A
FormattingCorrect Answer
B
General
C
Advanced
QUESTION 2 OF 32
How many table storage modes does Microsoft Power BI Desktop support?
A
3Correct Answer
B
1
C
4
QUESTION 3 OF 32
True or False: The DAX CALENDAR function automatically detects the data range of your dataset and creates a calculated date column
A
True
B
FalseCorrect Answer
QUESTION 4 OF 32
Which of the following components of Microsoft Power BI allow you to add a description about your table? Select all that apply.
A
Report view
B
Model viewCorrect Answer
C
Power Query EditorCorrect Answer
D
Data view
QUESTION 5 OF 32
True or False: If your data model does not contain a date table, you will not be able to perform time intelligence calculations using DAX.
A
True
B
FalseCorrect Answer
QUESTION 6 OF 32
Which language can you use to create a common date table in Microsoft Power BI? Select all that apply.
A
DAXCorrect Answer
B
PythonCorrect Answer
C
MCorrect Answer
D
C++
QUESTION 7 OF 32
True or False: You can only manage the relationships between data tables in the Model view of Power BI Desktop?
A
True
B
FalseCorrect Answer
QUESTION 8 OF 32
True or False: To activate multiple inactive relationships within your data model, you need to write separate DAX code using the USERELATIONSHIP function in Power BI.
A
True
B
FalseCorrect Answer
QUESTION 9 OF 32
Which of the following elements of a DAX formula is optional while writing a CALCULATE expression?
A
Column Name
B
Table Name
C
FilterCorrect Answer
QUESTION 10 OF 32
With a many-to-many relationship, how many options for cross-filter direction do you have?
A
One
B
ThreeCorrect Answer
C
Two
QUESTION 11 OF 32
Adventure Works’ US sales manager wants insights into the sales of a few states, and she asked you to present the sales and profit for California and Arizona only. What DAX functions can you use to compute the measures? Select all that apply.
A
FILTERCorrect Answer
B
CALCULATECorrect Answer
C
SUM
D
SUMXCorrect Answer
QUESTION 12 OF 32
The profit margin is an example of a/an _____________ measure.
A
Additive
B
Semi-additive
C
Non-additiveCorrect Answer
QUESTION 13 OF 32
You are handling a semi-additive measure in Microsoft Power BI. What DAX functions are useful in managing a semi-additive measure? Select all that apply.
A
DATEADD
B
FIRSTDATECorrect Answer
C
LASTNONBLANKCorrect Answer
D
CALCULATECorrect Answer
QUESTION 14 OF 32
Adventure Works wants a visualization displaying the opening balance of its products in stock for each month. Which DAX function is most suitable to use in computing your measure?
A
LASTDATE
B
FIRSTNONBLANKCorrect Answer
C
FIRSTDATE
QUESTION 15 OF 32
True or False: In Microsoft Power BI, you do not need to write DAX script to visualize implicit measures on the report canvas
A
TrueCorrect Answer
B
False
QUESTION 16 OF 32
True or False: In Microsoft Power BI you can create a calculated column using DAX in the Power Query Editor.
A
True
B
FalseCorrect Answer
QUESTION 17 OF 32
Which statement about measures in Microsoft Power BI is correct?
A
Measures can only be created using DAX.
B
Measures can be referenced by other measures.Correct Answer
C
Measures are stored in the data model.
D
Measures are stored information in the data model.
QUESTION 18 OF 32
Which DAX function can be used to compute the sales values between two specified dates?
A
DATESBETWEENCorrect Answer
B
DATESINPERIOD
C
DATEADD
D
DATESYTD
QUESTION 19 OF 32
Which DAX function helps you to handle semi-additive measures?
A
LASTDATECorrect Answer
B
DIVIDE
C
AVERAGE
D
SUMX
QUESTION 20 OF 32
What is the maximum number of levels you can create in a hierarchy in Microsoft Power BI?
A
4
B
5Correct Answer
C
3
QUESTION 21 OF 32
How can you create a data hierarchy in Microsoft Power BI? Select all that apply.
A
Creating a new hierarchy and adding fields to the hierarchyCorrect Answer
B
By using the Power Query editor
C
By adding fields to the visual axis well By using DAXCorrect Answer
QUESTION 22 OF 32
True or False: In Microsoft Power BI, you can only create calculated tables using DAX.
A
True
B
FalseCorrect Answer
QUESTION 23 OF 32
Microsoft Power BI’s Q&A visual lets users ask user-defined questions about the data. To help them swiftly analyze information and draw insights, what features of the Q&A visual can you configure? Select all that apply.
A
RelationshipsCorrect Answer
B
Teach Q&ACorrect Answer
C
Visual formatting
D
SynonymsCorrect Answer
QUESTION 24 OF 32
True or False: When you write your question in the Q&A visual text box, Microsoft Power BI provides you with autocomplete suggestions. Can you modify the suggestions that appear in the Q&A visual?
A
TrueCorrect Answer
B
False
QUESTION 25 OF 32
In addition to using DAX to create calculated tables, what is an alternative way to create calculated tables without using any external tool?
A
Python
B
M languageCorrect Answer
C
SQL
QUESTION 26 OF 32
Adventure Works received two separate tables representing the color of its various products. For seamless analysis and optimizing the data model, you only need a single table for colors. Which DAX table function can you use to combine data from two tables?
A
SUMMARIZE
B
ADDCOLUMNS
C
UNIONCorrect Answer
QUESTION 27 OF 32
Which of the following DAX functions is important when working with hierarchical data?
A
UNION
B
PATHCorrect Answer
C
ADDCOLUMNS
D
SUMMARIZE
QUESTION 28 OF 32
You have Sales and Cost columns in your data table. The data type of the columns is set to Text. Which Microsoft Power BI element allows you to update the data types of the columns to Currency? Select all that apply
A
Report viewCorrect Answer
B
Data viewCorrect Answer
C
Model viewCorrect Answer
D
Query EditorCorrect Answer
QUESTION 29 OF 32
How does the Performance Analyzer assist in analyzing user interactions in Microsoft Power BI reports?
A
By capturing the impact of user interactions on report elements.Correct Answer
B
By suggesting a better visual to use in the report.
C
By recommending the alteration in data refresh frequency.
QUESTION 30 OF 32
What is the primary benefit of correctly categorizing the location-based columns of your data model in Microsoft Power BI?
A
To eliminate data redundancy
B
To enable accurate geographical analysis and mappingCorrect Answer
C
To enhance the visual appearance of map visuals
QUESTION 31 OF 32
What type of insights does the Performance Analyzer provide? Select all that apply.
A
Information about field parameters.Correct Answer
B
Information about the visual rendering time.Correct Answer
C
Information about DAX query execution.Correct Answer
D
Information about the columns used from the Data mode.
QUESTION 32 OF 32
Which of the following data types would offer the optimal performance, reducing cardinality, for a currency field?
A
Text
B
Decimal Number
C
Fixed Decimal NumberCorrect Answer
D
Google Advanced Data Analytics
E
Google Cybersecurity Professional Certificate
F
Meta Marketing Analytics Professional Certificate
G
Google Digital Marketing & E-commerce Professional Certificate
H
Google UX Design Professional Certificate
I
Meta Social Media Marketing Professional Certificate
J
Google Project Management Professional Certificate
K
Meta Front-End Developer Professional Certificate
Ready to test your recall?
You are formatting the column properties of your data tables within your data model. In which section of Properties can you change the data type of the column?