Lead2pass Microsoft 70-464 practice tests are composed of latest exam questions formulate an actual exam scenario with an intent to expose your potentials and latent skills. Our Microsoft practice tests encompass all the fundamental of Microsoft 70-464 exam formats, orients your efforts towards guaranteed success for Microsoft 70-464 exams. You can hit your target with assurance if you have opted for our practice test training.
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
Choose Lead2pass you will get:
Most updated collection of Microsoft 70-464 Exam Questions;
Prepare according to the latest Microsoft 70-464 Exam Syllabus;
Product is instantly available for download and use;
24×7 Customer Support on case of problemwith the product.
http://www.lead2pass.com/70-464.html
