Free Microsoft 070-459 Exam Dumps Questions & Answers


Exam Code/Number:	070-459Join the discussion
Exam Name:	Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform
Certification:	Microsoft
Free Question Number:	114
Publish Date:	Sep 23, 2026
# of views:	2752
Rating 100%

Page: 1 / 23
Total 114 questions

Question 1

You execute the following code.

You need to reduce the amount of time it takes to execute the query. What should you do?

A.Partition the table and use the JobTitle column for the partition scheme.
B.Change SUBSTRING(JobTitle,1, 1) = 'C' to JobTitle LIKE `C%'.
C.Replace IX_Employees with a clustered index.
D.Change SUBSTRING (JobTitle, 1, 1) = 'C' to LEFT(JobTitle ,1) = 'C'.

Question 2

You have an index for a table in a SQL Azure database. The database is used for Online Transaction Processing (OLTP).
You discover that many page splits occur when records are inserted or updated in the table.
You need to minimize the number of page splits.
What should you set from the index options?

A.STATISTICS_NORECOMPUTE = OFF
B.STATISTICS_NORECOMPUTE = ON
C.FILLFACTOR = 80
D.FILLFACTOR = 0

Question 3

You need to monitor the health of your tables and indexes in order to implement the required index maintenance strategy.
What should you do?

A.Query system DMVs to monitor total_bucket_count. Create alerts to notify you when this value decreases.
B.Create a SQL Agent alert when the File Table: Avg time per file I/O request value is increasing.
C.Query system DMVs to monitor total_bucket_count. Create alerts to notify you when this value increases.
D.Query system DMVs to monitor avg_chain_length and max_chain_length. Create alerts to notify you when these values converge.

Question 4

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 (ROBUST plan)
C.OPTION (OPTIMIZE FOR UNKNOWN)
D.OPTION (KEEP PLAN)

Question 5

You need to create the object used by the parameter of usp_UpdateEmployeeName. Which code segment should you use?

A.CREATE TABLE EmployeesInfo
B.CREATE XML SCHEMA COLLECTION EmployeesInfo
C.CREATE TYPE EmployeesInfo AS Table
D.CREATE SCHEMA EmployeesInfo