Lead2pass is one of the leading exam preparation material providers. We have a complete range of exams offered by the top vendors of their respective industries. You can download free demos in PDF files and our state of the art exam preparation software. Download the full version for an undeniable success in certification exams. Here are some free share of Microsoft 70-464 exam dumps.
QUESTION 81
You need to provide referential integrity between the Offices table and Employees table.
Which code segment or segments should you add at line 27 of Tables.sql? (Each correct answer presents part of the solution. Choose all that apply.)
A. Option A
B. Option B
C. Option C
D. Option D
Answer: CD
Explanation:
http://msdn.microsoft.com/en-us/library/ms189049.aspx
QUESTION 82
You need to add a new column named Confirmed to the Employees table. The solution must meet the following requirements:
– Have a default value of TRUE.
– Minimize the amount of disk space used.
Which code segment should you use?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: D
QUESTION 83
You execute usp_SelectEmployeesByName multiple times, passing strings of varying lengths to @>LastName.
You discover that usp_SelectEmployeesByName uses inefficient execution plans.
You need to update usp_SelectEmployeesByName to ensure that the most efficient execution plan is used.
What should you add at line 31 of StoredProcedures.sql?
A. OPTION (KEEPFIXED PLAN)
B. OPTION (KEEP PLAN)
C. OPTION (ROBUST PLAN)
D. OPTION (OPTIMIZE FOR UNKNOWN)
Answer: D
Explanation:
http://msdn.microsoft.com/en-us/library/ms181714.aspx
QUESTION 84
You need to recommend a solution to ensure that SQL1 supports the auditing requirements of usp_UpdateEmployeeName.
What should you include in the recommendation?
A. change data capture
B. transactional replication
C. change tracking
D. the Distributed Transaction Coordinator (DTC)
Answer: D
QUESTION 85
You need to create the object used by the parameter of usp_UpdateEmployeeName.
Which code segment should you use?
A. CREATE XML SCHEMA COLLECTION EmployeesInfo
B. CREATE TABLE EmployeesInfo
C. CREATE TYPE EmployeesInfo AS Table
D. CREATE SCHEMA EmployeesInfo
Answer: C
QUESTION 86
You need to create a script that automates the export of the XML data.
The script must meet the integration requirements.
What should you include in the script?
A. The CREATE SERVER ROLE command and the sp_add_proxy, sp_add_job,sp_add_jobstep/ and sp_grant_proxy_to_subsystem system stored procedures.
B. The CREATE CREDENTIAL command and the sp_reassign_proxy, sp_add_job, sp_add_jobstep, and sp_grant_login_to_proxy system stored procedures.
C. The CREATE CREDENTIAL command and the sp_add_proxy, sp_add_job, sp_add_jobstep, and sp_grant_proxy_to_subsystem system stored procedures.
D. The CREATE SERVER ROLE command and the sp_reassign_proxy, sp_add_job, sp_add_jobstep, and sp_grant_login_to_proxy system stored procedures.
Answer: C
QUESTION 87
You need to resolve the performance issues of the usp_ExportOpenings stored procedure.
The solution must minimize the amount of hard disk space used.
Which statement should you execute on DB1?
A. EXEC sp_dboption ‘DB1’, ‘auto create statistics’, ‘TRUE’;
B. CREATE INDEX IX_Exp_Openings ON Openings(PostDate, FilledDate) INCLUDE (Description, Title, Salary);
C. CREATE INDEX IX_Exp_Openings ON Openings(PostDate) INCLUDE (Description, Title, Salary) WHERE FilledDate IS NULL;
D. EXEC sp_recompile ‘usp_ExportOpenings’;
Answer: C
QUESTION 88
You need to implement a solution that meets the job application requirements.
What should you do?
A. Create a one-to-one relationship between the Candidates table and the Applications table.
B. Create a one-to-one relationship between the Openings table and the Applications table.
C. Add a UNIQUE constraint to the Applications table on the OpeningID column and the CandidateID column.
D. Add a UNIQUE constraint to the Applications table on the ApplicationID column and CandidateID column.
Answer: C
QUESTION 89
You need to identify the cause of the page split issues.
Which SQL Server feature should you use?
A. DBCC TRACEOFF
B. DBCC REINDEX
C. Extended Events
D. SQL Server Profiler
Answer: C
QUESTION 90
You need to design a solution that meets the refactoring requirements.
Which type of object should you include in the solution?
A. A table-valued function
B. A distributed view
C. An aggregate function
D. An indexed view
Answer: A
No doubt, 70-464 exam is worth challenging task but you should not feel hesitant against the confronting difficulties. Get a complete hold on 70-464 exam syllabus through Lead2pass training and boost up your skills. No need to hassle if you are stuck in exam difficulties, Lead2pass will assist you right through exam specific preparation material. Lead2pass delivers the most comprehensive preparation material, covering each and every aspect of 70-464 exam curriculum.
