Which of the following is TRUE with regards to columnstore indexes?
You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com.
ABC.com has a SQL Server 2012 database table that includes a million rows. You have
configured a column in the table with a columnstore index.
Which of the following is TRUE with regards to columnstore indexes?
What is the minimum number of servers required for each solution?
You work as a Systems Administrator at a company named ABC.com. You are in the
process of deploying new servers running SQL Server 2012.
You need to implement a highly available solution. You need to ensure that the databases
remain online in the event of a single server failure.
You are evaluating the server requirements for AlwaysOn with automatic failover and
mirroring with automatic failover.
What is the minimum number of servers required for each solution? (Choose two).
Which of the following actions should you take?
You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com.
ABC.com has a server, named ABC-SR13, which runs SQL Server 2012. You are instructed to
find out what parallel execution plans are processing serially.
Which of the following actions should you take?
How can you generate a report to display the most frequent wait types that occur on ABC SQL1?
You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on
Windows Server 2012 servers running SQL Server 2012.
One server is named ABC-SQL1. You want to gather information about all the waits
encountered on ABC-SQL1 by threads that execute.
How can you generate a report to display the most frequent wait types that occur on ABC
SQL1?
Which of the following actions should you take?
You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com.
You have been informed of several deadlocks on an existing ABC.com database, named
ABCDB1. You have been tasked with devising a strategy to examine the deadlocks in real-time.
The strategy should allow for trouble-free enabling and disabling, and also allow monitored
information to be queried.
Which of the following actions should you take?
What should you include in your recommendation?
You work as a Systems Administrator at a company named ABC.com. You are in the
process of deploying new servers running SQL Server 2012.
You install a new server named ABC-SQL07. A week later, you receive reports of poor
database performance. You discover that at the times of poor performance, the CPU is
running at nearly 100% utilization.
You need to recommend a monitoring solution for ABC-SQL07 that will send you an email
alert if the CPU utilization is more than 80%.
What should you include in your recommendation?
Which of the following actions should you take?
You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com. ABC.com makes use of SQL Server 2012 in their environment.
Subsequent to creating a database, you are preparing to generate two stored procedures. The
stored procedures will be named ABCSPA and ABCSPB. ABCSPA should be configured to return
a table and ABCSPB should be configured to return status code.
You want to make sure that the prerequisites are suitably met.
Which of the following actions should you take? (Choose all that apply.)
How can you achieve this goal?
You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on
Windows Server 2012 servers running SQL Server 2012.
The Sales department uses a database named SalesDB. SalesDB contains a large table
named Orders that lists every order ever received by the company.
You want to improve the performance of SalesDB. You want to configure the database to
provide the fastest possible access to the most recent orders. Historical orders can be
stored using a slower storage solution.
How can you achieve this goal?
Which of the following is the option that should be included in the code?
You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com. ABC.com subscribes to SQL Azure, which hosts a ABC.com database.
You are in the process of creating a script to generate a view. This view is intended for updating
table data.
You have been instructed to make sure that view is able to update table data, but not the data in a
specific column.
Which of the following is the option that should be included in the code?
Which of the following would be most suitable password storage solution?
You work as a Developer at ABC.com. All databases are hosted on Windows Server 2012
servers running SQL Server 2012.
You are developing a custom CRM application named CorpCRM. The application will store
usernames and passwords in a SQL Server 2012 database named CorpCRMDB1.
You need to ensure the usernames and passwords are secure.
Which of the following would be most suitable password storage solution?