Optimizing DAX Workshop  SelfAssessment for Prerequisites to attend the course
Quizsummary
0 of 10 questions completed
Questions:
 1
 2
 3
 4
 5
 6
 7
 8
 9
 10
Information
This selfassessment has the goal to check whether you have the right prerequisites to attend the Optimizing DAX Workshop in a proficient way. The course is an intensive one and in order to get the maximum from the 2 days, it is important to know the DAX language very well. In particular, the test check your knowledge of evaluation context, context transition, and DAX functions that are commonly used.
If you do not have a good confidence of DAX, you might be unable to get the most from the Optimizing course. Depending on your final score, the final message will give you a suggestion to prepare for the Optimizing DAX Workshop, such as topics to study, books, videos, and other courses.
In any case, you will be your first judge, especially if you do not feel yourself confident answering to the questions of this test. We suggest you to answer “I don’t know, I’m not sure” when you are not able to choose an answer.
Read the following questions carefully and find the correct answer from the options provided. We do not provide a suggested time time to answer each question. You should look at the answers and select the one you believe is correct – this is more important than speed. Take the time you need to get the answer correct, but don’t waste time once you have the answer you will choose. Some questions are just more difficult, and will naturally take longer to answer.
You can access the Internet and other documentation during the test if you like. The goal is to measure your understanding of DAX concepts that are fundamental in performance analysis and optimization. It is not a goal of the test to measure your knowledge of the syntax of DAX measures, so it is ok if you read the documentation of a function to check the position of a certain argument.
Remember: don’t cheat yourself!
You can fill the form in an Anonymous way, or you can leave us your email. We will not disclose the result of your test, guaranteed!
You must specify a text. 

You must specify an email address. 
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
Time has elapsed
0 0 0
Categories
 Not categorized 0%

Sorry, but Optimizing DAX Workshop is too advanced for you.
You should start studying DAX from the groundup. Your score is below 20%, so attending the Optimizing DAX would not be useful to you by now.
You can start learning DAX by enjoying our free video course Introducing DAX. After making practice with DAX, you can attend the Mastering DAX and then the Optimizing DAX courses. 
You have a basic knowledge of DAX, we strongly suggest to improve your DAX skills before attending the Optimizing DAX Workshop.
Your score is below 75%, which is the suggested level to attend the Optimizing DAX course.
You should attend the Mastering DAX Workshop before joining the Optimizing DAX course, 
You have a medium knowledge of DAX, but we suggest to improve your DAX skills before attending the Optimizing DAX Workshop.
Your score is below 75%, which is the suggested level to attend the Optimizing DAX course.
You should consider attending the Mastering DAX Workshop before joining the Optimizing DAX course. 
You have a good knowledge of DAX and attending the Optimizing DAX will be useful for you!
Your score is above 75%, which is the suggested level to attend the Optimizing DAX course.
Just review the topics where you were not sure in your answers and start the workshop in good shape! 
You are a DAX master and you will enjoy attending the Optimzing DAX.
It seems you know the DAX language very well: it is easy to predict that you will have a lot of fun optimizing your DAX measures.
 1
 2
 3
 4
 5
 6
 7
 8
 9
 10
 Answered
 Review

Question 1 of 10
1. Question
Consider the following expressions that apply a filter on one column only:
Total Sales of Red Products:= CALCULATE ( [SalesAmount], Product[Color] = "Red" ) Total Sales of SQLBI Branded Products:= CALCULATE ( [SalesAmount], Product[Brand] = "SQLBI" )
Which of the following DAX formulas returns the value of SalesAmount for all the products with “SQLBI” brand or color “Red” while not altering filters in other columns?
In other words, how do you write an OR statement between two columns with CALCULATE? 
Question 2 of 10
2. Question
There are 6 DAX expressions listed below.
Two of these expressions return the same result if used in a measure filtered by different colors, whereas the other four return different results.
Select the two items below that return the same result regardless of the color selected. 
Question 3 of 10
3. Question
Consider a data model with two tables: Customers and Sales:
 The Customers table has 500 rows
 The Sales table has 2,000 rows (all rows have a valid customer key)
 There are no active relationships between the Customers table and the Sales table
You have these measures in the data model:
Transactions := COUNTROWS ( Sales ) Result := SUMX ( Customers, [Transactions] )
What is the value of the measure “Result” when it is otherwise unfiltered?

Question 4 of 10
4. Question
Consider the scenario where you have the following data model:
 There are three tables: Sales, Product, and Customer.
 The Customer table includes a City column.
 There are two active relationships from Sales to both Product and Customer.
You have a report with a slicer that filters the Product table.
You need a measure “Total number of Cities” computing the total number of cities where there is at least one customer who bought at least one of the products filtered by the slicer.
Select the two correct answers among the following measures. 
Question 5 of 10
5. Question
The following measure should compute the Quantity On Hand, cumulating the Quantity value until the last visible date.
Unfortunately, it produces wrong results.Quantity on Hand := CALCULATE ( SUM ( Transaction[Quantity] ), FILTER ( Date, Date[DateKey] <= MAX ( Date[DateKey] ) ) )
Which of the following filter conditions should be used to correct the formula?

Question 6 of 10
6. Question
Which of the following statements correctly explains the difference between ISFILTERED and ISCROSSFILTERED?

Question 7 of 10
7. Question
Consider the following data model:
 The Products table has 10 rows
 The Sales table has 1,000 rows (including 20 rows with product codes that do not exist in the Products table)
 There is an active relationship between Products and Sales
You have the following measures in the data model:
Transactions := COUNTROWS ( Sales ) Result := SUMX ( Products, [Transactions] )
What is the value of the measure “Result” when it is otherwise unfiltered?

Question 8 of 10
8. Question
The following query returns a table containing two columns: Color and Sales.
The resulting table includes all the colors.
The second column is blank if there are no sales for the corresponding color.EVALUATE ADDCOLUMNS ( VALUES ( Product[Color] ), "Sales", CALCULATE ( SUM ( Sales[Amount] ) )
How can you modify the query to exclude colors with no sales? In other words, return only colors if there are corresponding rows in sales table.

Question 9 of 10
9. Question
What is the result of the following query?
EVALUATE ADDCOLUMNS ( GENERATE ( VALUES ( 'Product Category'[Product Category Name] ), CALCULATETABLE ( TOPN ( 3, SUMMARIZE ( 'Internet Sales', Product[Product Name], "Quantity", SUM ( 'Internet Sales'[Order Quantity] ) ), [Quantity] ) ) ), "Sales", [Sales] )

Question 10 of 10
10. Question
What is the result of the following query?
EVALUATE CALCULATETABLE ( CALCULATETABLE ( 'Sales Territory', ALL ( 'Sales Territory'[Country] ) ), 'Sales Territory'[Country] = "United States" )