Week 2

Question 1

EASY Q1: You have a Power BI dataset based on a Star schema data source. You need to use the Data Analysis Expression (DAX) to create a date table and populate the table with range of dates based on the earliest and latest date within the dataset. Which function should you use?

Answer 1

CALENDARAUTO

Question 2

EASY Q2: You have designed a Star schema to simplify your data. You need to understand the relationship between the tables in Star schema. What is the relationship between the fact tables and the dimension tables?

Answer 2

WRONG: One-to-many

Question 3

EASY Q3: You preview a sales table in Power Query Editor in Power BI Desktop. The table contains the following columns: ProductName, ProductID, SalesDate, and SalesAmount.You need to convert the table into a properly formed star schema. To which table should you add the SalesAmount field?

Answer 3

Sales Fact

Question 4

EASY Q4: You need to use DAX measures to generate results to use in a report. Which type of DAX quick measure calculations will NOT work against a DirectQuery table?

Answer 4

Time intelligence

Question 5

EASY Q5: You need to develop a quick measure in Power BI Desktop. Which two elements can you use? Each correct answer presents a complete solution

Answer 5

-Fields
-Calculations

Question 6

EASY Q6: You plan to use the calculated table functionality to create a duplicate table in Power BI Desktop. Which characteristics of the original table will be duplicated?

Answer 6

Data only

Question 7

EASY Q7: You need to create DAX-calculated columns and measures in Power BI Desktop. In which two places can a DAX calculated column be used, but a DAX calculated measure cannot be used? Each correct answer presents a complete solution.

Answer 7

-as a filter in the “Filters on this page” well of the Filters pane
-as an item in the Fields well of a Slicer

Question 8

EASY Q8: You have a fact table that contains sales data and the following two columns:
1. Order date
2. Ship date
Both columns have a relationship to the Date column in the Calendar table, and DAX measures have been configured to use these relationships for calculations related to order or ship dates. You need to ensure that by default, the Calendar table does NOT filter the fact table, unless it is using a DAX measure that uses these relationships what should you do?

Answer 8

PARTIAL ANSWER: Disable Make this relationship active for both relationships

Question 9

EASY Q9: You have a Power BI dataset that gets data from a table in a SQL server database. From which view in Power BI Desktop can you modify the storage mode of the table?

Answer 9

Model view

Question 10

EASY Q10: You create a Power BI dataset by importing and transforming a data source based on multiple tables in a SQL Server database. You need to modify the relationship between the tables. Which interface should you use in Power BI?

Answer 10

Model view