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.
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?
exam_taker5
Highly Voted 5 years, 9 months agoHien
Highly Voted 5 years, 8 months agoHien
5 years, 8 months agoyess123
Most Recent 4 years, 8 months agoaruprajak
4 years, 11 months agoMartin_Nbg
4 years, 7 months agoVimalLalani
5 years, 2 months agomohroshdy
5 years, 4 months agoDelta
5 years, 4 months agoAlexThoBreaux
5 years, 4 months agohaithem
5 years, 3 months agopreksha
5 years, 9 months ago