DRAG DROP
You have a database. The existing backups for the database and their corresponding files are listed in the
following table.

You purchase a new server. You must restore the database to the new server.
You need to restore the data to the most recent time possible.
Which three files should you restore in sequence? To answer, move the appropriate files from the list of files to
the answer area and arrange them in the correct order.
Select and Place:

A Microsoft SQL Server database named DB1 has two filegroups named FG1 and FG2. You implement a
backup strategy that creates backups for the filegroups.
DB1 experiences a failure. You must restore FG1 and then FG2.
You need to ensure that the database remains in the RECOVERING state until the restoration of FG2
completes. After the restoration of FG2 completes, the database must be online.
What should you specify when you run the recovery command?

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 have five servers that run Microsoft Windows 2012 R2. Each server hosts a Microsoft SQL Server
instance. The topology for the environment is shown in the following diagram.

You have an Always On Availability group named AG1. The details for AG1 are shown in the following table.

Instance1 experiences heavy read-write traffic. The instance hosts a database named OperationsMain that is
four terabytes (TB) in size. The database has multiple data files and filegroups. One of the filegroups is
read_only and is half of the total database size.
Instance4 and Instance5 are not part of AG1. Instance4 is engaged in heavy read-write I/O.
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.
Reporting system: This solution accesses data inDB1with a login that is mapped to a database user that is a
member of the db_datareader role. The user has EXECUTE permissions on the database. Queries make
no changes to the data. The queries must be load balanced over variable read-only replicas.
Operations system: This solution accesses data inDB1with a login that is mapped to a database user that is
a member of the db_datareader and db_datawriter roles. The user has EXECUTE permissions on the
database. Queries from the operations system will perform both DDL and DML operations.
The wait statistics monitoring requirements for the instances are described in the following table.

You need to reduce the amount of time it takes to backup OperationsMain.
What should you do?

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 have five servers that run Microsoft Windows 2012 R2. Each server hosts a Microsoft SQL Server
instance. The topology for the environment is shown in the following diagram.

You have an Always On Availability group named AG1. The details for AG1 are shown in the following table.

Instance1 experiences heavy read-write traffic. The instance hosts a database named OperationsMain that is
four terabytes (TB) in size. The database has multiple data files and filegroups. One of the filegroups is
read_only and is half of the total database size.
Instance4 and Instance5 are not part of AG1. Instance4 is engaged in heavy read-write I/O.
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.
Reporting system: This solution accesses data inDB1with a login that is mapped to a database user that is a
member of the db_datareader role. The user has EXECUTE permissions on the database. Queries make
no changes to the data. The queries must be load balanced over variable read-only replicas.
Operations system: This solution accesses data inDB1with a login that is mapped to a database user that is
a member of the db_datareader and db_datawriter roles. The user has EXECUTE permissions on the
database. Queries from the operations system will perform both DDL and DML operations.
The wait statistics monitoring requirements for the instances are described in the following table.

You need to propose a new process for the StagedExternal database.
Which five actions should you recommended be performed in sequence? To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

DRAG DROPNote: 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 have five servers that run Microsoft Windows 2012 R2. Each server hosts a Microsoft SQL Server
instance. The topology for the environment is shown in the following diagram.

You have an Always On Availability group named AG1. The details for AG1 are shown in the following table.

Instance1 experiences heavy read-write traffic. The instance hosts a database named OperationsMain that is
four terabytes (TB) in size. The database has multiple data files and filegroups. One of the filegroups is
read_only and is half of the total database size.
Instance4 and Instance5 are not part of AG1. Instance4 is engaged in heavy read-write I/O.
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 andSite2. 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.
Reporting system: This solution accesses data inDB1with a login that is mapped to a database user that is a
member of the db_datareader role. The user has EXECUTE permissions on the database. Queries make
no changes to the data. The queries must be load balanced over variable read-only replicas.
Operations system: This solution accesses data inDB1with a login that is mapped to a database user that is
a member of the db_datareader and db_datawriter roles. The user has EXECUTE permissions on the
database. Queries from the operations system will perform both DDL and DML operations.
The wait statistics monitoring requirements for the instances are described in the following table.

