<< Prev Question Next Question >>

Question 39/99

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.
Start of repeated scenario.
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.

End of repeated scenario.
You need to reduce the amount of time it takes to back up OperationsMain.
What should you do?

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (99q)
Question 1: Note: This question is part of a series of questions that pr...
Question 2: Note: This question is part of a series of questions that pr...
Question 3: Background Corporate Information Fabrikam, Inc. is a retaile...
Question 4: You work as a Database Administrator (DBA) for a company nam...
Question 5: You administer a Microsoft SQL Server 2016 server that hosts...
Question 6: You are migrating a database named Orders to a new server th...
Question 7: You administer a SQL Server 2014 instance. Users report that...
Question 8: You have a server named Server1 that has 2 processors. You p...
Question 9: Note: This question is part of a series of questions that pr...
Question 10: Note: This question is part of a series of questions that us...
Question 11: You are troubleshooting an application that runs a query. Th...
Question 12: You plan to install Microsoft SQL Server 2016 for a web host...
Question 13: You create a stored procedure that retrieves all of the rows...
Question 14: Note: This question is part of a series of questions that us...
1 commentQuestion 15: You administer a SQL Server instance. A database named DB1 i...
Question 16: Note: This question is part of a series of questions that us...
Question 17: Note: This question is part of a series of questions that pr...
Question 18: You are a database administrator for a company. Database aud...
Question 19: You have a database named DB1. You plan to create a stored p...
Question 20: You administer a Microsoft SQL Server 2016 instance that has...
Question 21: You administer a Microsoft SQL Server 2016 database. The dat...
Question 22: Note: This question is part of a series of questions that pr...
Question 23: You need to assign security to dev_role1. How should you com...
Question 24: You have four databases that are accessed by using an Online...
Question 25: You have a SQL Server 2014 instance named SQL1. SQL1 creates...
Question 26: Note: This question is part of a series of questions that pr...
Question 27: You manage a database named DB1 that uses the following file...
Question 28: Note: This question is part of a series of questions that us...
Question 29: Note: This question is part of a series of questions that pr...
Question 30: You administer a Microsoft SQL Server 2016 server that hosts...
Question 31: You configure the Microsoft SQL Server Agent service to star...
Question 32: Overview General Overview ADatum Corporation has offices in ...
Question 33: You are building a stored procedure for a SQL Azure database...
Question 34: You administer two instances of Microsoft SQL Server 2016. Y...
Question 35: General Overview You are the Senior Database Administrator (...
Question 36: Note: This question is a part of a series of questions that ...
Question 37: Note: This question is part of a series of questions that us...
Question 38: You are the lead database administrator (DBA) of a Microsoft...
Question 39: Note: This question is part of a series of questions that us...
Question 40: Note: This question is part of a series of questions that us...
Question 41: A company has an on-premises Microsoft SOI Server environmen...
1 commentQuestion 42: You have two SQL Server instances named SQLDev and SQLProd t...
Question 43: Note: This question is part of a series of questions that pr...
Question 44: Note: This question is part of a series of questions that pr...
Question 45: You have a test server that contains a database named DB1. B...
Question 46: You administer two servers AO-AG2 and ao-ag2. Microsoft SQL ...
Question 47: Overview General Overview ADatum Corporation has offices in ...
Question 48: Overview You are a database administrator for a company name...
Question 49: You have a SQL Server instance on a server named Server1. Yo...
Question 50: Background Corporate Information Fabrikam, Inc. is a retaile...
Question 51: You administer several Microsoft SQL Server 2016 database se...
Question 52: A company has an on-premises Microsoft SQL Server environmen...
Question 53: Note: This question is part of a series of questions that pr...
Question 54: Note: This question is part of a series of questions that pr...
Question 55: Note: This question is part of a series of questions that us...
Question 56: An organization deploys Microsoft SQL Server instances at a ...
Question 57: Your company has offices in Seattle and Montreal. The networ...
Question 58: You want to simulate read, write, checkpoint, backup, sort, ...
Question 59: You plan to deploy SQL Server 2014. Your company identifies ...
Question 60: You have multiple Microsoft SQL Server databases that are de...
Question 61: You have a table that contains a column named Department. Ea...
Question 62: You have a SQL Server 2012 database named DB1. You have a ba...
Question 63: You maintain three datacenters in different geographical reg...
Question 64: Background Corporate Information Fabrikam, Inc. is a retaile...
Question 65: You manage a Microsoft SQL Server instance that has a databa...
Question 66: Note: This question is part of a series of questions that pr...
Question 67: You are creating a database that will store usernames and cr...
Question 68: You administer a Microsoft SQL Server 2016 instance. After a...
Question 69: You manage a Microsoft SQL Server environment with a databas...
Question 70: You have a database hosted on SQL Server 2012 R2. The databa...
Question 71: You have a database that stores information for a shipping c...
Question 72: Overview Application Overview Contoso, Ltd., is the develope...
Question 73: Note: This question is part of a series of questions that pr...
Question 74: Note: This question is part of a series of questions that us...
Question 75: You create an availability group that has replicas named HA/...
Question 76: Overview You are a database administrator for a company name...
Question 77: Overview General Overview ADatum Corporation has offices in ...
Question 78: You need to validate rows before they are added to a table e...
Question 79: Note: This question is part of a series of questions that us...
Question 80: You manage a Microsoft SQL Server environment. You plan to e...
Question 81: You are planning the deployment of two new Always On Failove...
Question 82: Note: This question is part of a series of questions that us...
Question 83: You work as a Developer at ABC.com. All databases are hosted...
Question 84: You work as a Database Administrator (DBA) for a company nam...
Question 85: You are implementing a SQL Server 2016 five-node failover cl...
Question 86: You administer two Microsoft SQL Server 2012 servers. Each s...
Question 87: You administer a Microsoft SQL Server 2016 database. You pro...
Question 88: You are configuring log shipping for a Microsoft SQL Server ...
Question 89: Note: This question is part of a series of questions that us...
Question 90: Note: This question is part of a series of questions that us...
Question 91: Note: This question is part of a series of questions that pr...
Question 92: You administer a Microsoft SQL Server 2016 database named Or...
Question 93: You have a Microsoft SQL Server instance that hosts a databa...
Question 94: Note: This question is part of a series of questions that pr...
Question 95: Note: This question is part of a series of question that pre...
Question 96: You have a SQL Azure database named Database1. You need to d...
Question 97: You administer a Microsoft SQL Server 2016 database that con...
Question 98: You have a database named DB1. You must ensure that DB1 is h...
Question 99: You install Microsoft SQL Server 2016 on a new server. After...