Tips to Pass 70-464 Exam (9 to 16)

Act now and download your Microsoft 70-464 test today! Do not waste time for the worthless Microsoft 70-464 tutorials. Download Renovate Microsoft Developing Microsoft SQL Server 2012 Databases exam with real questions and answers and begin to learn Microsoft 70-464 with a classic professional.

Q9. Which data type should you use for CustomerID? 

A. varchar(11) 

B. bigint 

C. nvarchar(11) 

D. char(11) 

Answer: D 

Explanation: 

Invoices.xml All customer IDs are 11 digits. The first three digits of a customer ID represent the customer's country. The remaining eight digits are the customer's account number. int: -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647) (just 10 digits max) bigint: -2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807) http://msdn.microsoft.com/en-us/library/ms176089.aspx http://msdn.microsoft.com/en-us/library/ms187745.aspx 

Q10. Topic 8) 

You plan to create a custom aggregation function named Function1. 

You plan to deploy Function1 to SQL Server 2012. 

You need to ensure that Function1 can access a web service. The solution must minimize 

the number of changes made to the database. 

You create a Microsoft .NET Framework class that contains the definition of Function1. 

You upload a certificate to SQL Server. 

What three tasks should you perform next? 

To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. 

Answer: 

Q11. You need to create the object used by the parameter of usp_InsertSessions. 

Which statement should you use? 

A. CREATE SCHEMA SessionDataTable 

B. CREATE TYPE SessionDataTable AS Table 

C. CREATE TABLE SessionDataTable 

D. CREATE XML SCHEMA COLLECTION SessionDataTable 

Answer: A 

Q12. You need to implement a solution that meets the security requirements. Which statement should you execute? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer: A 

Q13. Topic 8) 

You have a SQL Server 2012 database named Database1. Database1 has a data file named Database1_data.mdf and a transaction log named Database1jog.ldf. Database1_data.mdf is 1.5 GB. Database1jog.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. 

Answer: 

Q14. You need to add a new column named Confirmed to the Attendees table. 

The solution must meet the following requirements: 

. Have a default value of false. 

. Minimize the amount of disk space used. 

Which code block should you use? 

A. ALTER TABLE Attendees 

ADD Confirmed bit DEFAULT 0; 

B. ALTER TABLE Attendees 

ADD Confirmed char(l) DEFAULT '1' 

C. ALTER TABLE Attendees 

ADD Confirmed bit DEFAULT 1; 

D. ALTER TABLE Attendees 

ADD Confirmed char(l) DEFAULT ‘1’; 

Answer: A 

Explanation: 

http://msdn.microsoft.com/en-us/library/ms177603.aspx 

Q15. 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? 

A. CREATE TABLE oneTable 

B. CREATE TABLE ##oneTable 

C. CREATE TABLE #oneTable 

D. DECLARE oneTable TABLE 

Answer: B 

Q16. You need to modify usp_GetOrdersAndItems to ensure that an order is NOT retrieved by usp_GetOrdersAndItems while the order is being updated. 

What should you add to usp_GetOrdersAndItems? 

A. Add SET TRANSACTION ISOLATION LEVEL SERIALIZABLE to line 03. 

B. Add SET TRANSACTION ISOLATION LEVEL SNAPSHOT to line 03. 

C. Add (UPDLOCK) to the end of line 06. 

D. Add (READPAST) to the end of line 06. 

Answer: D 

55. You need to implement a solution that addresses the bulk insert requirements. 

What should you add to line 08 in usp_ImportOrderDetails? 

A. LASTROW=0. 

B. BATCHSIZE=0. 

C. BATCHSIZE=1000. 

D. LASTROW = 1000. 

Answer: C