You need to analyze the wait type and statistics for specific instanced in the environment.
Which object should you use to gather information about each instance? To answer, drag the appropriate
objects to the correct instances. Each object may be used once, more than once, or not at all. You may need to
drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

DRAG DROP
Note: This question is part of a series of questions that use the same scenario. For your convenience, thescenario 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 have five servers that run Microsoft Windows 2012 R2. Each server hosts a Microsoft SQL Server
instance. The topology for the environment is shown in the following diagram.

You have an Always On Availability group named AG1. The details for AG1 are shown in the following table.

Instance1 experiences heavy read-write traffic. The instance hosts a database named OperationsMain that is
four terabytes (TB) in size. The database has multiple data files and filegroups. One of the filegroups is
read_only and is half of the total database size.
Instance4 and Instance5 are not part of AG1. Instance4 is engaged in heavy read-write I/O.
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.
Reporting system: This solution accesses data inDB1with a login that is mapped to a database user that is a
member of the db_datareader role. The user has EXECUTE permissions on the database. Queries make
no changes to the data. The queries must be load balanced over variable read-only replicas.
Operations system: This solution accesses data inDB1with a login that is mapped to a database user that is
a member of the db_datareader and db_datawriter roles. The user has EXECUTE permissions on the
database. Queries from the operations system will perform both DDL and DML operations.
The wait statistics monitoring requirements for the instances are described in the following table.

You need to configure a new replica of AG1 on Instance6.
How should you complete the Transact-SQL statement? To answer, drag the appropriate Transact-SQL
statements to the correct locations. Each Transact-SQL segment may be used once, more than once, or not at
all. You may need to drag the split bar between panes or scroll to view content.
Select and Place:

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 have five servers that run Microsoft Windows 2012 R2. Each server hosts a Microsoft SQL Server
instance. The topology for the environment is shown in the following diagram.

You have an Always On Availability group named AG1. The details for AG1 are shown in the following table.

Instance1 experiences heavy read-write traffic. The instance hosts a database named OperationsMain that is
four terabytes (TB) in size. The database has multiple data files and filegroups. One of the filegroups is
read_only and is half of the total database size.
Instance4 and Instance5 are not part of AG1. Instance4 is engaged in heavy read-write I/O.
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.
Reporting system: This solution accesses data inDB1with a login that is mapped to a database user that is a
member of the db_datareader role. The user has EXECUTE permissions on the database. Queries make
no changes to the data. The queries must be load balanced over variable read-only replicas.
Operations system: This solution accesses data inDB1with a login that is mapped to a database user that is
a member of the db_datareader and db_datawriter roles. The user has EXECUTE permissions on the
database. Queries from the operations system will perform both DDL and DML operations.
The wait statistics monitoring requirements for the instances are described in the following table.

You need to create a backup plan for Instance4.
Which backup plan should you create?

HOTSPOT
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 have five servers that run Microsoft Windows 2012 R2. Each server hosts a Microsoft SQL Server
instance. The topology for the environment is shown in the following diagram.

You have an Always On Availability group named AG1. The details for AG1 are shown in the following table.

Instance1 experiences heavy read-write traffic. The instance hosts a database named OperationsMain that is
four terabytes (TB) in size. The database has multiple data files and filegroups. One of the filegroups is
read_only and is half of the total database size.
Instance4 and Instance5 are not part of AG1. Instance4 is engaged in heavy read-write I/O.
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.
Reporting system: This solution accesses data inDB1with a login that is mapped to a database user that is a
member of the db_datareader role. The user has EXECUTE permissions on the database. Queries make
no changes to the data. The queries must be load balanced over variable read-only replicas.
Operations system: This solution accesses data inDB1with a login that is mapped to a database user that is
a member of the db_datareader and db_datawriter roles. The user has EXECUTE permissions on the
database. Queries from the operations system will perform both DDL and DML operations.
The wait statistics monitoring requirements for the instances are described in the following table.

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.
Hot Area:

HOTSPOT
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.

You need to configure auditing for WDWDB.
In the table below, identify the event type that you must audit for each activity.
Hot Area:

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.

You need to monitor WingDB and gather information for troubleshooting issues.
What should you use?