Category «70-465»

Exam 70-465: Designing Database Solutions for Microsoft SQL Server 2012 (update January 1st, 2018)

What should you recommend?

You need to recommend a solution to allow application users to perform UPDATE operations on the databasetables. The solution must meet the business requirements.What should you recommend? A. Create a user-defined database role and add users to the role. B. Create stored procedures that use EXECUTE AS clauses. C. Create a Policy-Based Management Policy. D. …

What should you recommend?

DRAG DROPYou have an SQL Server 2014 server.You plan to create four stored procedures that will use transactions. The stored procedures will be configuredas shown in the following table. You need to recommend an isolation level for each stored procedure. The solution must support theconcurrency strategy of each stored procedure and must minimize locks.What should …

How should you complete the code?

DRAG DROPYou need to assign security to dev_role1.How should you complete the code? To answer, drag the appropriate elements to the correct locations. Eachelement may be used once, more than once, or not at all. You may need to drag the split bar between panes orscroll to view content.Select and Place: Answer: Explanation:* Scenario: Application …

What statement should you use?

DRAG DROPYou have a database named DB1. DB1 contains a table named Sales.SalesPerson that has an index namedAK_SalesPerson_rowguid. Queries that do not use the index take approximately 10 times longer to completethan queries that use the index.You discover that AK_SalesPerson_rowguid has severe fragmentation.You need to recommend a solution to defragment the index. The solution must …

You need to monitor the following events on SQL1: A dea

You have an SQL Server 2014 server named SQL1.You are designing a performance monitoring solution.You need to monitor the following events on SQL1:A deadlock graphMissing column statisticsCPU performance statisticsA batch of completed Transact-SQL statementsWhich two tools should you use? Each correct answer presents a complete solution. A. dynamic management views B. Database Engine Tuning Advisor …

What should you recommend?

DRAG DROPYou define a table by using the following statement. The Teachers table contains one million records. A sample record of the XML data output is as follows: You plan to create queries against the table based on grade.You need to recommend which indexes should be applied to the XML fields. The solution must meet …

Which permissions should you assign to Dba1?

You are using dynamic management views to monitor an SQL Server server named SQL1.A database administrator named Dba1 must monitor the health of SQL1.You need to ensure that Dba1 can access dynamic management views for SQL1. The solution must use theprinciple of least privilege.Which permissions should you assign to Dba1? A. VIEW ANY DEFINITION B. …

What should you include in the recommendation?

You have a server named Server1 that has 2 processors.You plan to deploy multiple instances of SQL Server 2014 to Server1. Each instance will have multipledatabases.You need to recommend a method to set limits on processor time for each database.What should you include in the recommendation?More than one answer choice may achieve the goal. Select …

What should you identify?

You have a customer who has several SQL Server 2012 database servers.You are designing a data warehouse for the customer. The data warehouse will use columnstore indexes.The customer identifies that the following must be supported for the column store indexes.Data manipulation language (DML) statementsNonclustered columnstore indexesClustered columnstore indexesPartitioningYou need to identify which technology requires the …

You need to recommend a management strategy for the SQL Server 2014 servers.

You have a SQL Server 2014 environment that contains 20 servers.The corporate security policy states that all SQL Server 2014 instances must meet specific security standards.You need to recommend a management strategy for the SQL Server 2014 servers.What should you include in the recommendation?More than one answer choice may achieve the goal. Select the BEST …