What should you do before you create the relationship?

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 questionpresents a different goal and answer choices, but the text of the scenario is the same in each question-in this series.
You have a Microsoft SQL Server database that contains the following tables.

The following columns contain date information:
– Date[Month] in the mmyyyy format
– Date[Date_ID] in the ddmmyyyy format
– Date[Date_name] in the mm/dd/yyyy format
– Monthly_returns[Month_ID] in the mmyyyy format
The Order table contains more than one million rows.
The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.
You plan to use Power BI Desktop to create an analytics solution for the data.
You need to create a relationship between the Order table and the Store table on the Store_ID column.
What should you do before you create the relationship?
A. In the Order table query, use the Table.TrasformRows function.
B. In the Store table query, use the Table.TrasformRows function.
C. In the Store table query, use the Table.TrasformColumnTypes function.
D. In the Order table query, use the Table.TrasformColumnTypes function.

microsoft-exams

One thought on “What should you do before you create the relationship?

  1. any comments on why here would be helpful. if the data type is already matched and store id is unique in the store table then why is a transform column types function required? sorry if I have missed something obvious, Im a little new to all this

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.