PrepAway - Latest Free Exam Questions & Answers

Category: 70-465 (v.4)

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

What should you recommend?

DRAG DROP
You have an SQL Server 2014 server.
You plan to create four stored procedures that will use transactions. The stored procedures will be configured
as shown in the following table.

You need to recommend an isolation level for each stored procedure. The solution must support the
concurrency strategy of each stored procedure and must minimize locks.
What should you recommend? To answer, drag the appropriate isolation levels to the correct stored
procedures. Each isolation level may be used once, more than once, or not at all. You may need to drag the
split bar between panes or scroll to view content.
Select and Place:

What statement should you use?

DRAG DROP
You have a database named DB1. DB1 contains a table named Sales.SalesPerson that has an index named
AK_SalesPerson_rowguid. Queries that do not use the index take approximately 10 times longer to complete
than 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 ensure that the index can be
used by queries during the defragmentation.
What statement should you use? To answer, drag the appropriate elements to the correct locations. Each
element may be used once, more than once, or not at all. You may need to drag the split bar between panes or
scroll to view content.
Select and Place:

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 graph
Missing column statistics
CPU performance statistics
A batch of completed Transact-SQL statements
Which two tools should you use? Each correct answer presents a complete solution.

What should you recommend?

DRAG DROP
You 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 the
following requirements:
Reduce the amount of time required to query the table based on grade.
Minimize the size of the index.
What should you recommend? To answer, drag the appropriate index types to the correct fields. Each index
type may be used once, more than once, or not at all. You may need to drag the split bar between panes or
scroll to view content.
Select and Place:

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 the BEST answer.

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) statements
Nonclustered columnstore indexes
Clustered columnstore indexes
Partitioning
You need to identify which technology requires the customer to implement an SQL Server 2014 database.
What should you identify?

You need to recommend a management strategy for the SQL…

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


Page 1 of 1112345...10...Last »