Microsoft 70-767 Questions Answers

You work as a senior database administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft
SQL Server 2012 in their environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are discussing the use ofSlowly Changing Dimension Transformation
Outputs. One of the output options causes Derived Column transformations to create columns for the expired row and the current row indicators.
Which option is the output that causes this?

A. Unchanged Output
B. Inferred Member Updates Output
C. Historical Attributes Inserts Output
D. Fixed Attribute Output
E. Changing Attributes Updates Output

Answer: C


You work as a senior database administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft
SQL Server 2012 in their environment.
You are hosting a training exercise for Microsoft SQL Server 2012 administrators. You are currently discussing Multicast transformation.
Which of the following is TRUE with regards to Multicast transformation? (Choose two.)

A. It prevents a package from creating logical copies of data.
B. It allows a package to create logical copies of data.
C. It distributes its input to one or more outputs.
D. It distributes its input to a single output.

Answer: BC