- All Exams Instant Download
What should you do?
You administer a Microsoft SQL Server 2012 database. The database contains a customer table created by using the following definition: You need to ensure that the minimum amount of disk space is used to store the data in the customer table. What should you do?A . Implement row-level compression.B ....
What should you do?
You administer a Microsoft SQL Server 2012 database. The database contains a Product table created by using the following definition: You need to ensure that the minimum amount of disk space is used to store the data in the Product table. What should you do?A . Convert all indexes to...
Which Transact-SQL statement 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 the series. You administer a SQL Server 2012 server that contains a database named SalesDB. SalesDb contains a schema named...
Which three SQL statements should you use?
You are the lead database administrator (DBA) of a Microsoft SQL Server environment. All DBAs are members of the DOMAINJrDBAs Active Directory group. You grant DOMAINJrDBAs access to the SQL Server. You need to create a server role named SpecialDBARole that can perform the following functions: - View all databases....
What should you do?
Note: This question is part of a series of questions that use the same set of answers choices. An answer choice may be correct for more than one question in the series. You administer a Microsoft SQL Server that hosts a transactional database and a reporting database. The transactional database...
Which type of solution should you use?
You administer a Microsoft SQL Server database that includes a table named dbo.Log. This table contains millions of records about user activity in an application. Records in dbo.Log that are more than 90 days old are purged nightly. When records are purged, table locks are causing contention with inserts. You...
Which three actions should you perform in sequence?
DRAG DROP You administer a Microsoft SQL Server instance. You use a two-node SQL Server failover cluster. Node B is primary, and Node A is secondary. You need to install a security patch on both nodes. You need to ensure that the following requirements are met: - Both nodes receive...
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 2 terabytes is located on a dedicated LUN (drive D). - A transaction log of 10 GB is located...
What should you do?
Note: This question is part of a series of questions that use the same set of answers choices. An answer choice may be correct for more than one question in the series. You administer a Microsoft SQL Server that hosts a transactional database and a reporting database. The transactional database...
What should you create?
You administer a Microsoft SQL Server database named Contoso on a server named Server01. You need to write messages to the Application Log when users are added to or removed from a fixed server role in Server01. What should you create?A . A Database Audit SpecificationB . A PolicyC ....
