Online Access Free 070-469 Practice Test

You plan to execute the following code:

You need to identify how many rows will be in dbo.Table1 after you execute the code. How many rows should you identify?

• A.2
• B.0
• C.1
• D.3

You need to create the InvoiceStatus table in DB1.
How should you define the InvoiceID column in the CREATE TABLE statement?

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

DRAG DROP
You need to optimize the index and table structures for POSTransaction.
Which task should you use with each maintenance step? To answer, drag the appropriate tasks to the correct maintenance steps. Each task may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

Correct Answer:

You need to recommend a change to USP_3 to ensure that the procedure continues to execute even if one of the UPDATE statements fails.
Which change should you recommend?

• A.Set the XACT_ABORT option to off.
• B.Set the IMPLICIT_TRANSACTIONS option to off.
• C.Set the XACT_ABORT option to on.
• D.Set the IMPLICIT_TRANSACTIONS option to on.

You have a SQL Server 2012 instance that hosts a single-user database.
The database does not contain user-created stored procedures or user-created functions.
You need to minimize the amount of memory used for query plan caching.
Which advanced server option should you modify?

• A.Allow Triggers to Fire Others
• B.Scan for Startup Procs
• C.Optimize for Ad hoc Workloads
• D.Enable Contained Databases