Online Access Free 070-465 Exam Questions

What should you recommend for the updates to Sales.TransactionHistory?

• A.a REPEATABLE READ isolation level
• B.query hints
• C.a SNAPSHOT isolation level
• D.implicit transactions

You have an SQL Server 2014 instance named SQL1.
SQL1 creates error events in the Windows Application event log.
You need to recommend a solution that will run an application when SQL1 logs a specific error in the Application log.
Which SQL elements should you include in the recommendation? (Each correct answer presents part of the solution. Choose all that apply.)

• A.A trigger
• B.A maintenance plan
• C.An alert
• D.A job
• E.A policy

You need to recommend a disaster recovery strategy for the Inventory database. What should you include in the recommendation?

• A.AlwaysOn availability groups
• B.Peer-to-peer replication
• C.SQL Server Failover Clustering
• D.Log shipping

You are building a stored procedure for a Windows Azure SQL Database. The procedure will add multiple rows to a table.
You need to design the stored procedure to meet the following requirements:
If any of the new rows violates a table constraint, then no further additions must be attempted and all changes made by the stored procedure must be discarded.
If any errors occur, a row must be added to an audit table, and the original error must be returned to the caller of the stored procedure.
What should you include in the design?

• A.An explicit transaction that has XACT_ABORT disabled
• B.An implicit transaction that has error handling enabled
• C.An implicit transaction that has XACT.ABORT enabled
• D.An explicit transaction that has error handling enabled

You need to configure security on the Product table for customer support representatives.
Which two actions should you perform? Each correct answer presents part of the solution. Choose two.

• A.GRANT SELECT on CustProduct TO public.
• B.Create a view called CustProduct that includes columns ProductID. ProductName, Product Description, QuantityOnHand, ProductPrice, ProductCost, and ProductSupplierID.
• C.Create a view called CustProduct that includes columns ProductID, ProductName, Product Description, QuantityOnHand, and ProductPrice.
• D.GRANT ALL on CustProduct TO OurDomain\CustomerSupport.
• E.GRANT SELECT on CustProduct TO OurDomain\CustomerSupport.
• F.Create a user-defined data type called CustProduct that includes columns ProductID, ProductName, Product Description, and ProductPrice.