Online Access Free 070-469 Practice Test

You have a SQL Server 2012 database named Database1.
Database1 has a table named Customers. Customers contains more than 1 million rows.
The database has a stored procedure that was created by using the following script:

You need to ensure that up_customers returns rows when the following statement is executed:
EXECUTE up_customers'1,2,3,4,5';
What should you do?

• A.Update @CustomerTypeList to use the XML data type.
• B.Convert @CustomerTypeList to a table variable.
• C.Update @CustcmerTypelist to use the int data type.
• D.Convert @CustomerTypeList to an XML variable.

DRAG DROP
You are designing an authentication strategy for a new server that has SQL Server 2014 installed. The strategy must meet the following business requirements:
- The account used to generate reports must be allowed to make a connection during certain hours only. - Failed authentication requests must be logged.
You need to recommend a technology that meets each business requirement. The solution must minimize the amount of events that are logged.
Which technologies should you recommend?
To answer, drag the appropriate solution to the correct business requirement in the answer area.

Correct Answer:

You are creating a table named Orders.
You need to ensure that every time a new row is added to the Orders table, a user-defined function is called to validate the row before the row is added to the table.
What should you use?
More than one answer choice may achieve the goal. Select the BEST answer.

• A.A Data Definition Language (DDL) trigger
• B.A CHECK constraint
• C.A FOREIGN KEY constraint
• D.A data manipulation language (DML) trigger
• E.A DEFAULT constraint

You deploy a SQL Server instance named SQLProd that uses SQL Server 2014.
You need to recommend a solution to monitor the transactions that are running currently against SQLProd. The solution must minimize the amount of custom code required.
What should you recommend?

• A.A trigger
• B.Statistics
• C.A dynamic management view
• D.User-defined views

You have a SQL Server 2014 database named DB1.
You plan to import a large number of records from a SQL Azure database to DB1.
You need to recommend a solution to minimize the amount of space used in the
transaction log during the import operation.
What should you include in the recommendation?

• A.The bulk-logged recovery model
• B.A new file group
• C.A new partitioned table
• D.The full recovery model
• E.A new log file