web analytics

Data can be recovered by using the minimum amount of administrative effort. What should you do? Choose three.

You administer a Microsoft SQL Server 2012 instance. The instance contains a database that supports a retail sales application. The application generates hundreds of transactions per second and is online

You need to ensure that the backup size is as small as possible. Which backup should you perform every two hours?

You administer a Microsoft SQL Server instance that contains a financial database hosted on a storage area network (SAN). The financial database has the following characteristics: A data file of

You need to ensure that the minimum amount of data is lost. Which recovery model should the database use?

You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN). The financial database has the following characteristics: A data file

You need to perform a full database backup that will be restored on the development server. Which backup option should you use?

You administer a Microsoft SQL Server instance that contains a financial database hosted on a storage area network (SAN). The financial database has the following characteristics: A data file of

You need to ensure that your backup will continue if any invalid checksum is encountered. Which backup option should you use?

You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN). The financial database has the following characteristics: A data file

You need to limit the number of cores that handle I/O. What should you configure?

You administer a Microsoft SQL Server 2012 Enterprise Edition server that uses 64 cores. You discover performance issues when large amounts of data are written to tables under heavy system

You need to ensure that the application login is unable to access other production databases. What should you do?

You administer a single server that contains a Microsoft SQL Server 2012 default instance. You plan to install a new application that requires the deployment of a database on the

You need to be able to start the SQL Server. What should you do?

You administer a Microsoft SQL Server 2012 instance. After a routine shutdown, the drive that contains tempdb fails. You need to be able to start the SQL Server. What should

Answer presents part of the solution. Which two actions should you perform? Each

You administer a Microsoft SQL Server server. The MSSQLSERVER service uses a domain account named CONTOSO\SQLService. You plan to configure Instant File Initialization. You need to ensure that Data File

You need to ensure that the size of the transaction log file does not exceed 2 GB. What should you do?

You administer a Microsoft SQL Server database. You need to ensure that the size of the transaction log file does not exceed 2 GB. What should you do? A. Execute

You need to identify which queries are taking longer than 1 second to run over an extended period of time. What should you do?

You administer a Microsoft SQL Server database server. One of the databases on the server supports a highly active OLTP application. Users report abnormally long wait times when they submit

You need to identify the root cause of the issue by retrieving the error message. What should you do?

You administer a Microsoft SQL Server database. Users report that an application that accesses the database displays an error, but the error does not provide meaningful information. No entries are

You need to stop a blocking process that has an SPID of 64 without stopping other processes What should you do?

You administer a Microsoft SQL Server 2012 instance. You need to stop a blocking process that has an SPID of 64 without stopping other processes What should you do? A.

Which server-level audit action group should you use?

You administer a Microsoft SQL Server database. You provide temporary securityadmin access to User1 to the database server. You need to know if User1 adds logins to securityadmin. Which server-level

You need to configure the [User1] login to be able to access the Orders database and retain the original permissions. You need to achieve this goal by using the minimum required permissions. Which Transact-SQL statement should you use?

You are migrating a database named Orders to a new server that runs Microsoft SQL Server. You attempt to add a SQL login [User1], to the database. However, you receive

Answer presents part of the solution. Which two actions should you perform? Each

You administer a Microsoft SQL Server database that has Trustworthy set to On. You create a stored procedure that returns database-level information from Dynamic Management Views. You grant User1 access

Answer presents part of the solution. Which three SQL statements should you use? Each

You are the lead database administrator (DBA) of a Microsoft SQL Server environment. All DBAs are members of the DOMAIN\JrDBAs Active Directory group. You grant DOMAIN\JrDBAs access to the SQL

You need to manage users who are prevented from deleting records in the Sales schema. You need to achieve this goal by using the minimum amount of administrative effort. What should you do?

You administer a Microsoft SQL Server database that has multiple tables in the Sales schema. Some users must be prevented from deleting records in any of the tables in the

Which type of user should you create?

You use a contained database named ContosoDb within a domain. You need to create a user who can log on to the ContosoDb database. You also need to ensure that

Answer presents part of the solution. Which permission or permissions should you assign to UserC? Each

You administer a Microsoft SQL Server database. The database has a table named Customers owned by UserA and another table named Orders owned by UserB. You also have a stored

You need to ensure that the application can connect to the named instance. What should you do?

You administer two instances of Microsoft SQL Server. You deploy an application that uses a database on the named instance. The application is unable to connect to the database on

You need to configure SQL Server to send the email messages. What should you configure?

You administer a Microsoft SQL Server 2012 server. When transaction logs grow, SQL Server must send an email message to the database administrators. You need to configure SQL Server to

You need to configure the SQL Server environment to support these packages. What should you do?

You administer a Microsoft SQL Server database server that has SQL Server Integration Services (SSIS) installed. You plan to deploy new SSIS packages to the server. The SSIS packages use

You need to ensure that all the details of the job step failures are retained for SQL Server Agent jobs. What should you do?

You administer a Microsoft SQL Server instance that has several SQL Server Agent jobs configured. When SQL Server Agent jobs fail, the error messages returned by the job steps are

Backup operations do not occur on Server01/HA. How should you configure HaContoso?

You create an availability group named HaContoso that has replicas named Server01/HA, Server02/HA, and Server03/HA. Currently, Server01/HA is the primary replica. You need to ensure that the following requirements are

You need to reduce the occurrence of these timeout errors. What should you do?

You administer several Microsoft SQL Server database servers. Merge replication has been configured for an application that is distributed across offices throughout a wide area network (WAN). Many of the

You also need to minimize the amount of storage used by the database. Which configuration should you use?

Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in

Which configuration should you use?

You administer all the deployments of Microsoft SQL Server 2012 in your company. A database contains a large product catalog that is updated periodically. You need to be able to

Which configuration should you use?

You administer all the deployments of Microsoft SQL Server 2012 in your company. You need to ensure that data changes are sent to a non-SQL Server database server in near

Which configuration should you use?

You administer all the deployments of Microsoft SQL Server 2012 in your company. You need to ensure that an OLTP database that includes up-to-the-minute reporting requirements can be off-loaded from