Prep and try our 070-459 valid and latest training questions & answers

Microsoft 070-459 Exam Overview:

Microsoft 070-459 Exam Syllabus Topics:

Microsoft Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform Sample Questions:

Question 1

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

Question 2

You have a database hosted on SQL Server 2012 R2. The database contains 5 million rows.
You need to recommend a repeatable method to migrate the database to SQL Database.
Which method should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.

A. Create a SQL Server Integration Services (SSIS) package, and then run the package.
B. Generate scripts to create all of the all database objects and all of the data, and then execute the scripts by using SQL Azure.
C. Extract a data-tier application, and then import the application.
D. Back up the database, and then restore the database.

Question 3

DRAG DROP
You execute the following code: CREATE TA3LS Customers
( id int primary key, name nchar(10) ) GO
You discover that the Customers table was created in the dbo schema.
You need to create a code segment to move the table to another schema named Schema2.
What should you create?
To answer, drag the appropriate code segments to the correct location in the answer area. (Answer choices may be used once, more than once, or not at all.)

Question 4

You are designing your maintenance plan.
Which command should you use only during the monthly maintenance window?

A. DBCC INDEXDEFRAG (ProdDB, SalesOrderDetail, SODIndex)
B. ALTER INDEX SODIndex ON SalesOrderDetail REBUILD WITH (ONLINE * ON)
C. ALTER INDEX SODIndex ON SalesOrderDetail REBUILD
D. ALTER INDEX SODIndex ON SalesOrderDetail REORGANIZE

Question 5

DRAG DROP
You plan to deploy SQL Server 2012.
Your company identifies the following monitoring requirements for the database: - An e-mail message must be sent if the SQL Server Authentication mode changes.
- An e-mail message must be sent if CPU utilization exceeds 90 percent. You need to identify which feature meets each monitoring requirement. Which features should you identify?
To answer, drag the appropriate feature to the correct monitoring requirement in the answer area.

Solutions: