Which of the following is TRUE with regards to the CHECK OPTION?
You work as a senior developer at ABC.com. The ABC.com network consists of a single domain
named ABC.com.
You are running a training exercise for junior developers. You are currently discussing the CHECK
OPTION of the CREATE VIEW Transact-SQL statement.
Which of the following is TRUE with regards to the CHECK OPTION?
Which of the following describes how you should partition the table?
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 received by the company in the last 10 years.
You want to partition improve the performance of SalesDB by partitioning the Orders table
into 10 partitions based on year.
Which of the following describes how you should partition the table?
Which of the following is TRUE with regards to XML schema collections?
You work as a senior developer at ABC.com. The ABC.com network consists of a single domain
named ABC.com.
You are running a training exercise for junior developers. You are currently discussing XML
schema collections.
Which of the following is TRUE with regards to XML schema collections?
You need to implement a solution to ensure that all servers adhere to the company security policy
You work as a Database Administrator (DBA) for a company named ABC.com. The
company uses a Microsoft SQL Server 2012 infrastructure that includes more than 50
servers.
A new company security policy states a list of minimum security requirements for all SQL
servers.
You need to implement a solution to ensure that all servers adhere to the company security
policy.
What should you do?
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.
An existing database includes a table whose ID column has a clustered index definition. You are in
the process of creating a script to generate a stored procedure that should allow for the number of
locks and deadlocks to be reduced.
Which of the following actions should you take?
How can you meet these requirements?
You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on
Windows Server 2012 servers running SQL Server 2012.
The company has a database named Products. Tables in the Products database contain
data including part numbers, product name, color, type and size.
Users in the Marketing department have created brochures for each product. The
brochures have been created in the XML Paper Specification (XPS) format.
You have been asked to add a table to the Products database to store the product
brochures. The brochures need to be stored in a folder structure. Company users will also
need to access the brochures from Windows applications using UNC paths.
How can you meet these requirements?
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.
You have created a new table in an existing database. You want to make sure that a user-defined
function is called to validate the row prior to a new row being added to the table.
Which of the following actions should you take?
What should you configure?
You work as a Database Administrator (DBA) for a company named ABC.com. The
company uses a Microsoft SQL Server 2012 infrastructure.
You have a database named CorpDB. The CorpDB database contains a table named
SalesInfo.
You discover that some information has been deleted from the SalesInfo table. You are
unable to find out who deleted the information.
You need to implement a solution to monitor the deletion of any further information from
the SalesInfo table. You want to minimize the development effort required for the solution.
What should you configure?
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 subscribes to SQL Azure, which hosts a ABC.com database used for Online
Transaction Processing (OLTP).
A table in the database contains an index that makes use of too much physical disk space. You
have been instructed to make sure that the physical disk space used by the index is reduced.
Which of the following actions should you take?
Which of the following solutions would provide the high-availability and enable users to run reports on both c
You work as a Database Administrator (DBA) for a company named ABC.com. The
company uses a Microsoft SQL Server 2012 infrastructure.
A server named ABC-SQL1 hosts multiple databases that are accessed using OLTP (Online
Transaction Processing) applications.
You are concerned about the lack of redundancy provided by this single server solution.
You want to configure a solution that ensures high-availability for the databases while
minimizing costs. You need to ensure that the databases remain online in the event of a
hardware failure of ABC-SQL1.
You configure a second server named ABC-SQL2 and install SQL Server 2012.
Which of the following solutions would provide the high-availability and enable users to
run reports on both copies of the databases?