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?

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 Azure database named Database1. You need to design the schema for a
table named table1.
Table1 will have less than one million rows. Table1 will contain the following information
for each 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 correct column in the answer area.

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 table in the answer area.

DRAG DROP
You plan to deploy SQL Server 2012. You must create two tables named Table1 and Table2
thatwill have the following specifications:
Table1 will contain a date column named Column1 that will contain a nullvalue
approximately 80 percent of the time.
Table2 will contain a column named Column2 that is the product of twoother columns in
Table2.
Both Table1 and Table2 will contain more than 1 million rows.
You need to recommend which options must be defined for the columns. The solution
mustminimize the storage requirements for the tables. Which options should you
recommend? To answer, drag the appropriate options to the correct column in the answer area.

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.