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 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.)

DRAG DROP
You have a SQL Server 2012 database named Database1. Database1 has a data file
named database1_data.mdf and a transaction log file named database1_Log.ldf.
Database1_Data.mdf is 1.5 GB.
Database1_Log.ldf is 1.5 terabytes. A full backup of Database1 is performed every day.
You need to reduce the size of the log file. The solution must ensure that you can
performtransaction log backups in the future. Which code segment should you execute? To
answer,move the appropriate code segments from the list of code segments to the answer
area andarrange them in the correct order.