Try and practice the latest Microsoft : 70-459 real questions & answers

You have a SQL Azure database.
You execute the following script:

You add 1 million rows to Table1. Approximately 85 percent of all the rows have a null value for Column2.
You plan to deploy an application that will search Column2.
You need to create an index on Table1 to support the planned deployment. The solution must minimize the storage requirements.
Which code segment should you execute?

• A. CREATE INDEX IX_Table1 ON Table1 (Column2) WITH FILLFACTOR=0
• B. CREATE INDEX IX_Table1 ON Table1 (Column2) WHERE Column2 IS NOT NULL
• C. CREATE INDEX IX_Table1 ON Table1 (Column2) WHERE Column2 IS NULL
• D. CREATE INDEX IX_Table1 ON Table1 (Column1) INCLUDE (Column2)

You need to recommend a solution for the planned changes to the customer classifications.
What should you recommend? (Each correct answer presents part of the solution. Choose all that apply.)

• A. Add a table to track any changes made to the classification of each customer.
• B. Add a row to the Customers table each time a classification changes.
• C. Add a column to the Classifications table to track the status of each classification.
• D. Add columns for each classification to the Customers table.
• E. Implement change data capture.

You administer an instance of SQL Server 2014.
You are tasked with tuning a common set of queries. You have the results of several test executions, along with query plans. The schema and the data for all database object(s) used remain unchanged between executions. The QueryTime column is defined as a computed column that uses the GETDATEO system function. The query plans and results are shown below:

You need to make an initial diagnosis of the situation, based solely on this input.
Which two statements can you make about the performance characteristics of this query? Each correct answer presents a complete solution. Choose two.

• A. The queries would perform better if the index named AccountNumber included the Name and QueryTime column.
• B. The object Account is a view, joining the Account-AccountNumber and Account.PKAccount objects together.
• C. The queries would perform worse if the index named AccountNumber included the NameColumn.
• D. The object Account is a table, with an index having a leading column of AccountNumber and a Clustered Index named PKAccount.
• E. The queries would perform better if the index named AccountNumber included the Name column.
• F. The object Account is an indexed view, with an index having a leading column of AccountNumber and a Clustered Index named PKAccount.

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?

• A. ALTER TABLE Attendees
  ADD Confirmed char(1) DEFAULT '0';
• B. ALTER TABLE Attendees
  ADD Confirmed bit DEFAULT 1;
• C. ALTER TABLE Attendees
  ADD Confirmed char(1) DEFAULT '1';
• D. ALTER TABLE Attendees
  ADD Confirmed bit DEFAULT 0;

You have a server that has SQL Server 2012 installed.
You need to identify which parallel execution plans are running in serial.
Which tool should you use?

• A. Data Profile Viewer
• B. Performance Monitor
• C. Database Engine Tuning Advisor
• D. Extended Events