PrepAway - Latest Free Exam Questions & Answers

Category: 70-464 (v.3)

Briefing 70-464: Developing Microsoft SQL Server 2012 Databases (update January 2nd, 2018)

Which code segment should you use to create the table?

You are creating a stored procedure named usp1. Usp1 will create a table that will be used during the execution
of usp1. Only usp1 will be allowed to access the table.
You need to write the code required to create the table for usp1. The solution must minimize the need to
recompile the stored procedure.
Which code segment should you use to create the table?

Which technologies should you identify?

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 by using UNC paths.
StudentGrades must be backed up on a separate schedule than the rest of the 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.
Select and Place:

Which data types should you recommend for each column?

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.
Select and Place:

You need to create a distributed partitioned view

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 of network traffic.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

Which code segment should you execute?

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 perform transaction 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 and arrange them in the correct order.
Select and Place:

Which options should you recommend?

You plan to deploy SQL Server 2012. You must create two tables named Table1 and Table2 that will have the
following specifications:
Table1 will contain a date column named Column1 that will contain a null value approximately 80 percent of
the time.
Table2 will contain a column named Column2 that is the product of two other 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 must minimize 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.
Select and Place:

What should you add to the query?

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?


Page 4 of 19« First...23456...10...Last »