exam questions

Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Exam 70-778 topic 1 question 122 discussion

Actual exam question from Microsoft's 70-778
Question #: 122
Topic #: 1
[All 70-778 Questions]

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?

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
exam_taker5
Highly Voted 5 years, 9 months ago
Why is this step needed?
upvoted 20 times
...
Hien
Highly Voted 5 years, 8 months ago
Yes, the Store_ID is integer in both Store and Order tables. no need any actions.
upvoted 16 times
Hien
5 years, 8 months ago
I wonder about this "The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables." but the Monthly_returns(Store_ID) is Varchar(100) and Store(Store_ID) is Integer, and they still can have relationship? then the Date(Store_ID) also is Integer type, why we have to change it?
upvoted 25 times
...
...
yess123
Most Recent 4 years, 8 months ago
it's G
upvoted 5 times
...
aruprajak
4 years, 11 months ago
Okay, My take on this... Since, in the Monthly returns_table the data type for STORE_ID column is varchar(100). During its joining to Store table, we changed the datatype of Store tables Store ID to varchar(100). Now for the join of Store to Order, we need to change the datatype of Order tables Store ID to varchar(100). Weird way of doing thigs, but otherwise the question is invalid.
upvoted 9 times
Martin_Nbg
4 years, 7 months ago
But still, C would be wrong. If you have a working relationship between Stoere and Monthly_Returns you better do not change the Store Table and destroy the foundation of this relationship. I guess the mistake is which datatype is displayed in the table for field Store.Store_ID.
upvoted 1 times
...
...
VimalLalani
5 years, 2 months ago
It Should be E. Data Type of Monthly_Return[StoreID] should be integer
upvoted 3 times
...
mohroshdy
5 years, 4 months ago
Datatype in both columns are integer, no action needed Maybe this question change.
upvoted 6 times
...
Delta
5 years, 4 months ago
Why would you need to do anything, both table has an integer Store-ID. ? Any clarifications more then welcome.
upvoted 8 times
...
AlexThoBreaux
5 years, 4 months ago
Do data types matter when you are creating relationships?
upvoted 1 times
haithem
5 years, 3 months ago
It does matter but in our case both data types are the same, so it might be an old question
upvoted 1 times
...
...
preksha
5 years, 9 months ago
should be D? we change storeid to integer instead of float in the order table
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago