Microsoft 70-469 ExamRecertification for MCSE: Data Platform

Total Question: 281 Last Updated: September 25,2017
  • Updated 70-469 Dumps
  • Based on Real 70-469 Exams Scenarios
  • Free 70-469 pdf Demo Available
  • Check out our 70-469 Dumps in a new PDF format
  • Instant 70-469 download
  • Guarantee 70-469 success in first attempt
Package Select:

Questions & Answers PDF

Practice Test Software

Practice Test + PDF 30% Discount

Price: $65.95 $29.99

Buy Now Free Trial

Sep 2017 updated: Testking Microsoft 70-469 exam guide 101-110

Actualtests offers free demo for 70-469 exam. "Recertification for MCSE: Data Platform", also known as 70-469 exam, is a Microsoft Certification. This set of posts, Passing the Microsoft 70-469 exam, will help you answer those questions. The 70-469 Questions & Answers covers all the knowledge points of the real exam. 100% real Microsoft 70-469 exams and revised by experts!

Q101. You need to modify InsertInvoice to comply with the application requirements. Which code segment should you execute? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer:


Q102. You have a Microsoft SQL Azure database. You have the following stored procedure: 

You discover that the stored procedure periodically fails to update HR.Employees. 

You need to ensure that HR.Employees is always updated when up_employees executes. 

The solution must minimize the amount of time required for the stored procedure to execute and the number of locks held. 

What should you do? 

A. Add the following line of code to line 05: 

SET TRANSACTION ISOLATION LEVEL SNAPSHOT 

B. Add the following line of code to line 13: 

WITH (UPDLOCK) 

C. Add the following line of code to line 05: 

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE 

D. Add the following line of code to line 08: 

WITH (UPDLOCK) 

Answer:


Q103. You need to create the InvoiceStatus table in DB1. 

How should you define the InvoiceID column in the CREATE TABLE statement? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer:


Q104. You need to modify the stored procedure usp_LookupConcurrentUsers. 

What should you do? 

A. Add a clustered index to the summary table. 

B. Add a nonclustered index to the summary table. 

C. Add a clustered columnstore index to the summary table. 

D. Use a table variable instead of the summary table. 

Answer:


Q105. You have a SQL Server 2012 database named Database1. Database1 contains a table named OrderDetails. 

For a given sales order, you need to retrieve the OrderID, Quantity, and LineTotal columns for all of the items in the OrderDetails table. The solution must ensure that the results can be joined to other tables. 

Which code segment should you execute? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer:


Q106. You have a Microsoft SQL Azure database that contains a table named Customers. 

You have a table-valued function named TopCustomers that returns a list of all the customers that have purchased items during the last 12 months. The ID of the customer is passed as an argument to the TopCustomers function. 

You need to create a query that returns a list of all the Customer names and the purchase dates. 

The solution must return only customers that have purchased an item during the last 12 months. 

What should you add to the query? 

A. OUTER JOIN 

B. CROSS JOIN 

C. CROSS APPLY 

D. OUTER APPLY 

Answer:


Q107. The database contains a disk-based table named ContentTable that has 1 million rows and a column named Fax. Fax allows null values. 

You need to update Fax to meet the following requirements: 

. Prevent null values from being used. 

. Always use an empty string instead of a null value. 

Which statement or statements should you execute? (Each correct answer presents part of the solution. Choose all that apply.) 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

E. Option E 

Answer: ABE 


Q108. 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. Create a view called CustProduct that includes columns ProductID. ProductName, Product Description, QuantityOnHand, ProductPrice, ProductCost, and ProductSupplierID. 

B. GRANT ALL on CustProduct TO OurDomain\\CustomerSupport 

C. Create a user-defined data type called CustProduct that includes columns ProductID, ProductName, Product Description, and ProductPrice. 

D. Create a view called CustProduct that includes columns ProductID, ProductName, Product Description, QuantityOnHand, and ProductPrice. 

E. GRANT SELECT on CustProduct TO OurDomain\\CustomerSupport. 

F. GRANT SELECT on CustProduct TO public. 

Answer: AE 


Q109. You need to recommend a solution to meet the security requirements of the junior database administrators. 

What should you include in the recommendation? 

A. A server role 

B. A database role 

C. A credential 

D. A shared login 

Answer:


Q110. You discover that the usp_GetOrdersAndItems stored procedure takes a long time to complete while usp_AddOrder or usp_AddXMLOrder run. 

You need to ensure that usp_GetOrdersAndItems completes as quickly as possible. 

What should you do? (Each correct answer presents part of the solution. Choose all that apply.) 

A. Set the isolation level of the usp_GetOrdersAndItems stored procedure to SERIALIZABLE. 

B. Execute the ALTER DATABASE Sales SET ALLOW_SNAPSHOT_ISOLATION ON statement. 

C. Set the isolation level of the usp_AddOrder stored procedure to SERIALIZABLE. 

D. Set the isolation level of the usp_GetOrdersAndItems stored procedure to SNAPSHOT. 

E. Set the isolation level of the usp_AddOrder stored procedure to SNAPSHOT. 

F. Execute the ALTER DATABASE Sales SET ALLOW_SNAPSHOT_ISOLATION OFF statement. 

Answer: BD 


Related 70-469 Articles