Instance5 hosts a database named StagedExternal A nightly BULK INSERT process

Instance5 hosts a database named stagedexternal a

This preview shows page 30 - 35 out of 39 pages.

Instance5 hosts a database named StagedExternal. A nightly BULK INSERT process loads data into an empty table that has a rowstore clustered index and two nonclustered rowstore indexes. You must minimize the growth of the StagedExternal database log file during the BULK INSERT operations and perform point-in-time recovery after the BULK INSERT transaction. Changes made must not interrupt the log backup chain. You plan to add a new instance named Instance6 to a datacenter that is geographically distant from Site1 and Site2. You must minimize latency between the nodes in AG1. All databases use the full recovery model. All backups are written to the network location \\SQLBackup\. A separate process copies backups to an offsite location. You should minimize both the time required to restore the databases and the space required to store backups. The recovery point objective (RPO) for each instance is shown in the following table. Full backups of OperationsMain take longer than six hours to complete. All SQL Server backups use the keyword COMPRESSION. You plan to deploy the following solutions to the environment. The solutions will access a database named DB1 that is part of AG1. The wait statistics monitoring requirements for the instances are described in the following table. page 30 / 39
Image of page 30
You need to create the connection strings for the operations and reporting systems. In the table below, identify the option that must be specified in each connection string. NOTE: Make only one selection in each column. Answer: page 31 / 39
Image of page 31
18.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 sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. A company has a server that runs Microsoft SQL Server 2016 Web edition. The server has a default instance that hosts a database named DB1. You need to ensure that you can perform auditing at the database level for DB1. Solution: You migrate DB1 to a named instance on a server than runs Microsoft SQL Server 2016 Standard edition. Does the solution meet the goal? A. Yes B. No Answer: B page 32 / 39
Image of page 32
19.DRAG DROP Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series. You are a database administrator for a company that has an on- premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases, and each customer uses a dedicated instance. The environments that you manage are shown in the following table. page 33 / 39
Image of page 33
You need to implement a process for importing data into WingDB.
Image of page 34
Image of page 35

You've reached the end of your free preview.

Want to read all 39 pages?

  • Spring '18
  • E. J Janet Smith
  • Relational model, Microsoft SQL Server, Transact-SQL

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture