You create a view by using the following code:

Several months after you create the view, users report that the view has started to return
unexpected results.
You discover that the design of Table2 was modified since you created the view.
You need to ensure that the view returns the correct results.
Which code segment should you run?

DRAG DROP
You are planning two stored procedures named SProc1 and SProc2.
You identify the following requirements:
SProc1 must return a table.
SProc2 must return a scalar value.
You need to identify which option must be implemented for each stored procedure to return
the desired data.
Which options should you identify?

To answer, drag the appropriate option to the correct requirement in the answer area.
(Answer choices may be used once, more than once, or not at all.)

Your company has a main office in London and a branch office in New York.
Your network contains a server named Server5 that has SQL Server 2012 installed.
Serverscontains a database name ContentDB and a table named ContentTable.
You add an additional server named Server9 that runs SQL Server 2012.
You need to create a distributed partitioned view. The solution must minimize the amount of
network traffic.

What should you do? (Each correct answer presents part of the solution. Choose all that
apply.)

You need to encapsulate a T-SQL script into a reusable user-defined object.
The object must meet the following requirements:
Permit insertions into a table variable.
Support structured exception handling.
Prevent changes to the definition of referenced objects.
Support the use of the APPLY operator on the output of the object.
Which type of object should you use?

You plan to migrate an instance of SQL Server 2008 to a new installation of SQL Server
2012.
You need to migrate alerts and e-mail notifications.
Which system stored procedures should you use? (Each correct answer presents part of the
solution. Choose all that apply.)

You have a Microsoft SQL Azure database that contains a table named Customers.
You have a table-valued function named TopCustomers that returns a list of all the
customers that have purchased items during the last 12 months. The ID of the customer is
passed as an argument to the TopCustomers function.
You need to create a query that returns a list of all the Customer names and the purchase
dates.
The solution must return only customers that have purchased an item during the last 12
months.
What should you add to the query?

You have a SQL Server 2012 database named Database1.
You execute the following code:

You insert 3 million rows into Sales.
You need to reduce the amount of time it takes to execute Proc1.
What should you do?

DRAG DROP
You are designing a database for a university. The database will contain two tables named
Classes and StudentGrades that have the following specifications:
Classes will store brochures in the XPS format.
The brochures must be structured in folders and must be accessible byusing UNC paths.
StudentGrades must be backed up on a separate schedule than the rest ofthe database.
You need to identify which SQL Server technology meets the specifications of each table.
Which technologies should you identify? To answer, drag the appropriate technology to the
correct tablein the answer area.

DRAG DROP
You have a SQL Azure database named Database1. You need to design the schema for a
tablenamed table1.
Table1 will have less than one million rows. Table1 will contain the following information
foreach row:
The solution must minimize the amount of space used to store each row. Which data
types should you recommend for each column? To answer, drag the appropriate data type to
the correctcolumn in the answer area.

Your network contains a server named SQL1 that has SQL Server 2012 installed. SQL1
contains
a database name DB1 and a table named Customers.
You add an additional server named SQL2 that runs SQL Server 2012.
You need to create a distributed partitioned view. The solution must minimize the amount
ofnetwork traffic.
What should you do? (Each correct answer presents part of the solution. Choose all that
apply.)