You have already completed the Test before. Hence you can not start it again.
Test is loading...
You must sign in or sign up to start the Test.
You have to finish following quiz, to start this Test:
Your results are here!! for" PL-300 Practice Test 8 "
0 of 55 questions answered correctly
Your time:
Time has elapsed
Your Final Score is : 0
You have attempted : 0
Number of Correct Questions : 0 and scored 0
Number of Incorrect Questions : 0 and Negative marks 0
Average score
Your score
PL-300
You have attempted: 0
Number of Correct Questions: 0 and scored 0
Number of Incorrect Questions: 0 and Negative marks 0
You can review your answers by clicking view questions. Important Note : Open Reference Documentation Links in New Tab (Right Click and Open in New Tab).
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
Answered
Review
Question 1 of 55
1. Question
Consider the Power BI model shown in the picture. The Product Table has a relationship to the Product Category Table on the SKU column.
Here, you can check a sample of data inside the tables:
Product Table:
SKU: HD-001, Product: GymSmartwatch, Color: Blue
SKU: HD-002, Product: XSound Headphones, Color: Black
SKU: HD-003, Product: Laptop Pro 2000, Color: Green
Product Category Table:
SKU: HD-001, Category: Smartwatch
SKU: HD-002, Category: Headphone
SKU: HD-003, Category: Computer
You need to use in your Power BI report a Hierarchy that shows two levels: product and category.
Solution: Create a DAX expression that uses CONCATENATEX function between the Product column and the Category column.
Does this solution meet the goal?
Correct
The right answer is:
NO.
The CONCATENATEX function concatenates the result of an expression evaluated for each row in a table. This function does not affect the Power BI hierarchy creation.
Incorrect
The right answer is:
NO.
The CONCATENATEX function concatenates the result of an expression evaluated for each row in a table. This function does not affect the Power BI hierarchy creation.
Unattempted
The right answer is:
NO.
The CONCATENATEX function concatenates the result of an expression evaluated for each row in a table. This function does not affect the Power BI hierarchy creation.
Question 2 of 55
2. Question
Your database contains the tables shown in the picture:
You plan to create a chart that displays total Enrollments[Total Paid] by Course[Name]. Before creating the visualization, you need to modify the model.
Which action should you perform? There are two right options.
Correct
Correct Options:
A. Create a relationship between the Enrollments table and the Courses table. Then, to the Enrollments table, add a column that uses the RELATED(‘Courses’[Course ID]) DAX formula.
Explanation: This option is correct because creating a relationship between the Enrollments and Courses tables allows you to link the data based on the common CourseID field. The RELATED function in DAX is used to fetch the related value from another table, which is essential for creating accurate visualizations that combine data from both tables.
C. To the Enrollments table, add a measure that uses the COUNTA(‘Enrollments’[Enrollment ID]) DAX formula.
Explanation: This option is also correct because adding a measure that counts the Enrollment ID will help in aggregating the total number of enrollments. The COUNTA function counts the number of non-blank rows in a column, which is useful for summarizing data in visualizations.
Incorrect Option:
B. To the Enrollments table, add a measure that uses the COUNTX(‘Enrollments’[Total Paid]) DAX formula.
Explanation: This option is incorrect because COUNTX is used to count rows in a table that meet a certain condition, but it is not appropriate for counting the Total Paid values directly. Instead, you would typically use a SUM or SUMX function to aggregate monetary values like Total Paid.
Incorrect
Correct Options:
A. Create a relationship between the Enrollments table and the Courses table. Then, to the Enrollments table, add a column that uses the RELATED(‘Courses’[Course ID]) DAX formula.
Explanation: This option is correct because creating a relationship between the Enrollments and Courses tables allows you to link the data based on the common CourseID field. The RELATED function in DAX is used to fetch the related value from another table, which is essential for creating accurate visualizations that combine data from both tables.
C. To the Enrollments table, add a measure that uses the COUNTA(‘Enrollments’[Enrollment ID]) DAX formula.
Explanation: This option is also correct because adding a measure that counts the Enrollment ID will help in aggregating the total number of enrollments. The COUNTA function counts the number of non-blank rows in a column, which is useful for summarizing data in visualizations.
Incorrect Option:
B. To the Enrollments table, add a measure that uses the COUNTX(‘Enrollments’[Total Paid]) DAX formula.
Explanation: This option is incorrect because COUNTX is used to count rows in a table that meet a certain condition, but it is not appropriate for counting the Total Paid values directly. Instead, you would typically use a SUM or SUMX function to aggregate monetary values like Total Paid.
Unattempted
Correct Options:
A. Create a relationship between the Enrollments table and the Courses table. Then, to the Enrollments table, add a column that uses the RELATED(‘Courses’[Course ID]) DAX formula.
Explanation: This option is correct because creating a relationship between the Enrollments and Courses tables allows you to link the data based on the common CourseID field. The RELATED function in DAX is used to fetch the related value from another table, which is essential for creating accurate visualizations that combine data from both tables.
C. To the Enrollments table, add a measure that uses the COUNTA(‘Enrollments’[Enrollment ID]) DAX formula.
Explanation: This option is also correct because adding a measure that counts the Enrollment ID will help in aggregating the total number of enrollments. The COUNTA function counts the number of non-blank rows in a column, which is useful for summarizing data in visualizations.
Incorrect Option:
B. To the Enrollments table, add a measure that uses the COUNTX(‘Enrollments’[Total Paid]) DAX formula.
Explanation: This option is incorrect because COUNTX is used to count rows in a table that meet a certain condition, but it is not appropriate for counting the Total Paid values directly. Instead, you would typically use a SUM or SUMX function to aggregate monetary values like Total Paid.
Question 3 of 55
3. Question
Suppose you have a Power BI model based on the following two tables:
– Enrollments (columns name: Enrollments_ID, Enrollments_amount, DateID)
– Date (columns name: DateID, Date, Month, Week, Year)
There is an active relationship between Enrollments and Date.
You want to create a measure to calculate the Enrollments for the same period from the previous year.
Select the right DAX formula.
Correct
The right answer is:
CALCULATE(SUM(Enrollments[Enrollments_amount]), SAMEPERIODLASTYEAR(‘Date'[Date]))
Check the SAMEPERIODLASTYEAR function here:
– https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax
Incorrect
The right answer is:
CALCULATE(SUM(Enrollments[Enrollments_amount]), SAMEPERIODLASTYEAR(‘Date'[Date]))
Check the SAMEPERIODLASTYEAR function here:
– https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax
Unattempted
The right answer is:
CALCULATE(SUM(Enrollments[Enrollments_amount]), SAMEPERIODLASTYEAR(‘Date'[Date]))
Check the SAMEPERIODLASTYEAR function here:
– https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax
Question 4 of 55
4. Question
Consider the following two tables:
– Sales (columns: SalesID, OrderDate, Salesman)
– Date (columns: Date, Month, Week, Year)
There is a relationship between Sales[OrderDate] and Date[Date].
Suppose you want to create a goal for the number of sales made in the current year and set it as 10% higher than the number of sales made in the previous year.
Select the proper order of the DAX functions to complete correctly the following formula:
Correct
The right answer is:
CALCULATE – COUNT – PREVIOUSYEAR
The COUNT function counts the number of cells in a column that contain non-blank values: the formula needs to CALCULATE the value of each SalesID target for the PREVIOUS YEAR and to multiply the extrapolated values for 1.10 to set the desired goal.
Check here the three functions:
– https://docs.microsoft.com/en-us/dax/calculate-function-dax
– https://docs.microsoft.com/en-us/dax/count-function-dax
– https://docs.microsoft.com/en-us/dax/previousyear-function-dax
Incorrect
The right answer is:
CALCULATE – COUNT – PREVIOUSYEAR
The COUNT function counts the number of cells in a column that contain non-blank values: the formula needs to CALCULATE the value of each SalesID target for the PREVIOUS YEAR and to multiply the extrapolated values for 1.10 to set the desired goal.
Check here the three functions:
– https://docs.microsoft.com/en-us/dax/calculate-function-dax
– https://docs.microsoft.com/en-us/dax/count-function-dax
– https://docs.microsoft.com/en-us/dax/previousyear-function-dax
Unattempted
The right answer is:
CALCULATE – COUNT – PREVIOUSYEAR
The COUNT function counts the number of cells in a column that contain non-blank values: the formula needs to CALCULATE the value of each SalesID target for the PREVIOUS YEAR and to multiply the extrapolated values for 1.10 to set the desired goal.
Check here the three functions:
– https://docs.microsoft.com/en-us/dax/calculate-function-dax
– https://docs.microsoft.com/en-us/dax/count-function-dax
– https://docs.microsoft.com/en-us/dax/previousyear-function-dax
Question 5 of 55
5. Question
You plan to create a DAX formula to filter the total enrollments of the 2019 year.
How should you complete the formula shown in the picture, in order to effectively use it apart from the other date filter set on the report page?
Correct
The right answer is:
ALL.
It is not possible to apply two date filter together. If you don’t use the ALL function properly, the DAX formula will return blank values when another date filter will be applied to the report.
Check how the DAX ALL function works here: https://docs.microsoft.com/en-us/dax/all-function-dax
Incorrect
The right answer is:
ALL.
It is not possible to apply two date filter together. If you don’t use the ALL function properly, the DAX formula will return blank values when another date filter will be applied to the report.
Check how the DAX ALL function works here: https://docs.microsoft.com/en-us/dax/all-function-dax
Unattempted
The right answer is:
ALL.
It is not possible to apply two date filter together. If you don’t use the ALL function properly, the DAX formula will return blank values when another date filter will be applied to the report.
Check how the DAX ALL function works here: https://docs.microsoft.com/en-us/dax/all-function-dax
Question 6 of 55
6. Question
Your database contains the tables shown in the picture: Check the information stored in the following columns:
– Date[Month] in the mmyyyy format
– Date[Date_ID] in the ddmmyyyy format
– Date[Date_name] in the mm/dd/yyyy format
– Monthly Drop out[Month_ID] in the mmyyyy format
The only relationship is between the Course table and the Monthly Drop Out table by the Course ID Column.
After you have imported the database in PowerBI, you need to calculate the number of enrollments.
Which option meets the goal?
Correct
The right answer is:
Create a calculated measure that uses the COUNTA(Enrollment ID) DAX formula.
As the question requires to calculate the whole number of Enrollment, you have to stick to a Filter context and not to a Row Context: that’s why you need to use a measure instead of a calculated measure.
The COUNTA function counts the number of cells in a column that are not empty: it allows you to aggregate in a count each no-empty cell of the Enrollment-ID columns.
The SUMX function is not the right option because is an aggregator used between two different columns of the same table.
Check the difference between COUNT and COUNTA here:
-https://docs.microsoft.com/en-us/dax/counta-function-dax
Incorrect
The right answer is:
Create a calculated measure that uses the COUNTA(Enrollment ID) DAX formula.
As the question requires to calculate the whole number of Enrollment, you have to stick to a Filter context and not to a Row Context: that’s why you need to use a measure instead of a calculated measure.
The COUNTA function counts the number of cells in a column that are not empty: it allows you to aggregate in a count each no-empty cell of the Enrollment-ID columns.
The SUMX function is not the right option because is an aggregator used between two different columns of the same table.
Check the difference between COUNT and COUNTA here:
-https://docs.microsoft.com/en-us/dax/counta-function-dax
Unattempted
The right answer is:
Create a calculated measure that uses the COUNTA(Enrollment ID) DAX formula.
As the question requires to calculate the whole number of Enrollment, you have to stick to a Filter context and not to a Row Context: that’s why you need to use a measure instead of a calculated measure.
The COUNTA function counts the number of cells in a column that are not empty: it allows you to aggregate in a count each no-empty cell of the Enrollment-ID columns.
The SUMX function is not the right option because is an aggregator used between two different columns of the same table.
Check the difference between COUNT and COUNTA here:
-https://docs.microsoft.com/en-us/dax/counta-function-dax
Question 7 of 55
7. Question
You plan to create a measure named YTDPreviousEnrollments that will be used in a table visualization. YTDPreviousEnrollments must show the year-to-date (YTD) enrollment amount of the previous year for the same month.
Check the picture for a sample of the desired data:
Select the proper order of DAX formula targets that calculate the YTDPreviousEnrollments.
Correct
The right answer is:
CALCULATE – DATEADD
Incorrect
The right answer is:
CALCULATE – DATEADD
Unattempted
The right answer is:
CALCULATE – DATEADD
Question 8 of 55
8. Question
Consider the table named Enrollments shown in the picture:
You need to create the following measure:
Total Enrollments This Year = SUM([Enrollments])
Suppose you want to compare the current yearly enrollments to the previous year by another measure.
Complete the following DAX formula with the right targets:
Correct
The right answer is:
CALCULATE + DATEADD
Check the DATEADD function Syntax here:
– https://docs.microsoft.com/en-us/dax/dateadd-function-dax
Incorrect
The right answer is:
CALCULATE + DATEADD
Check the DATEADD function Syntax here:
– https://docs.microsoft.com/en-us/dax/dateadd-function-dax
Unattempted
The right answer is:
CALCULATE + DATEADD
Check the DATEADD function Syntax here:
– https://docs.microsoft.com/en-us/dax/dateadd-function-dax
Question 9 of 55
9. Question
You have a Power BI model for sales data. You create a measure to calculate the year-to-date sales. You need to compare the year-to-date sales with the previous year for the same time period.
Which DAX function should you use?
Correct
The right answer is:
DATEADD
When you are asking to compare data along a period of time, the DATEADD function is the correct choice.
In this case, after you have created the measure that calculates the year-to-date sales with TOTALYTD, you need to compare those values with the previous year for the same time period. Using DATEADD, you can shift backward in time by 12 months from the dates in the current context.
Check the difference between the function features here:
– https://docs.microsoft.com/en-us/dax/dateadd-function-dax
– https://docs.microsoft.com/en-us/dax/totalytd-function-dax
– https://docs.microsoft.com/en-us/dax/datesytd-function-dax
Incorrect
The right answer is:
DATEADD
When you are asking to compare data along a period of time, the DATEADD function is the correct choice.
In this case, after you have created the measure that calculates the year-to-date sales with TOTALYTD, you need to compare those values with the previous year for the same time period. Using DATEADD, you can shift backward in time by 12 months from the dates in the current context.
Check the difference between the function features here:
– https://docs.microsoft.com/en-us/dax/dateadd-function-dax
– https://docs.microsoft.com/en-us/dax/totalytd-function-dax
– https://docs.microsoft.com/en-us/dax/datesytd-function-dax
Unattempted
The right answer is:
DATEADD
When you are asking to compare data along a period of time, the DATEADD function is the correct choice.
In this case, after you have created the measure that calculates the year-to-date sales with TOTALYTD, you need to compare those values with the previous year for the same time period. Using DATEADD, you can shift backward in time by 12 months from the dates in the current context.
Check the difference between the function features here:
– https://docs.microsoft.com/en-us/dax/dateadd-function-dax
– https://docs.microsoft.com/en-us/dax/totalytd-function-dax
– https://docs.microsoft.com/en-us/dax/datesytd-function-dax
Question 10 of 55
10. Question
Suppose you have a Power BI model based on the following two tables:
– Enrollments (columns: Enrollments_ID, Enrollments_date, Enrollments_amount, CourseID)
– Courses (columns: CourseID, Course_name)
There is an active relationship between Enrollments and Courses.
You want to create a measure to rank the courses based on their total enrollment amount.
Select the right DAX formula.
Correct
The right answer is:
RANKX(ALL(Courses), SUMX(RELATEDTABLE(Enrollments), [Enrollments_amount]))
The RANKX function returns a rank number of value among all possible values of expression evaluated for all rows of table numbers.
Check the RANKX function here:
– https://docs.microsoft.com/en-us/dax/rankx-function-dax
Incorrect
The right answer is:
RANKX(ALL(Courses), SUMX(RELATEDTABLE(Enrollments), [Enrollments_amount]))
The RANKX function returns a rank number of value among all possible values of expression evaluated for all rows of table numbers.
Check the RANKX function here:
– https://docs.microsoft.com/en-us/dax/rankx-function-dax
Unattempted
The right answer is:
RANKX(ALL(Courses), SUMX(RELATEDTABLE(Enrollments), [Enrollments_amount]))
The RANKX function returns a rank number of value among all possible values of expression evaluated for all rows of table numbers.
Check the RANKX function here:
– https://docs.microsoft.com/en-us/dax/rankx-function-dax
Question 11 of 55
11. Question
You have a Power BI model that contains two tables named Enrollments and Date. Enrollments table contains three columns named EnrollmentsAmount, EnrollmentDate and EnrollmentID. You want to create a measure to sum the last 12 months of enrollments.
Note: you have to start from the last date an enrollment was made and reject any filters set on the report.
Select the proper order of the DAX functions to complete correctly the following formula:
Correct
The right answer is:
DATEADD – LASTNONBLANK
Thanks to LASTNOTBLANK you can retrieve the last filled row date; then, with the DATEADD function, you can shift the evaluation 12 months back.
Check the two functions here:
– https://docs.microsoft.com/en-us/dax/dateadd-function-dax
– https://docs.microsoft.com/en-us/dax/lastnonblank-function-dax
Incorrect
The right answer is:
DATEADD – LASTNONBLANK
Thanks to LASTNOTBLANK you can retrieve the last filled row date; then, with the DATEADD function, you can shift the evaluation 12 months back.
Check the two functions here:
– https://docs.microsoft.com/en-us/dax/dateadd-function-dax
– https://docs.microsoft.com/en-us/dax/lastnonblank-function-dax
Unattempted
The right answer is:
DATEADD – LASTNONBLANK
Thanks to LASTNOTBLANK you can retrieve the last filled row date; then, with the DATEADD function, you can shift the evaluation 12 months back.
Check the two functions here:
– https://docs.microsoft.com/en-us/dax/dateadd-function-dax
– https://docs.microsoft.com/en-us/dax/lastnonblank-function-dax
Question 12 of 55
12. Question
You want to see the sum of the Sales[SalesAmount] for the Contoso brand by creating a new Quick Measure.
How you are supposed to set the following fields?
Correct
The right answer is:
Calculation: Filtered Value, Base Value: Sum of Sales Amount, Filter: BrandName, Select a value: Contoso
Quick measures are a powerful tool able to perform simple function without using DAX. There are many different available calculations: the windows guides you in shaping your measure accordingly to the calculation type you want to have. here is what happens with in the question scenario:
Discover more possibilities in the following link:
– https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quick-measures
Incorrect
The right answer is:
Calculation: Filtered Value, Base Value: Sum of Sales Amount, Filter: BrandName, Select a value: Contoso
Quick measures are a powerful tool able to perform simple function without using DAX. There are many different available calculations: the windows guides you in shaping your measure accordingly to the calculation type you want to have. here is what happens with in the question scenario:
Discover more possibilities in the following link:
– https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quick-measures
Unattempted
The right answer is:
Calculation: Filtered Value, Base Value: Sum of Sales Amount, Filter: BrandName, Select a value: Contoso
Quick measures are a powerful tool able to perform simple function without using DAX. There are many different available calculations: the windows guides you in shaping your measure accordingly to the calculation type you want to have. here is what happens with in the question scenario:
Discover more possibilities in the following link:
– https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quick-measures
Question 13 of 55
13. Question
Consider the table shown in the picture:
– Monthly Appointments[Month] is in the mmyyyy format;
– Monthly Appointments[Date_name] is in the mm/dd/yyyy format.
You plan to display the month as the following ‘jan2017’.
To meet the goal, you must add a calculated column. Select the proper order of the DAX functions to complete correctly the following formula:
Correct
The right answer is:
CONCATENATE – MMM
CONCATENATE joins two text strings into one text string: in this case, you are asked to join the month values in the MMM format (”Jan”) with the year ones in the YYYY format (”2017”).
While COMBINE function does not exist, check the difference between CONCATENATE and CONCATENATEX here:
– https://docs.microsoft.com/en-us/dax/concatenate-function-dax
– https://docs.microsoft.com/en-us/dax/concatenatex-function-dax
Incorrect
The right answer is:
CONCATENATE – MMM
CONCATENATE joins two text strings into one text string: in this case, you are asked to join the month values in the MMM format (”Jan”) with the year ones in the YYYY format (”2017”).
While COMBINE function does not exist, check the difference between CONCATENATE and CONCATENATEX here:
– https://docs.microsoft.com/en-us/dax/concatenate-function-dax
– https://docs.microsoft.com/en-us/dax/concatenatex-function-dax
Unattempted
The right answer is:
CONCATENATE – MMM
CONCATENATE joins two text strings into one text string: in this case, you are asked to join the month values in the MMM format (”Jan”) with the year ones in the YYYY format (”2017”).
While COMBINE function does not exist, check the difference between CONCATENATE and CONCATENATEX here:
– https://docs.microsoft.com/en-us/dax/concatenate-function-dax
– https://docs.microsoft.com/en-us/dax/concatenatex-function-dax
Question 14 of 55
14. Question
Consider the tables shown in the picture:
You need to create a new table that displays the top 5 Students by the total of attended courses.
Select the proper order of the DAX functions to complete correctly the following formula:
Correct
The right answer is:
CALCULATE – TOPN
The TOPN function returns, in fact, the top N rows of the specified table.
Check its syntax here:
– https://docs.microsoft.com/en-us/dax/topn-function-dax
Incorrect
The right answer is:
CALCULATE – TOPN
The TOPN function returns, in fact, the top N rows of the specified table.
Check its syntax here:
– https://docs.microsoft.com/en-us/dax/topn-function-dax
Unattempted
The right answer is:
CALCULATE – TOPN
The TOPN function returns, in fact, the top N rows of the specified table.
Check its syntax here:
– https://docs.microsoft.com/en-us/dax/topn-function-dax
Question 15 of 55
15. Question
Consider the table Product_Sales shown in picture 1:
You need to create a measure to rank total sales by product as shown in picture 2.
Which of the following DAX formulas should you use?
Correct
The right answer is:
RANKX(ALL(‘Product_Sales’), [SalesAmount],,DESC, Dense)
Check why you need to use DENSE instead of SKIP enumeration parameter here:
– https://docs.microsoft.com/en-us/dax/rankx-function-dax
Incorrect
The right answer is:
RANKX(ALL(‘Product_Sales’), [SalesAmount],,DESC, Dense)
Check why you need to use DENSE instead of SKIP enumeration parameter here:
– https://docs.microsoft.com/en-us/dax/rankx-function-dax
Unattempted
The right answer is:
RANKX(ALL(‘Product_Sales’), [SalesAmount],,DESC, Dense)
Check why you need to use DENSE instead of SKIP enumeration parameter here:
– https://docs.microsoft.com/en-us/dax/rankx-function-dax
Question 16 of 55
16. Question
You want to create a bar chart visualization to show the count of course enrollments by year that have an Enrollments Amount greater than 1,000. You need to create a measure that will be used in the bar chart visualization.
Select the proper order of the DAX functions to complete correctly the following formula:
Correct
The right answer is:
COUNTROWS-FILTER
The COUNTROWS function allows you to count the number of rows, then you filter every row with a value greater than 1,000.
Check how the COUNTROWS function works here:
– https://docs.microsoft.com/en-us/dax/countrows-function-dax
Incorrect
The right answer is:
COUNTROWS-FILTER
The COUNTROWS function allows you to count the number of rows, then you filter every row with a value greater than 1,000.
Check how the COUNTROWS function works here:
– https://docs.microsoft.com/en-us/dax/countrows-function-dax
Unattempted
The right answer is:
COUNTROWS-FILTER
The COUNTROWS function allows you to count the number of rows, then you filter every row with a value greater than 1,000.
Check how the COUNTROWS function works here:
– https://docs.microsoft.com/en-us/dax/countrows-function-dax
Question 17 of 55
17. Question
Consider a PowerBI model with two tables named Enrollments and Date. Enrollments contains five columns named Student ID, TotalPaid, EnrollmentDate, AttendanceDate, and StartingDate. Date Table contains only one column named Date.
The tables have the following relationships:
– Enrollments[EnrollmentDate] and Date[Date]
– Enrollments[AttendanceDate] and Date[Date]
– Enrollments[StartingDate] and Date[Date]
The active relationship is on Enrollments[EnrollmentDate] .You plan to create measures to count both the number of Enrollments by [AttendanceDate] and the Enrollments by [StartingDate].
NOTE: You can’t meet the goal by duplicating data or loading additional data.
Solution: You create measures that use the CALCULATE, COUNT, and USERELATIONSHIP DAX functions.
Does this solution resolve the issue?
Correct
The right answer is:
Yes
USERELATIONSHIP specifies the relationship to be used in a specific calculation between two columns. Even if the relationship is inactive, it will be used and overrides any other active relationships that might be present in the model but not mentioned in the function arguments.
For more, check here:
– https://docs.microsoft.com/en-us/dax/userelationship-function-dax
Incorrect
The right answer is:
Yes
USERELATIONSHIP specifies the relationship to be used in a specific calculation between two columns. Even if the relationship is inactive, it will be used and overrides any other active relationships that might be present in the model but not mentioned in the function arguments.
For more, check here:
– https://docs.microsoft.com/en-us/dax/userelationship-function-dax
Unattempted
The right answer is:
Yes
USERELATIONSHIP specifies the relationship to be used in a specific calculation between two columns. Even if the relationship is inactive, it will be used and overrides any other active relationships that might be present in the model but not mentioned in the function arguments.
For more, check here:
– https://docs.microsoft.com/en-us/dax/userelationship-function-dax
Question 18 of 55
18. Question
Consider you want to add a date table named Date to your Power BI model. That table will contain the following columns: date, year, month and it has to include the following date range:
from 1st January 2018 to 31st December 2019.
Select the right DAX functions that must be included in the formula.
Correct
The right answer is:
CALENDAR, YEAR, MONTH
CALENDAR: This function is used to generate a table containing a single column of dates within a specified range.
The first argument (DATE(2018,1,1)) defines the start date of the range (January 1st, 2018).
The second argument (DATE(2019,12,31)) defines the end date of the range (December 31st, 2019).
YEAR: This function extracts the year from the date in the “Date” column generated by the CALENDAR function.
MONTH: This function extracts the month number (1-12) from the date in the “Date” column generated by the CALENDAR function.
Note: The comma (“,”) separates the functions used to create additional columns based on the existing “Date” column.
Here’s why the other options are not suitable:
CALENDAR, DATE: This would only create a single-column table with dates. It wouldn’t include year and month columns.
CALENDARAUTO, YEAR, MONTH: CALENDARAUTO automatically determines the date range based on existing data in your model. Since you’re explicitly defining the range, CALENDAR is preferred in this case.
Check the difference with CALENDARAUTO here:
– https://docs.microsoft.com/en-us/power-bi/guidance/model-date-tables
Incorrect
The right answer is:
CALENDAR, YEAR, MONTH
CALENDAR: This function is used to generate a table containing a single column of dates within a specified range.
The first argument (DATE(2018,1,1)) defines the start date of the range (January 1st, 2018).
The second argument (DATE(2019,12,31)) defines the end date of the range (December 31st, 2019).
YEAR: This function extracts the year from the date in the “Date” column generated by the CALENDAR function.
MONTH: This function extracts the month number (1-12) from the date in the “Date” column generated by the CALENDAR function.
Note: The comma (“,”) separates the functions used to create additional columns based on the existing “Date” column.
Here’s why the other options are not suitable:
CALENDAR, DATE: This would only create a single-column table with dates. It wouldn’t include year and month columns.
CALENDARAUTO, YEAR, MONTH: CALENDARAUTO automatically determines the date range based on existing data in your model. Since you’re explicitly defining the range, CALENDAR is preferred in this case.
Check the difference with CALENDARAUTO here:
– https://docs.microsoft.com/en-us/power-bi/guidance/model-date-tables
Unattempted
The right answer is:
CALENDAR, YEAR, MONTH
CALENDAR: This function is used to generate a table containing a single column of dates within a specified range.
The first argument (DATE(2018,1,1)) defines the start date of the range (January 1st, 2018).
The second argument (DATE(2019,12,31)) defines the end date of the range (December 31st, 2019).
YEAR: This function extracts the year from the date in the “Date” column generated by the CALENDAR function.
MONTH: This function extracts the month number (1-12) from the date in the “Date” column generated by the CALENDAR function.
Note: The comma (“,”) separates the functions used to create additional columns based on the existing “Date” column.
Here’s why the other options are not suitable:
CALENDAR, DATE: This would only create a single-column table with dates. It wouldn’t include year and month columns.
CALENDARAUTO, YEAR, MONTH: CALENDARAUTO automatically determines the date range based on existing data in your model. Since you’re explicitly defining the range, CALENDAR is preferred in this case.
Check the difference with CALENDARAUTO here:
– https://docs.microsoft.com/en-us/power-bi/guidance/model-date-tables
Question 19 of 55
19. Question
You are creating appointment schedules for your clients. Consider the following data from a query named Appointments:
You need to visualize the data as shown in the following picture by using a matrix visualization:
Select the proper order of DAX formula targets which allows you to create the measure that will display the checkboxes.
Correct
The right answer is:
COUNTROWS-UNICHAR
Check how COUNTROWS and UNICHAR can work together here:
– https://blog.crossjoin.co.uk/2017/04/11/the-dax-unichar-function-and-how-to-use-it-in-measures-for-data-visualisation/
Incorrect
The right answer is:
COUNTROWS-UNICHAR
Check how COUNTROWS and UNICHAR can work together here:
– https://blog.crossjoin.co.uk/2017/04/11/the-dax-unichar-function-and-how-to-use-it-in-measures-for-data-visualisation/
Unattempted
The right answer is:
COUNTROWS-UNICHAR
Check how COUNTROWS and UNICHAR can work together here:
– https://blog.crossjoin.co.uk/2017/04/11/the-dax-unichar-function-and-how-to-use-it-in-measures-for-data-visualisation/
Question 20 of 55
20. Question
Consider the following sample data:
You want to create a calculated column to display the date in the following format: January 01, 2020.
Select the right DAX formula.
Correct
The right answer is:
FORMAT([Date], “MMMM DD, YYYY”)
“MMMM” is a user-defined date/time format that shows the month as a full month name.
Check the full custom date and time formats list for the FORMAT function here:
– https://docs.microsoft.com/en-us/dax/custom-date-and-time-formats-for-the-format-function
Incorrect
The right answer is:
FORMAT([Date], “MMMM DD, YYYY”)
“MMMM” is a user-defined date/time format that shows the month as a full month name.
Check the full custom date and time formats list for the FORMAT function here:
– https://docs.microsoft.com/en-us/dax/custom-date-and-time-formats-for-the-format-function
Unattempted
The right answer is:
FORMAT([Date], “MMMM DD, YYYY”)
“MMMM” is a user-defined date/time format that shows the month as a full month name.
Check the full custom date and time formats list for the FORMAT function here:
– https://docs.microsoft.com/en-us/dax/custom-date-and-time-formats-for-the-format-function
Question 21 of 55
21. Question
You are modeling data by using Microsoft Power Bl. Part of the data model is a large Microsoft SQL Server table named [Fact Internet Sales] that has more than 500 million records. During the development process, you need to import a sample of the data from the [Fact Internet Sales] table.
Solution: You write a DAX expression that uses the FILTER function.
Does this meet the goal?
Correct
FILTER is a DAX function, we usually write DAX function to get some calculatable column, Calculated measure and calculated table to enrich our data model.
FILTER returns a table that represents a subset of another table or expressions https://docs.microsoft.com/en-us/dax/filter-function-dax
Incorrect
FILTER is a DAX function, we usually write DAX function to get some calculatable column, Calculated measure and calculated table to enrich our data model.
FILTER returns a table that represents a subset of another table or expressions https://docs.microsoft.com/en-us/dax/filter-function-dax
Unattempted
FILTER is a DAX function, we usually write DAX function to get some calculatable column, Calculated measure and calculated table to enrich our data model.
FILTER returns a table that represents a subset of another table or expressions https://docs.microsoft.com/en-us/dax/filter-function-dax
Question 22 of 55
22. Question
You are modeling data by using Microsoft Power Bl. Part of the data model is a large Microsoft SQL Server table named [Fact Internet Sales] that has more than 500 million records. During the development process, you need to import a sample of the data from the [Fact Internet Sales] table.
Solution: You add a report-level filter that filters based on the [Fact Internet Sales] date.
Does this meet the goal?
You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:
*First name
*Last name
*Email address
*State
*Region
*Phone number
You import the list into Power Query Editor.
You need to ensure that the list contains records for each State to which you want to target a marketing campaign.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Correct
The correct answer is: C. Enable Column profiling based on entire dataset and D. Select Column distribution.
Here’s why each option is correct or incorrect:
C. Enable Column profiling based on entire dataset:
This option is correct because it allows you to analyze the entire dataset for the “State” column, providing insights into the distribution of values and identifying any missing or incomplete data.
D. Select Column distribution:
This option is also correct because it specifically focuses on the distribution of values within the “State” column, helping you to understand the frequency of each state and identify any states that might be missing from your list.
A. Open the Advanced Editor:
This option is incorrect because while it can be used for advanced transformations, it’s not directly relevant to the task of ensuring that the list contains records for each desired state.
B. Select Column quality:
This option is incorrect because it’s a general option for checking data quality, but it doesn’t provide specific information about the distribution of values within the “State” column.
E. Select Column profile:
This option is incorrect because it’s a general option for profiling columns, but it doesn’t specifically focus on the distribution of values within the “State” column.
Incorrect
The correct answer is: C. Enable Column profiling based on entire dataset and D. Select Column distribution.
Here’s why each option is correct or incorrect:
C. Enable Column profiling based on entire dataset:
This option is correct because it allows you to analyze the entire dataset for the “State” column, providing insights into the distribution of values and identifying any missing or incomplete data.
D. Select Column distribution:
This option is also correct because it specifically focuses on the distribution of values within the “State” column, helping you to understand the frequency of each state and identify any states that might be missing from your list.
A. Open the Advanced Editor:
This option is incorrect because while it can be used for advanced transformations, it’s not directly relevant to the task of ensuring that the list contains records for each desired state.
B. Select Column quality:
This option is incorrect because it’s a general option for checking data quality, but it doesn’t provide specific information about the distribution of values within the “State” column.
E. Select Column profile:
This option is incorrect because it’s a general option for profiling columns, but it doesn’t specifically focus on the distribution of values within the “State” column.
Unattempted
The correct answer is: C. Enable Column profiling based on entire dataset and D. Select Column distribution.
Here’s why each option is correct or incorrect:
C. Enable Column profiling based on entire dataset:
This option is correct because it allows you to analyze the entire dataset for the “State” column, providing insights into the distribution of values and identifying any missing or incomplete data.
D. Select Column distribution:
This option is also correct because it specifically focuses on the distribution of values within the “State” column, helping you to understand the frequency of each state and identify any states that might be missing from your list.
A. Open the Advanced Editor:
This option is incorrect because while it can be used for advanced transformations, it’s not directly relevant to the task of ensuring that the list contains records for each desired state.
B. Select Column quality:
This option is incorrect because it’s a general option for checking data quality, but it doesn’t provide specific information about the distribution of values within the “State” column.
E. Select Column profile:
This option is incorrect because it’s a general option for profiling columns, but it doesn’t specifically focus on the distribution of values within the “State” column.
Question 24 of 55
24. Question
You have the dataset shown below
You need to ensure that the visual shows only the 5 cities that have the highest sales profit.
What should you do?
You are creating an analytics report that will consume data from the tables shown in the following table.
There is a relationship between the tables. There are no reporting requirements on [emp_id] and [employee_photo]. You need to optimize the data model. What should you configure for [emp_id] and [employee_photo] column?
You have a line chart that shows the number of employees in a department over time. You need to see the total salary costs of the employees when you hover over a data point.
You have a table that contains sales data and approximately 1,500 rows. You need to identify outliers in the table. Which type of visualization should you use?
You create the following step by using Power Query Editor = Table.ReplaceValue(SalesLT_Address,”1318″,”1319″,Replacer.ReplaceText,{“AddressLine1”}) A row has a value of 21318 Lasalle Street in the AddressLine1 column. What will the value be when the step is applied?
You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2019-12-31 at 09:59. You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.
What should you do?
Correct
Use power query and apply split transformation on Logged column.
-Change the data type of the Logged column to Date – Wrong (as it will throw error because of “at” word is specified)
-Apply a transform to extract the last 11 characters of the Logged column and set the data type of the new column to Date- Wrong (From last 11 character you will not get data as 2019-12-31)
-Use Split by delimiter option to split date and time by providing “at” delimiter-Wrong (As we need to set the data type of Logged column as date otherwise we will not able to create hierarchy)
-Create a column by example that starts with 2019-12-31 and set the data type of the new column to Date -Correct
-Use Split by delimiter option to split date and time by providing “at” delimiter.- Wrong (As we need to set the data type of Logged column as date otherwise we will not able to create hierarchy) https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/ https://www.exceljetconsult.com.ng/home/blog/power-query-split-date-and-time-into-separate-columns/
Incorrect
Use power query and apply split transformation on Logged column.
-Change the data type of the Logged column to Date – Wrong (as it will throw error because of “at” word is specified)
-Apply a transform to extract the last 11 characters of the Logged column and set the data type of the new column to Date- Wrong (From last 11 character you will not get data as 2019-12-31)
-Use Split by delimiter option to split date and time by providing “at” delimiter-Wrong (As we need to set the data type of Logged column as date otherwise we will not able to create hierarchy)
-Create a column by example that starts with 2019-12-31 and set the data type of the new column to Date -Correct
-Use Split by delimiter option to split date and time by providing “at” delimiter.- Wrong (As we need to set the data type of Logged column as date otherwise we will not able to create hierarchy) https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/ https://www.exceljetconsult.com.ng/home/blog/power-query-split-date-and-time-into-separate-columns/
Unattempted
Use power query and apply split transformation on Logged column.
-Change the data type of the Logged column to Date – Wrong (as it will throw error because of “at” word is specified)
-Apply a transform to extract the last 11 characters of the Logged column and set the data type of the new column to Date- Wrong (From last 11 character you will not get data as 2019-12-31)
-Use Split by delimiter option to split date and time by providing “at” delimiter-Wrong (As we need to set the data type of Logged column as date otherwise we will not able to create hierarchy)
-Create a column by example that starts with 2019-12-31 and set the data type of the new column to Date -Correct
-Use Split by delimiter option to split date and time by providing “at” delimiter.- Wrong (As we need to set the data type of Logged column as date otherwise we will not able to create hierarchy) https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/ https://www.exceljetconsult.com.ng/home/blog/power-query-split-date-and-time-into-separate-columns/
Question 32 of 55
32. Question
You have a Microsoft Power Bl report. The size of the PBIX file is 1024 MB. The report is accessed by using an App workspace is a shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 09:00 and 18:00. The report is a single page that contains 15 custom visuals and 10 default visuals. Users say that the report is slow to load the visuals when they access and interact with the report You need to recommend a solution to improve the performance of the report. What should you recommend?
You are developing a report page. Some users will navigate the report by using a keyboard, and some users will consume the report by using a screen reader. You need to ensure that the users can consume the content on a report page in a logical order.
What should you configure in Microsoft Power BI Desktop?
What does the decomposition tree not enable you to do?
Correct
The decomposition tree does not enable you to conduct what-if analysis with built-in parameters.
Here’s a breakdown of what each option does:
Conduct root cause analysis to understand a measure better: The decomposition tree breaks down a measure into its constituent parts, helping you identify the key drivers that contribute to its value.
Automatically analyze selected dimensions to find where a measure is highest or lowest: The decomposition tree can be used to identify the dimensions that have the most significant impact on a measure, allowing you to pinpoint where the measure is highest or lowest.
Conduct what-if analysis with built-in parameters: While the decomposition tree can provide insights into the relationships between different variables, it does not have built-in capabilities for conducting what-if analysis, which involves simulating changes to variables and observing the resulting impact on the measure. For this type of analysis, you would typically need to use other tools or techniques.
The decomposition tree does not enable you to conduct what-if analysis with built-in parameters.
Here’s a breakdown of what each option does:
Conduct root cause analysis to understand a measure better: The decomposition tree breaks down a measure into its constituent parts, helping you identify the key drivers that contribute to its value.
Automatically analyze selected dimensions to find where a measure is highest or lowest: The decomposition tree can be used to identify the dimensions that have the most significant impact on a measure, allowing you to pinpoint where the measure is highest or lowest.
Conduct what-if analysis with built-in parameters: While the decomposition tree can provide insights into the relationships between different variables, it does not have built-in capabilities for conducting what-if analysis, which involves simulating changes to variables and observing the resulting impact on the measure. For this type of analysis, you would typically need to use other tools or techniques.
The decomposition tree does not enable you to conduct what-if analysis with built-in parameters.
Here’s a breakdown of what each option does:
Conduct root cause analysis to understand a measure better: The decomposition tree breaks down a measure into its constituent parts, helping you identify the key drivers that contribute to its value.
Automatically analyze selected dimensions to find where a measure is highest or lowest: The decomposition tree can be used to identify the dimensions that have the most significant impact on a measure, allowing you to pinpoint where the measure is highest or lowest.
Conduct what-if analysis with built-in parameters: While the decomposition tree can provide insights into the relationships between different variables, it does not have built-in capabilities for conducting what-if analysis, which involves simulating changes to variables and observing the resulting impact on the measure. For this type of analysis, you would typically need to use other tools or techniques.
You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer segment. The column chart shows sales by month. You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month belongs to the customer segment.
How should the visual interactions be set on the column chart when the bar chart is selected?
Data alerts can be set only in Power BI service on specific visuals. You can set alert on Dashboards on specific visuals
Incorrect
Data alerts can be set only in Power BI service on specific visuals. You can set alert on Dashboards on specific visuals
Unattempted
Data alerts can be set only in Power BI service on specific visuals. You can set alert on Dashboards on specific visuals
Question 38 of 55
38. Question
Your company has training videos that are published to Microsoft Stream. You need to surface the videos directly in a Microsoft Power BI dashboard. Which type of tile should you add?
Correct
correct answer web content
Web content tiles allow you to embed content from external websites directly into your dashboard.
Microsoft Stream provides an embed code for each video, which you can easily paste into the web content tile’s URL field.
This will allow you to display the videos directly within your dashboard, making them easily accessible to your users.
Other options like video or custom streaming data are not suitable for this specific scenario, as they are primarily used for different types of data visualization.
Incorrect
correct answer web content
Web content tiles allow you to embed content from external websites directly into your dashboard.
Microsoft Stream provides an embed code for each video, which you can easily paste into the web content tile’s URL field.
This will allow you to display the videos directly within your dashboard, making them easily accessible to your users.
Other options like video or custom streaming data are not suitable for this specific scenario, as they are primarily used for different types of data visualization.
Unattempted
correct answer web content
Web content tiles allow you to embed content from external websites directly into your dashboard.
Microsoft Stream provides an embed code for each video, which you can easily paste into the web content tile’s URL field.
This will allow you to display the videos directly within your dashboard, making them easily accessible to your users.
Other options like video or custom streaming data are not suitable for this specific scenario, as they are primarily used for different types of data visualization.
Question 39 of 55
39. Question
Is it possible to create a relationship between two columns if they are different DATA TYPE columns?
Correct
No, both columns in a relationship must be sharing same data type
Incorrect
No, both columns in a relationship must be sharing same data type
Unattempted
No, both columns in a relationship must be sharing same data type
Question 40 of 55
40. Question
You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned. You build a report analyzing the internal networks of employees based on whom they send emails. You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.
What should you do?
Correct
By removing the columns like Subject and Body during import can help to reduce the size of model.
Incorrect
By removing the columns like Subject and Body during import can help to reduce the size of model.
Unattempted
By removing the columns like Subject and Body during import can help to reduce the size of model.
Question 41 of 55
41. Question
You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product. The Sales table contains purchase and ship dates. Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.
You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source.
Which data modeling design should you use?
You are creating a visual to show the ranking of product categories by sales revenue. Your company’s security policy states that you cannot send data outside of your Microsoft Power Bl tenant Which approach provides the widest variety of visuals while adhering to the security policy?
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as a numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create an average line by using the Salary measure.
Does this meet the goal?
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as a numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create a percentile line by using the Salary measure and set the percentile to 50%.
Does this meet the goal?
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as a numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create a constant line and set the value to .5.
Does this meet the goal?
You are modeling data by using Microsoft Power Bl. Part of the data model is a large Microsoft SQL Server table named [Fact Internet Sales] that has more than 500 million records. During the development process, you need to import a sample of the data from the [Fact Internet Sales] table.
Solution: You add a WHERE clause to the SQL statement.
Does this meet the goal?
If you have two queries that have different data, but you want to concatenate the results into one query with all the combined rows. Which operation should you perform?
Correct
A. Append Correct: The Append operation in Power BI is specifically designed to combine the rows of two or more queries into a single query. This is similar to a SQL UNION operation, where the results from both queries are stacked vertically. For the append operation to work, the queries must have the same number of columns and compatible data types, but they can contain different data. Therefore, if you want to concatenate the results of two queries with different data, using Append is the correct approach.
B. Merge Incorrect: The Merge operation combines two or more queries by matching values in specified columns, similar to a SQL JOIN operation. This means that it requires at least one common column between the tables to perform the merge based on matching criteria. Since the question specifies that you want to concatenate results (not match them), Merge is not suitable for this requirement.
C. Combine columns Incorrect: The term “Combine columns” typically refers to operations that involve merging or concatenating values within a single row across multiple columns rather than combining entire rows from multiple queries. This does not apply to the scenario of concatenating results from two separate queries into one query.
A. Append Correct: The Append operation in Power BI is specifically designed to combine the rows of two or more queries into a single query. This is similar to a SQL UNION operation, where the results from both queries are stacked vertically. For the append operation to work, the queries must have the same number of columns and compatible data types, but they can contain different data. Therefore, if you want to concatenate the results of two queries with different data, using Append is the correct approach.
B. Merge Incorrect: The Merge operation combines two or more queries by matching values in specified columns, similar to a SQL JOIN operation. This means that it requires at least one common column between the tables to perform the merge based on matching criteria. Since the question specifies that you want to concatenate results (not match them), Merge is not suitable for this requirement.
C. Combine columns Incorrect: The term “Combine columns” typically refers to operations that involve merging or concatenating values within a single row across multiple columns rather than combining entire rows from multiple queries. This does not apply to the scenario of concatenating results from two separate queries into one query.
A. Append Correct: The Append operation in Power BI is specifically designed to combine the rows of two or more queries into a single query. This is similar to a SQL UNION operation, where the results from both queries are stacked vertically. For the append operation to work, the queries must have the same number of columns and compatible data types, but they can contain different data. Therefore, if you want to concatenate the results of two queries with different data, using Append is the correct approach.
B. Merge Incorrect: The Merge operation combines two or more queries by matching values in specified columns, similar to a SQL JOIN operation. This means that it requires at least one common column between the tables to perform the merge based on matching criteria. Since the question specifies that you want to concatenate results (not match them), Merge is not suitable for this requirement.
C. Combine columns Incorrect: The term “Combine columns” typically refers to operations that involve merging or concatenating values within a single row across multiple columns rather than combining entire rows from multiple queries. This does not apply to the scenario of concatenating results from two separate queries into one query.
You’re creating a Power BI report with data from an Azure Analysis Services Cube. When the data refreshes in the cube, you would like to see it immediately in the Power BI report. How should you connect?
Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power Bl. You need to recommend an application lifecycle strategy. The solution must minimize maintenance to update access and prevent end-users from viewing the development assets.
What should you recommend?
You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions. You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions. What should you recommend?
You have the following three versions of an Azure SQL database:
* Test
* Production
* Development
You have a dataset that uses the development database as a data source. You need to configure the dataset so that you can easily change the data source between the development, test, and production database servers from powerbi.com.
What will you do?
You have worked hard to create a clean dataset of all your companys customer details, including address and geocode. The Senior Director in your division has asked that all people within your company are aware of the high-quality, authoritative customer dataset that meets all the companys standards. How can you achieve this goal?
Correct
Certification means that the content meets the companys quality standards and is regarded as reliable, authoritative, and ready for use across the organization. Only authorized reviewers (defined by the Power BI administrator) can certify content. Do not select promote content. Promotion is a way to highlight content you think is valuable and worthwhile for others to use. It encourages the collaborative use and spread of content within an organization. Promotion is not used for authorative, reliable data sources. Do not select Feature content on home. When you feature dashboards, reports, and apps they appear in the Featured section of your colleagues‘ Power BI Home page. Do not create a new workspace and add every person as a member. This will give your entire company the ability to edit your dataset and reports within the workspace.
Incorrect
Certification means that the content meets the companys quality standards and is regarded as reliable, authoritative, and ready for use across the organization. Only authorized reviewers (defined by the Power BI administrator) can certify content. Do not select promote content. Promotion is a way to highlight content you think is valuable and worthwhile for others to use. It encourages the collaborative use and spread of content within an organization. Promotion is not used for authorative, reliable data sources. Do not select Feature content on home. When you feature dashboards, reports, and apps they appear in the Featured section of your colleagues‘ Power BI Home page. Do not create a new workspace and add every person as a member. This will give your entire company the ability to edit your dataset and reports within the workspace.
Unattempted
Certification means that the content meets the companys quality standards and is regarded as reliable, authoritative, and ready for use across the organization. Only authorized reviewers (defined by the Power BI administrator) can certify content. Do not select promote content. Promotion is a way to highlight content you think is valuable and worthwhile for others to use. It encourages the collaborative use and spread of content within an organization. Promotion is not used for authorative, reliable data sources. Do not select Feature content on home. When you feature dashboards, reports, and apps they appear in the Featured section of your colleagues‘ Power BI Home page. Do not create a new workspace and add every person as a member. This will give your entire company the ability to edit your dataset and reports within the workspace.
Question 55 of 55
55. Question
You create several Power Bl report pages.
You need to make the report pages more interactive for users.
To answer, drag the appropriate Power Bl feature for the stated requirement.
“Share feedback on visuals with other users”
Correct
You can use the Comments feature to be added to the report page and to visuals on a page. Comments are added by users to provide feedback or bring other users’ attention to a visual and are available in the Power Bl service.
Incorrect
You can use the Comments feature to be added to the report page and to visuals on a page. Comments are added by users to provide feedback or bring other users’ attention to a visual and are available in the Power Bl service.
Unattempted
You can use the Comments feature to be added to the report page and to visuals on a page. Comments are added by users to provide feedback or bring other users’ attention to a visual and are available in the Power Bl service.
X
Use Page numbers below to navigate to other practice tests