2019 NEW Microsoft 70-767: Implementing a Data Warehouse using SQL Exam Questions and Answers :

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: 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: