0 of 10 questions completed
This self-assessment 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:
Time has elapsed
0 0 0
Sorry, but Optimizing DAX Workshop is too advanced for you. You should start studying DAX from the ground-up. 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.
Question 1 of 10
1. QuestionThere 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 2 of 10
2. QuestionConsider 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
Transactions := COUNTROWS ( Sales ) Result := SUMX ( Customers, [Transactions] )What is the value of the measure “Result” when it is otherwise unfiltered?
Question 3 of 10
3. QuestionConsider 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.
Question 4 of 10
4. QuestionThe 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 5 of 10
5. QuestionWhich of the following statements correctly explains the difference between ISFILTERED and ISCROSSFILTERED?
Question 6 of 10
6. QuestionConsider 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
Transactions := COUNTROWS ( Sales ) Result := SUMX ( Products, [Transactions] )What is the value of the measure “Result” when it is otherwise unfiltered?
Question 7 of 10
7. QuestionThe 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 8 of 10
8. QuestionConsider 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 9 of 10
9. QuestionWhat 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. QuestionWhat is the result of the following query?
EVALUATE CALCULATETABLE ( CALCULATETABLE ( 'Sales Territory', ALL ( 'Sales Territory'[Country] ) ), 'Sales Territory'[Country] = "United States" )