nerdexam
Microsoft

70-779 · Question #60

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer…

The correct answer is C. Mark DimDate as the date table. https://docs.microsoft.com/en-us/sql/analysis-services/lesson-3-mark-as-date-table?view=sql- analysis-services-2017

Model data by using Microsoft Excel

Question

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series. Start of repeated scenario. You have six workbook queries that each extracts a table from a Microsoft Azure SQL database. The tables are loaded to the data model, but the data is not loaded to any worksheets. The data model is shown in the Data Model exhibit. (Click the Exhibit button.) Your company has 100 product subcategories and more than 10,000 products. End of repeated scenario. You plan to use the DAX time intelligence functions of DATEADD and DATESMTD. You need to ensure that the functions return the correct data. What should you do first?

Options

  • ADelete and recreate the relationship between FactSales and DimDate.
  • BChange the Data Type of FactSales[DateKey].
  • CMark DimDate as the date table.
  • DChange trie Data Type of DimDate[DateKey].

How the community answered

(31 responses)
  • A
    13% (4)
  • B
    3% (1)
  • C
    77% (24)
  • D
    6% (2)

Explanation

https://docs.microsoft.com/en-us/sql/analysis-services/lesson-3-mark-as-date-table?view=sql- analysis-services-2017

Topics

#date table#DimDate#relationships#Power Pivot

Community Discussion

No community discussion yet for this question.

Full 70-779 Practice