2019 NEW Microsoft 70-767: Implementing a Data War
Exam (elaborations)
2019 NEW Microsoft 70-767: Implementing a Data Warehouse using SQL Exam Questions and Answers :
3 views 0 purchase
Course
2019 NEW Microsoft 70-767: Implementing a Data War
Institution
Harvard University
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 solut...
2019 NEW Microsoft 70-767: Implementing a Data War
All documents for this subject (1)
Seller
Follow
QUICKEXAMINER
Reviews received
Content preview
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.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller QUICKEXAMINER. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.49. You're not tied to anything after your purchase.
