You administer all the deployments of Microsoft SQL Server 2016 in your company.You need to ensure that data changes are sent to a non-SQL Server database server in near real time.You also need to ensure that data on the primary server is unaffected.Which configuration should you use?
You administer all the deployments of Microsoft SQL Server 2016 in your company.A database contains a large product catalog that is updated periodically.You need to be able to send the entire product catalog to all branch offices on a monthly basis.Which configuration should you use?
You administer all the deployments of Microsoft SQL Server 2016 in your company.You need to ensure that an OLTP database that uses a storage area network (SAN) remains available if any of the servers fail.You also need to minimize the amount of storage used by the database.Which configuration should you use?
You administer a Microsoft SQL Server 2016 server that hosts a transactional database and a reporting database.The transactional database is updated through a web application and is operational throughout the day.The reporting database is only updated from the transactional database.The recovery model and backup schedule are configured as shown in the following table:The differential backup of the reporting database fails.Then, the reporting database fails at 14:00 hours.You need to ensure that the reporting database is restored.You also need to ensure that data loss is minimal.What should you do?
You administer a Microsoft SQL Server 2016 server that hosts a transactional database and a reporting database. The transactional database is updated through a web application and is operational throughout the day.The reporting database is only updated from the transactional database.The recovery model and backup schedule are configured as shown in the following table:At 14:00 hours, you discover that pages 71, 520, and 713 on one of the database files are corrupted on the reporting database.You need to ensure that the databases are restored.You also need to ensure that data loss is minimal. What should you do?
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 need to configure a Microsoft SQL Server instance to ensure that a user named Mail1 can send mail by using Database Mail.Solution: You add the DatabaseMailUserRole to Mail1 in the tempdb database.Does the solution meet the goal?
