Finding Regenerate 70-469 study guides

we provide Realistic Microsoft 70-469 latest exam which are the best for clearing 70-469 test, and to get certified by Microsoft Recertification for MCSE: Data Platform. The 70-469 Questions & Answers covers all the knowledge points of the real 70-469 exam. Crack your Microsoft 70-469 Exam with latest dumps, guaranteed!

Q91. You have a SQL Server 2012 environment that contains two servers. The servers are configured as shown in the following table. 

After the failover is complete, a user receives the following error message when connecting to DB1 on Server2: 

"Msg 916, Level 14, State 1, Line 1 The server principal "Account1" is not able to access the database "DB1" under the current security context." 

You verify that there is a server login for Account1 on Server2. 

You need to ensure that Account1 can connect to DB1. 

What should you do? 

More than one answer choice may achieve the goal. Select the BEST answer. 

A. Update the SID for Account1 on DB1. 

B. Add Account1 to the db_datareader role. 

C. Create a new database user on DB1. 

D. Implement Windows authentication. 

Answer:


Q92. You need to implement security for the restore and audit process. What should you do? 

A. Grant the COFFECORP\\Auditors group ALTER ANY CONNECTION and SELECT ALL USER SECURABLES permissions. Grant the COFFECORP\\StoreAgent group ALTER ANY CONNECTION and IMPERSONATE ANY LOGIN permissions. 

B. Grant the COFFECORP\\Auditors group CONNECT ANY DATABASE and IMPERSONATE ANY LOGIN permissions. Grant the COFFECORP\\StoreAgent group CONNECT ANY DATABASE and SELECT ALL USER SECURABLES permissions. 

C. Grant the COFFECORP\\Auditors group ALTER ANY CONNECTION and IMPERSONATE ANY LOGIN permissions. Grant the COFFECORP\\StoreAgent group ALTER ANY CONNECTION and SELECT ALL USER SECURABLES permissions. 

D. Grant the COFFECORP\\Auditors group CONNECT ANY DATABASE and SELECT ALL USER SECURABLES permissions. Grant the COFFECORP\\StoreAgent group CONNECT ANY DATABASE and IMPERSONATE ANY LOGIN permissions. 

Answer:


Q93. You have a Microsoft SQL Azure database that contains a table named Employees. 

You create a non-clustered index named EmployeeName on the name column. 

You write the following query to retrieve all of the employees that have a name that starts with the letters JOH: 

You discover that the query performs a table scan. 

You need to ensure that the query uses EmployeeName. 

What should you do? 

A. Recreate EmployeeName as a unique index 

B. Recreate EmployeeName as a clustered index 

C. Replace LEFT(name,3) = 'JOH' by using name like 'JOH%' 

D. Replace LEFT(name,3) = 'JOH' by using substring(name, 1, 3) = 'JOH' 

Answer:


Q94. You have two SQL Server 2014 instances named SQLDev and SQLProd. 

You plan to create a new database on SQLProd that will use SQL Server Authentication. 

You need to ensure that when the new database is copied from SQLProd to SQLDev, users can connect to the database on SQLDev even if they do not have a login on the SQLDev instance. 

What should you use? 

More than one answer choice may achieve the goal. Select the BEST answer. 

A. Triggers 

B. Contained database 

C. SQL Server Analysis Services (SSAS) scripts 

D. Extended Events 

E. SQL Server Integration Services (SSIS) scripts 

Answer:


Q95. You need to recommend a solution that addresses the backup issue. The solution must minimize the amount of development effort. 

What should you include in the recommendation? 

A. Indexed views 

B. Filegroups 

C. Table partitioning 

D. Indexes 

Answer:


Q96. 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 


Q97. You are designing a SQL Server database for an order fulfillment system. You create a table named Sales.Orders by using the following script: 

Each order is tracked by using one of the following statuses: 

Fulfilled 

Shipped 

Ordered 

Received 

You need to design the database to ensure that you can retrieve the status of an order on a given date. The solution must ensure that new statuses can be added in the future. 

What should you do? 

More than one answer choice may achieve the goal. Select the BEST answer. 

A. Implement change data capture on the Sales.Orders table. 

B. To the Sales.Orders table, add a column named Status that will store the order status. Update the Status column as the order status changes. 

C. Create a new table named Sales.OrderStatus that contains three columns named OrderID, StatusDate, and Status. Insert new rows into the table as the order status changes. 

D. To the Sales.Orders table, add three columns named FulfilledDate, ShippedDate, and ReceivedDate. Update the value of each column from null to the appropriate date as the order status changes. 

Answer:


Q98. You run the following code: 

You need to ensure that the root node of the XML data stored in the Details column is <Order_Details>. 

What should you implement? 

More than one answer choice may achieve the goal. Select the BEST answer. 

A. A user-defined data type 

B. An XML index 

C. A Data Definition Language (DDL) trigger 

D. A data manipulation language (DML) trigger 

E. An XML schema collection 

Answer:


Q99. You have two SQL Server instances named SQLDev and SQLProd that have access to various storage media. 

You plan to synchronize SQLDev and SQLProd. 

You need to recommend a solution that meets the following requirements: 

The database schemas must be synchronized from SQLDev to SQLProd. The database on SQLDev must be deployed to SQLProd by using a package. The package must support being deployed to Windows Azure SQL Database. 

What should you recommend? 

More than one answer choice may achieve the goal. Select the BEST answer. 

A. A database snapshot 

B. SQL Server Integration Services (SSIS) 

C. Change data capture 

D. A data-tier application 

Answer:


Q100. You need to modify usp_SelectEmployeesByName to support server-side paging. The solution must minimize the amount of development effort required. 

What should you add to usp_SelectEmployeesByName? 

A. A table variable 

B. The ROWNUMBER keyword 

C. An OFFSET-FETCH clause 

D. A recursive common table expression 

Answer:



see more http://www.certshared.com/exam/70-469/