- All Exams Instant Download
What should you do?
You administer a Microsoft SQL Server database named Orders. Users report that during peak usage periods, certain operations are taking more time than expected. Your initial analysis suggests that blocking is the cause. You need to gather more data to be able to determine which processes are being blocked and...
You are a database administrator for a Microsoft SQL Server instance.
You are a database administrator for a Microsoft SQL Server instance. You need to ensure that data can be migrated from a production server to two reporting servers with minimal data latency. You also need to ensure that data on the reporting server is always accessible.A . Database SnapshotB ....
Which four Transact-SQL statements should you use?
DRAG DROP You administer a Microsoft SQL Server database server that has a database named Contoso. The Contoso database has a table named EmployeeSalary in a schema named HumanResources. You need to create a script that writes audit events into the application log whenever data in the EmployeeSalary table is...
Which configuration should you use?
You administer all the deployments of Microsoft SQL Server 2012 in your company. You have two servers in the same data center that hosts your production database. You need to ensure that the database remains available if a catastrophic server failure or a disk failure occurs. You also need to...
Which three actions should you perform in sequence?
DRAG DROP You administer a Microsoft SQL Server 2012 server that has multiple databases. You need to ensure that users are unable to create stored procedures that begin with sp_. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to...
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 data into the application. You need to identify which queries are taking longer than 1 second to run over an...
Which three actions should you perform in sequence?
DRAG DROP You administer a Microsoft SQL Server 2012 database. The database uses SQL Server Agent jobs to perform regular FULL and LOG backups. The database uses the FULL recovery model. You plan to perform a bulk import of a very large text file. You need to ensure that the...
Which Transact-SQL batch should you use?
You administer a Microsoft SQL Server 2012 database that contains a table named OrderDetail. You discover that the NCI_OrderDetail_CustomerID non-clustered index is fragmented. You need to reduce fragmentation. You need to achieve this goal without taking the index offline. Which Transact-SQL batch should you use?A . CREATE INDEX NCI_OrderDetail_CustomerID ON...
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 send the entire product catalog to all branch offices on a monthly basis. Which configuration should you use?A . •...
Which three actions should you perform in sequence?
DRAG DROP You administer a Microsoft SQL Server 2012 server that has multiple databases. You need to ensure that users are unable to create stored procedures that begin with sp_. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to...
