Microsoft Recertification for MCSE: Data Platform - 70-469 Exam Questions

QUESTION NO: 1
You need to recommend a solution for the error handling of USP_4. The solution must handle errors for nested stored procedures in the code for USP_4.
What should you recommend?

QUESTION NO: 2
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.)

QUESTION NO: 3
You need to recommend a feature to support your backup solution.
What should you include in the recommendation?

QUESTION NO: 4
Your company has a main office in London and a branch office in New York.
Your network contains a server named Server5 that has SQL Server 2012 installed. Server5 contains a database name ContentDB and a table named ContentTable.
You add an additional server named Server9 that runs SQL Server 2012.
You need to create a distributed partitioned view. The solution must minimize the amount of network traffic.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

QUESTION NO: 5
You need to create a script that automates the export of the XML data. The script must meet the integration requirements.
What should you include in the script?

QUESTION NO: 6
You are evaluating the table design.
You need to recommend a change to Tables.sql that reduces the amount of time it takes
for usp_AttendeesReport to execute.
What should you add at line 14 of Tables.sql?

QUESTION NO: 7
You plan to create a database that has multiple tables. The tables will contain product information. Each product has a stock-keeping unit (SKU).
You need to recommend a solution to ensure that each SKU starts with the letters "ADV" and is followed by 10 digits.
The solution must minimize the amount of development effort required.
What should you include in the recommendation?

QUESTION NO: 8
You have a text file that contains an XML Schema Definition (XSD).
You have a table named Schema1.Table1.
You have a stored procedure named Schema1.Proc1 that accepts an XML parameter
named Param1.
You need to store validated XML data in Schema1.Table1. The solution must ensure that only valid XML data is accepted by Param1. What should you do? (Each correct answer presents part of the solution. Choose all that
apply.)

QUESTION NO: 9
You need to recommend a solution to synchronize Database2 to App1_Db1.
What should you recommend?

QUESTION NO: 10
You have an application that uses a view to access data from multiple tables.
You need to ensure that you can insert rows into the underlying tables by using the view.
What should you do?

QUESTION NO: 11
You use SQL Server 2014. The physical server is a dedicated database server that has 120GB of RAM available. There is approximately 50GB of storage space available on a slow local disk.
You create a new stored procedure. You decide you need to temporarily hold approximately 300,000 rows from two tables, from which you will compute two complex business scores.
The stored procedure will use temporary storage defined as follows: The code will make several passes through the data, applying complex calculations before writing the data to a permanent disk-based table in the same database from which it reads the data.

For this stored procedure, you need to deal with temporary data in the most efficient way to minimize physical disk pressure.
What should you do? More than one answer choice may achieve the goal. Select the BEST answer.

QUESTION NO: 12
Your network contains an Active Directory domain that has two groups named Group1 and
Group2.
The domain contains two SQL Server instances named SQLDev and SQLProd. Each SQL Server instance has access to various storage media.
The SQL Server instances have a database that contains a table named Table1.
Table1 contains a column named Column1. The value for Column1 can be either Value1 or Value2.
You need to recommend a solution to ensure that users in Group1 can retrieve only rows from Column1 that contain the value of Value1.
What should you recommend?