Online Access Free 70-469 Exam Questions

You have a database hosted on SQL Azure.
You are developing a script to create a view that will be used to update the data in a table.
The following is the relevant portion of the script. (Line numbers are included for reference
only.)

You need to ensure that the view can update the data in the table, except for the data in Column1.
Which code segment should you add at line 06?

• A.WITH SCHEMABINDING
• B.WITH CHECK OPTION
• C.WITH VIEW_METADATA
• D.WITH ENCRYPTION

You are creating a stored procedure named usp1. Usp1 will create a table that will be used during the execution of usp1. Only usp1 will be allowed to access the table.
You need to write the code required to create the table for usp1. The solution must minimize the need to recompile the stored procedure.
Which code segment should you use to create the table?

• A.CREATE TABLE ##oneTable
• B.DECLARE oneTable TABLE
• C.CREATE TABLE #oneTable
• D.CREATE TABLE oneTable

You have a database that contains a table named Department. Department contains the names and locations of each department.
You have a table-valued function named ProjectList() that returns a list of all the projects assigned to a department. The name of the department is passed as an argument to the ProjectList() function.
You need to create a query that returns a list of all the department names and the project names. The solution must return only departments that are associated to projects.
What should you add to the query?

• A.OUTER APPLY
• B.CROSS JOIN
• C.OUTER JOIN
• D.CROSS APPLY

DRAG DROP
You need to implement a new version of usp_AddMobileLocation. Develop the solution by selecting and arranging the required code blocks in the correct order. You may not need all of the code blocks.

Correct Answer:

You plan to create a stored procedure that inserts data from an XML file to the OrderDetails table. The following is the signature of the stored procedure:

The following is the XSD file used to create the ValidateOrder schema collection:

You develop a code segment that retrieves the number of items and loops through each
item. Each time the loop runs, a variable named @itemNumber is incremented.
You need to develop a code segment that retrieves the product ID of each item number in the loop.
Which code segment should you develop?

• A.SET @productID = @items.value'/Root/Product['+ @itemNumber+ ']/productID', int)
• B.SET @productID = @items.value'/Root/Product/@productID', int)
• C.SET @productID = @items.value'/Root/Product['+ @itemNumber+ ']/@productID', int)
• D.SET @productID = @items.value'/Root/Product/productID', int)