Free Microsoft 070-469 Exam Dumps Questions & Answers

You need to modify the usp_DetectSuspiciousActivity stored procedure.
Which two actions should you perform? Each correct answer presents part of the solution. Choose two.

• A.  Option C
• B.  Option B
• C.  Option A
• D.  Option F
• E.  Option E
• F.  Option D

You have a Microsoft SQL Azure database named DBAzurel. DBAzurel contains a table named Orders that stores sales data.
Each order has a sales total that can only be discovered by querying multiple tables.
You need to ensure that the value of the sales total is returned by executing a query on Orders.
What should you create?

• A.  A trigger that uses a ranking function
• B.  A calculated column that uses a scalar function
• C.  A calculated column that uses a table-valued function
• D.  A trigger that uses a table-valued function

DRAG DROP
You are designing a database for a university. The database will contain two tables named
Classes and StudentGrades that have the following specifications:
- Classes will store brochures in the XPS format. - The brochures must be structured in folders and must be accessible byusing UNC paths. - StudentGrades must be backed up on a separate schedule than the rest ofthe database.
You need to identify which SQL Server technology meets the specifications of each table. Which technologies should you identify? To answer, drag the appropriate technology to the correct table in the answer area.

Correct Answer:

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.  1
• C.  0
• D.  3

You need to recommend a solution to minimize the amount of time it takes to execute USP_5.
What should you include in the recommendation?

• A.  Use the EXECUTE AS clause in USP_5.
• B.  Copy USP.5 to each database.
• C.  Use a server role to group all logins.
• D.  Enable cross-database chaining.