Power BI UPDATED ACTUAL Exam
Questions and CORRECT Answers
As part of a large data project you want to create a dashboard using the Power BI Service. Data
will come from a variety of different sources. Do you know which of the following sources
would require a Power BI Enterprise Gateway? - CORRECT ANSWER - SQL Server
Analysis Services (on-premise)
With Power BI Publish to web, you can easily embed interactive Power BI visualizations online,
such as in blog posts, websites, through emails or social media, on any device.
You have published a visualization but unfortunately changes to the underlying data are not
immediately visible to users. What might be wrong? - CORRECT ANSWER - It takes up
to an hour for data to refresh
Information Functions (DAX) look at a table or column provided as an argument to another
function and tells you whether the value matches the expected type. What is the result of the
following DAX expression?
=IF(ISLOGICAL("true"), "Is Boolean type or Logical", "Is different type") - CORRECT
ANSWER - Is different type
Many data modeling and data transformations are available when using DirectQuery, though
with some limitations. Which of the following is NOT a limitation of using DirectQuery? -
CORRECT ANSWER - 1 GB dataset limitation
Always has two value axes to show one set of numerical data along a horizontal axis and another
set of numerical values along a vertical axis. The chart displays points at the intersection of an x
and y numerical value, combining these values into single data points. These data points may be
distributed evenly or unevenly across the horizontal axis, depending on the data. - CORRECT
ANSWER - Scatter Chart
Question 10 of 15
, Power BI Desktop comes with a large collection of different data connections, allowing you to
pull in data from a wide variety of sources. One particular category of data connection is Azure,
Microsoft's cloud computing platform.
Which of the following is NOT part of the Azure collection of data connections available in
Power BI desktop? - CORRECT ANSWER - Redshift
The DAX FORMAT function accepts a number of different format strings, some of which can be
constructed to create a custom formatter for your exact needs. Study the DAX expression below
and choose the right result:
FORMAT(-5, "$#,##0.00;($#,##0.00)") - CORRECT ANSWER - ($5.00)
You want to create a DAX formula that automatically calculates the previous month number. So
if the month was June then the formula would return 5. You have already created the DAX
formula below:
Today Month = MONTH (Sales[Todays Date])
Which of the DAX formulas below would be the right choice next? - CORRECT
ANSWER - Previous Month = IF (Sales[Today Month] =1, 12,Sales[Today Month]-1)
A complicated dashboard for the finance department requires you to combine three separate text
fields together to form a concatenation of Country, Region and City. Which DAX expression
below would successfully concatenate the three fields together into a single string result? -
CORRECT ANSWER - [Country] & ", " & [Region] & ", " & [City]
Question 15 of 15
Read the following paragraph carefully and decide whether the entire paragraph is TRUE or
FALSE?
Questions and CORRECT Answers
As part of a large data project you want to create a dashboard using the Power BI Service. Data
will come from a variety of different sources. Do you know which of the following sources
would require a Power BI Enterprise Gateway? - CORRECT ANSWER - SQL Server
Analysis Services (on-premise)
With Power BI Publish to web, you can easily embed interactive Power BI visualizations online,
such as in blog posts, websites, through emails or social media, on any device.
You have published a visualization but unfortunately changes to the underlying data are not
immediately visible to users. What might be wrong? - CORRECT ANSWER - It takes up
to an hour for data to refresh
Information Functions (DAX) look at a table or column provided as an argument to another
function and tells you whether the value matches the expected type. What is the result of the
following DAX expression?
=IF(ISLOGICAL("true"), "Is Boolean type or Logical", "Is different type") - CORRECT
ANSWER - Is different type
Many data modeling and data transformations are available when using DirectQuery, though
with some limitations. Which of the following is NOT a limitation of using DirectQuery? -
CORRECT ANSWER - 1 GB dataset limitation
Always has two value axes to show one set of numerical data along a horizontal axis and another
set of numerical values along a vertical axis. The chart displays points at the intersection of an x
and y numerical value, combining these values into single data points. These data points may be
distributed evenly or unevenly across the horizontal axis, depending on the data. - CORRECT
ANSWER - Scatter Chart
Question 10 of 15
, Power BI Desktop comes with a large collection of different data connections, allowing you to
pull in data from a wide variety of sources. One particular category of data connection is Azure,
Microsoft's cloud computing platform.
Which of the following is NOT part of the Azure collection of data connections available in
Power BI desktop? - CORRECT ANSWER - Redshift
The DAX FORMAT function accepts a number of different format strings, some of which can be
constructed to create a custom formatter for your exact needs. Study the DAX expression below
and choose the right result:
FORMAT(-5, "$#,##0.00;($#,##0.00)") - CORRECT ANSWER - ($5.00)
You want to create a DAX formula that automatically calculates the previous month number. So
if the month was June then the formula would return 5. You have already created the DAX
formula below:
Today Month = MONTH (Sales[Todays Date])
Which of the DAX formulas below would be the right choice next? - CORRECT
ANSWER - Previous Month = IF (Sales[Today Month] =1, 12,Sales[Today Month]-1)
A complicated dashboard for the finance department requires you to combine three separate text
fields together to form a concatenation of Country, Region and City. Which DAX expression
below would successfully concatenate the three fields together into a single string result? -
CORRECT ANSWER - [Country] & ", " & [Region] & ", " & [City]
Question 15 of 15
Read the following paragraph carefully and decide whether the entire paragraph is TRUE or
FALSE?
