web analytics

You need to recommend a management strategy for the SQL Server 2014 servers. What should you include in the recommendation? More than one answer choice may achieve the goal. Select the BEST answer.

You have a SQL Server 2014 environment that contains 20 servers. The corporate security policy states that all SQL Server 2014 instances must meet specific security standards. You need to

What should you do? More than one answer choice may achieve the goal. Select the BEST answer.

You are the administrator for a SQL Server 2014 instance that stores the data for an online transaction processing sales system. The company takes full backups every week; differential backups

What should you recommend?

You deploy a database by using SQL Server 2014. The database contains a table named Table1. You need to recommend a solution to track all of the deletions executed on

What should you include in the recommendation? More than one answer choice may achieve the goal. Select the BEST answer.

You have a server named Server1 that has 2 processors. You plan to deploy multiple instances of SQL Server 2014 to Server1. Each instance will have multiple databases. You need

What should you include in the recommendation?

You have a SQL Server 2014 database named DB1. You plan to import a large number of records from a SQL Azure database to DB1. You need to recommend a

What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

You have a server that has SQL Server 2014 installed. The server contains 100 user databases. You need to recommend a backup solution for the user databases. The solution must

What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

You are designing a database named DB1. Changes will be deployed to DB1 every Wednesday night. You need to recommend a strategy to deploy the changes to DB1. The strategy

Which method should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

You have a database hosted on SQL Server 2012 R2. The database contains 5 million rows. You need to recommend a repeatable method to migrate the database to SQL Azure.

What should you include in the recommendation? More than one answer choice may achieve the goal. Select the BEST answer.

You are designing a monitoring application for a new SQL Server 2014 instance. You need to recommend a solution to generate a report that displays the 10 most frequent wait

Whether the database restore is still executing and, if it is, what percentage of the restore is complete. Which system objects should you use in your query to best achieve this task?

You administer a SQL Server 2014 instance. Users report that the SQL Server has seemed slow today. A large database was being restored for much of the day, which could

What should you include in the design? More than one answer choice may achieve the goal. Select the BEST answer.

You have four databases that are accessed by using an Online Transaction Processing (OLTP) application. The databases are stored on a server named SQL1 that has SQL Server 2014 installed.

What should you do? More than one answer choice may achieve the goal. Select the BEST answer.

You are troubleshooting an application that runs a query. The application frequently causes deadlocks. You need to identify the isolation level used by the query when a deadlock occurs. What

What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

You have a query that is used by a reporting dashboard. Users report that the query sometimes takes a long time to run. You need to recommend a solution to

What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

You are creating a database that will store usernames and credit card numbers for an application. You need to recommend a solution to store and reuse the credit card numbers

What should you include in the design?

You are building a stored procedure for a Windows Azure SQL Database. The procedure will add multiple rows to a table. You need to design the stored procedure to meet

What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

You plan to create a database. The database will be used by a Microsoft .NET application for a special event that will last for two days. During the event, data

What should you use? More than one answer choice may achieve the goal. Select the BEST answer.

You have two SQL Server 2014 instances named SQLDev and SQLProd. You plan to create a new database on SQLProd that will use SQL Server Authentication. You need to ensure

What should you include in the recommendation? More than one answer choice may achieve the goal. Select the BEST answer.

You have a server named Server1 that has 16 processors. You plan to deploy multiple instances of SQL Server 2014 to Server1. You need to recommend a method to allocate

What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

You are creating a database that will store usernames and passwords for an application. You need to recommend a solution to store the passwords in the database. What should you

What should you include in the recommendation? More than one answer choice may achieve the goal. Select the BEST answer.

You have two databases named DB1 and DB2 that are located on the same server. You plan to create a stored procedure named SProc1 in DB1. SProc1 will query a

What should you do? More than one answer choice may achieve the goal. Select the BEST answer.

You are troubleshooting an application that runs a query. The application frequently causes deadlocks. You need to identify which transaction causes the deadlock. What should you do? More than one

You need to set up a monitoring process that will capture any cases where statistics could have been useful if they existed. What should you do?

You are the new database administrator for a SQL Server 2014 instance. You conduct an assessment on the instance and determine that the auto create statistics setting on the database

You need to view all of the performance statistics for each database file. Which method should you use?

You manage a SQL Server 2014 instance that contains a database named DB1. Users report that some queries to DB1 take longer than expected. Although most queries run in less

What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

You have two SQL Server instances named SQLDev and SQLProd that have access to various storage media. You plan to synchronize SQLDev and SQLProd. You need to recommend a solution

What should you recommend?

Your network contains an Active Directory domain that has two groups named Group1 and Group2. The domain contains two SQL Server instances named SQLDev and SQLProd. Each SQL Server instance

What should you do? More than one answer choice may achieve the goal. Select the BEST answer.

You have a database named DB1. You plan to create a stored procedure that will insert rows into three different tables. Each insert must use the same identifying value for

Which SQL elements should you include in the recommendation? (Each correct answer presents part of the solution. Choose all that apply.)

You have an SQL Server 2014 instance named SQL1. SQL1 creates error events in the Windows Application event log. You need to recommend a solution that will run an application

You need to recommend a solution to monitor the transactions that are running currently against SQLProd. The solution must minimize the amount of custom code required. What should you recommend?

You deploy a SQL Server instance named SQLProd that uses SQL Server 2014. You need to recommend a solution to monitor the transactions that are running currently against SQLProd. The

What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

You have a SQL Server instance on a server named Server1. You need to recommend a solution to perform the following tasks every week: Rebuild the indexes by using a

What should you recommend?

You create a stored procedure that retrieves all of the rows from a table named Table1. You need to recommend a solution to ensure that all of the statements in