Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.You have a database named DB1 that has change data capture enabled.A Microsoft SQL Server Integration Services (SSIS) job runs once weekly. The job loads changes from DB1 to a data warehouse by querying the change data capture tables.Users report that an application that uses DB1 is suddenly unresponsive.You discover that the Integration Services job causes severe blocking issues in the application.You need to ensure that the users can run the application as quickly as possible.Your SQL Server login is a member of only the ssis_admin database role.Which stored procedure should you execute?
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.You have a database named DB1 that has change data capture enabled.A Microsoft SQL Server Integration Services (SSIS) job runs once weekly. The job loads changes from DB1 to a data warehouse by querying the change data capture tables.You remove the Integration Services job.You need to stop tracking changes to the database temporarily. The solution must ensure that tracking changes can be restored quickly in a few weeks.Which stored procedure should you execute?
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.You have a database named DB1 that has change data capture enabled.A Microsoft SQL Server Integration Services (SSIS) job runs once weekly. The job loads changes from DB1 to a data warehouse by querying the change data capture tables.A new version of the Integration Services package is released that introduces several errors in the loading process.You need to roll back the Integration Services package to the previous version.Which stored procedure should you execute?
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.You have a database named DB1 that has change data capture enabled.A Microsoft SQL Server Integration Services (SSIS) job runs once weekly. The job loads changes from DB1 to a data warehouse by querying the change data capture tables.You discover that the job loads changes from the previous three days only.You need to ensure that the job loads changes from the previous week.Which stored procedure should you execute?
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.You are loading data from an OLTP database to a data warehouse.The OLTP database includes a table for sales data and a table for refund data.The data warehouse contains a single table for all the sales and refund data.Which component should you use to load the data to the data warehouse?
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have a Microsoft Azure SQL Data Warehouse instance that must be available six months a day for reporting.You need to pause the compute resources when the instance is not being used.Solution: You use SQL Server Configuration Manager.Does the solution meet the goal?
