Guarantee All Exams 100% Pass One Time!
2019 NEW Microsoft 70-767:
Implementing a Data Warehouse using
SQL Exam Questions and Answers
:
QUESTION 58
You manage a SQL Server Master Data Services (MDS) environment.
A new application requires access to the product data that is available in the MDS
repository. You need to design a solution that gives the application access to the
product data with the least amount of development effort.
What should you do?
A. Use sp_addlinkedserver to add a linked server to access the MDS database tables
directly.
B. Create an OLE DB connection string that sets the Provider property to MDS.
C. Use transactional replication for data synchronization.
D. Create a Subscription View in MDS.
Answer: D
QUESTION 59
You are completing the installation of the Data Quality Server component of SQL
Server Data Quality Services (DQS).
You need to complete the post-installation
configuration. What should you do?
A. Install the Analysis Services OLE DB Provider.
B. Make the data available for DQS operations.
C. Run the Data Quality Server Installer.
D. Install ADOMD.NET.
Answer: C
Explanation:
, Guarantee All Exams 100% Pass One Time!
http://msdn.microsoft.com/en-us/library/
ff877917.aspx
http://msdn.microsoft.com/en-us/library/gg49227
7.aspx
QUESTION 60
You are editing a SQL Server Integration Services (SSIS) package that contains three
Execute SQL tasks and no other tasks.
The three Execute SQL tasks modify products in staging tables in preparation for a
data warehouse load. The package and all three Execute SQL product tasks have
their TransactionOption property set to Supported.
You need to ensure that if any of the three Execute SQL product tasks fail, all three
tasks will roll back their changes.
What should you do?
A. Change the TransactionOption property of the package to Required.
B. Change the TransactionOption property of all three Execute SQL product tasks to
Required.
C. Move the three Execute SQL product tasks into a Foreach Loop container.
D. Move the three Execute SQL product tasks into a Sequence container.
Answer: A
Explanation:
http://msdn.microsoft.com/en-us/library/
ms137690.aspx
http://msdn.microsoft.com/en-us/library/ms141144
.aspx
QUESTION 61
You are developing a SQL Server Integration Services (SSIS) package that imports
data into a data warehouse hosted on SQL Azure.
The package uses a Foreach container to process text files found in a folder.
The package must be deployed to a single server by using the Project Deployment
model. Multiple SQL Server Agent jobs call the package.
Each job is executed on a different schedule.
Each job passes a different folder path to the package.
You need to configure the package to accept the folder path from
each job. Which package configuration should you use?
A. Parent Package Variable
B. XML Configuration File
C. Environment Variable
D. .dtsConfig file
E. Registry Entry
Answer: C
QUESTION 62
Drag and Drop Question
You are developing a SQL Server Integration Services (SSIS) package.
2019 NEW Microsoft 70-767:
Implementing a Data Warehouse using
SQL Exam Questions and Answers
:
QUESTION 58
You manage a SQL Server Master Data Services (MDS) environment.
A new application requires access to the product data that is available in the MDS
repository. You need to design a solution that gives the application access to the
product data with the least amount of development effort.
What should you do?
A. Use sp_addlinkedserver to add a linked server to access the MDS database tables
directly.
B. Create an OLE DB connection string that sets the Provider property to MDS.
C. Use transactional replication for data synchronization.
D. Create a Subscription View in MDS.
Answer: D
QUESTION 59
You are completing the installation of the Data Quality Server component of SQL
Server Data Quality Services (DQS).
You need to complete the post-installation
configuration. What should you do?
A. Install the Analysis Services OLE DB Provider.
B. Make the data available for DQS operations.
C. Run the Data Quality Server Installer.
D. Install ADOMD.NET.
Answer: C
Explanation:
, Guarantee All Exams 100% Pass One Time!
http://msdn.microsoft.com/en-us/library/
ff877917.aspx
http://msdn.microsoft.com/en-us/library/gg49227
7.aspx
QUESTION 60
You are editing a SQL Server Integration Services (SSIS) package that contains three
Execute SQL tasks and no other tasks.
The three Execute SQL tasks modify products in staging tables in preparation for a
data warehouse load. The package and all three Execute SQL product tasks have
their TransactionOption property set to Supported.
You need to ensure that if any of the three Execute SQL product tasks fail, all three
tasks will roll back their changes.
What should you do?
A. Change the TransactionOption property of the package to Required.
B. Change the TransactionOption property of all three Execute SQL product tasks to
Required.
C. Move the three Execute SQL product tasks into a Foreach Loop container.
D. Move the three Execute SQL product tasks into a Sequence container.
Answer: A
Explanation:
http://msdn.microsoft.com/en-us/library/
ms137690.aspx
http://msdn.microsoft.com/en-us/library/ms141144
.aspx
QUESTION 61
You are developing a SQL Server Integration Services (SSIS) package that imports
data into a data warehouse hosted on SQL Azure.
The package uses a Foreach container to process text files found in a folder.
The package must be deployed to a single server by using the Project Deployment
model. Multiple SQL Server Agent jobs call the package.
Each job is executed on a different schedule.
Each job passes a different folder path to the package.
You need to configure the package to accept the folder path from
each job. Which package configuration should you use?
A. Parent Package Variable
B. XML Configuration File
C. Environment Variable
D. .dtsConfig file
E. Registry Entry
Answer: C
QUESTION 62
Drag and Drop Question
You are developing a SQL Server Integration Services (SSIS) package.
