Microsoft 70-469 - Recertification for MCSE: Data Platform Exam
Page: 3 / 57
Total 281 questions
Question #11 (Topic: Topic 2)
While testing usp.GetFutureSessions, you discover that IX_Sessions is accessed by a
scan rather than a seek.
You need to minimize the amount of time it takes to execute usp_GetFutureSessions.
What should you do? (Each correct answer presents part of the solution. Choose all that
apply.)
[Microsoft-70-469-5.0/Microsoft-70-469-20_2.png]
scan rather than a seek.
You need to minimize the amount of time it takes to execute usp_GetFutureSessions.
What should you do? (Each correct answer presents part of the solution. Choose all that
apply.)
[Microsoft-70-469-5.0/Microsoft-70-469-20_2.png]
A. Option A
B. Option B
C. Option C
D. Option D
E. Option E
F. Option F
Answer: B,E
Question #12 (Topic: Topic 2)
You need to provide referential integrity between the Sessions table and Speakers table.
Which code segment should you add at line 47 of Tables.sql?
[Microsoft-70-469-5.0/Microsoft-70-469-21_2.png]
Which code segment should you add at line 47 of Tables.sql?
[Microsoft-70-469-5.0/Microsoft-70-469-21_2.png]
A. Option A
B. Option B
C. Option C
D. Option D
Answer: B
Question #13 (Topic: Topic 2)
You need to create the object used by the parameter of usp_InsertSessions.
Which statement should you use?
Which statement should you use?
A. CREATE XML SCHEMA COLLECTION SessionDataTable
B. CREATE TYPE SessionDataTable AS Table
C. CREATE SCHEMA SessionDataTable
D. CREATE TABLE SessionDataTable
Answer: B
Question #14 (Topic: Topic 2)
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?
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
Question #15 (Topic: Topic 2)
You discover that usp.SelectSpeakersByName executes slowly if
usp_UpdateSpeakerName executes simultaneously.
You need to minimize the execution time of usp.SelectSpeakersByName. The solution
must not affect the performance of the other stored procedures.
What should you update?
usp_UpdateSpeakerName executes simultaneously.
You need to minimize the execution time of usp.SelectSpeakersByName. The solution
must not affect the performance of the other stored procedures.
What should you update?
A. Usp_UpdateSpeakerName to use the NOLOCK query hint
B. Usp_UpdateSpeakerName to use snapshot isolation
C. Usp_SelectSpeakersByName to use the NOLOCK query hint
D. Usp_SelectSpeakersByName to use snapshot isolation
Answer: C
