Online Access Free 070-469 Exam Questions

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.Implement change data capture.
• B.Add a column to the Classifications table to track the status of each classification.
• C.Add columns for each classification to the Customers table.
• D.Add a row to the Customers table each time a classification changes.
• E.Add a table to track any changes made to the classification of each customer.

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.FILLFACTOR = 0
• B.STATISTICS_NORECOMPUTE = ON
• C.FILLFACTOR = 80
• D.STATISTICS_NORECOMPUTE = OFF

You create a view by using the following code:

Several months after you create the view, users report that the view has started to return
unexpected results.
You discover that the design of Table2 was modified since you created the view.
You need to ensure that the view returns the correct results.
Which code segment should you run?

• A.Option B
• B.Option D
• C.Option C
• D.Option A

You have a database that contains a user-defined function named Schema1.Udf1 and two tables named Schema1.Table1 and Schema1.Table2.
Schema1.Table1 has 1 million rows. The schema for Schema1.Table1 is configured as shown in the following table.

Schema1.Udf1 was defined by using the following code:

You need to write a query that will contain the following columns:
---
Country CountryID CustomerName
The solution must meet the following requirements:
--
Rows must be returned only if the function returns data.
The amount of time it takes the query to execute must be minimized.
Which query should you use?

• A.Option B
• B.Option D
• C.Option C
• D.Option A

DRAG DROP
You are designing two stored procedures named Procedure1 and Procedure2.
You identify the following requirements:
- Procedure1 must take a parameter that ensures that multiple rows of data can pass into the stored procedure. - Procedure2 must use business logic that resides in a Microsoft .NET Framework assembly.
You need to identify the appropriate technology for each stored procedure.
Which technologies should you identify?
To answer, drag the appropriate technology to the correct stored procedure in the answer area. (Answer choices may be used once, more than once, or not at all.)

Correct Answer: