👉Get Full PDF
| Question 66 What is it called when multiple records in one table are associated with multiple records in another table? A. many-to-many relationship B. one-to-many relationship C. many-to-one relationship |
66. Click here to View Answer
Answer is (A) many-to-many relationship
| Question 67 A dimension that can filter related facts differently is called what? A. Role-playing dimension B. Snowflake dimension C. Degenerate dimension |
67. Click here to View Answer
Answer is (A) Role-playing dimension
| Question 68 What type of table stores details about business entities? A. Fact table B. Dimension table C. Date table D. Data table |
68. Click here to View Answer
Answer is (B) Dimension table
| Question 69 You are creating a quick measure as shown in the following exhibit.  You need to create a monthly rolling average measure for Sales over time. How should you configure the quick measure calculation?  |
69. Click here to View Answer
Box 1: Total Sales
We select the field Total Sales
Box 2: Date
Select a date field.
Box 3: Month
Monthly periods.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quick-measures
| Question 70 You build a report to analyze customer transactions from a database that contains the tables shown in the following table.  You import the tables. Which relationship should you use to link the tables? A. many-to-many between Customer and Transaction B. one-to-many from Transaction to Customer C. one-to-many from Customer to Transaction D. one-to-one between Customer and Transaction |
70. Click here to View Answer
Answer is (C) one-to-many from Customer to Transaction
Each customer can have many transactions.
For each transaction there is exactly one customer.