Exam 70-767 topic 1 question 101 discussion

Actual exam question from Microsoft's 70-767

Question #: 101
Topic #: 1

You have a data warehouse that contains a fact table named Table1 and a Product table named Dim1. Dim1 is configured as shown in the following table.

You are adding a second OLTP system to the data warehouse as a new fact table named Table2. The Product table of the OLTP system is configured as shown in the following table

You need to modify Dim1 to ensure that the table can be used for both fact tables.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. Modify the data type of the Weight column in Dim1 to decimal (19, 2).
B. Add the SalesUnit column to Dim1.
C. Modify the data type of the Name column in Dim1 to varchar (85).
D. Drop the ProductKey column from Dim1 and replace the column with the ProductIdentifier column.
E. Drop the Color column from Dim1.
F. Modify the data type of the ProductKey column in Dim1 to char (18).

Show Suggested Answer

Suggested Answer: AD 🗳️

by RB_Unleash at Nov. 11, 2019, 12:13 a.m.

Comments

Submit Cancel

Jbauer

Highly Voted 5 years, 5 months ago

I think should be AB

upvoted 17 times

...

skaner

Highly Voted 5 years, 4 months ago

right answers are A, B

upvoted 5 times

...

ArturMyhajlyuk

Most Recent 4 years, 5 months ago

We must use Dim1 with new Table2. For that we must have a key. We must drop productkey, that we can insert a ProductIdentifier and it is a key for both Table1 and Table2. So, D is correct

upvoted 1 times

...

DudeHere

4 years, 7 months ago

AB For decimal and numeric data types, SQL Server considers each combination of precision and scale as a different data type. For example, decimal(5,5) and decimal(5,0) are considered different data types.

upvoted 2 times

...

Slava_bcd81

4 years, 8 months ago

I think BD

upvoted 1 times

Slava_bcd81

4 years, 8 months ago

there is no need for A

upvoted 1 times

...

cartaf

5 years, 3 months ago

ProductIdentifier varchar(8) of table2 can fit into ProductKey varchar(10) of Dim1. I don't have to drop ProductKey I have to use SalesUnit, then add it. A B

upvoted 3 times

...

AlexSuciu

5 years, 3 months ago

× I think sales unit might not be an attribute for a Product dim? Nevertheless, if you drop the initial key(char 10) for the new one(char 8), the dim will not be able to be used for the original fact table. Thus i would tend to agree with A and B as correct answers

upvoted 2 times

...