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: 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 package uses custom functionality that accesses a SQL Server database. The custom functionality must be implemented by using Language Integrated Query (LINQ). You need to ensure that the LINQ code can be debugged at design time. What should you select from the SSIS Toolbox? (To answer, drag the appropriate item to the correct location in the answer area.) Answer: QUESTION 63 Drag and Drop Questions You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment model. The project contains many packages.