Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft 70-465 Exam

Status: RETIRED
Certification Provider: Microsoft
Exam Name: Designing Database Solutions for Microsoft SQL Server 2012
Duration: 90 Minutes
Number of questions in our database: 111
Exam Version: 01-01-1970
70-465 Exam Official Topics:
  • Topic 1: Design a logical schema; design a data access and data layer architecture; design a database schema Design instance-level security configurations Configure failover clustering
  • Topic 2: including multi-subnet; design readable mirrors
Disscuss Microsoft 70-465 Topics, Questions or Ask Anything Related

Currently there are no comments in this discussion, be the first to comment!

Free Microsoft 70-465 Exam Actual Questions

The questions for 70-465 were last updated On 01-01-1970

Question #1

You need to recommend a solution for the error handling of USP_4. The solution must handle errors for nested stored procedures in the code for USP_4.

What should you recommend?

Reveal Solution Hide Solution
Correct Answer: C

* A stored procedure named USP_4 calls stored procedures in the Sales, Customers, and Inventory databases. The nested stored procedures read tables from the Sales, Customers, and Inventory databases. USP_4 uses an EXECUTE AS clause.


Question #2

You have a server named Server1 that has 16 processors.

You plan to deploy multiple instances of SQL Server 2014 to Server1.

You need to recommend a method to allocate processors to each instance.

What should you include in the recommendation?

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

Reveal Solution Hide Solution
Correct Answer: A

CPU affinity management through Windows System Resource Manager is not recommended for SQL Server multi-instance management. Instead, use the processor affinity settings in SQL Server.


Question #3

You are creating a database that will store usernames and passwords for an application.

You need to recommend a solution to store the passwords in the database.

What should you recommend?

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

Reveal Solution Hide Solution
Correct Answer: C

* Transparent Data Encryption (TDE) is a special case of encryption using a symmetric key. TDE encrypts an entire database using that symmetric key called the database encryption key. The database encryption key is protected by other keys or certificates which are protected either by the database master key or by an asymmetric key stored in an EKM module.

* SQL Server provides the following mechanisms for encryption:

Transact-SQL functions

Asymmetric keys

Symmetric keys

Certificates

Transparent Data Encryption


Question #4

You have two databases named DB1 and DB2 that are located on the same server.

You plan to create a stored procedure named SProc1 in DB1.

SProc1 will query a table named Table2 in DB2.

You need to recommend a solution to ensure that SProc1 can access Table2 without granting users direct access to Table2.

What should you include in the recommendation?

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

Reveal Solution Hide Solution
Correct Answer: B

An application role is a database principal that enables an application to run with its own, user-like permissions. You can use application roles to enable access to specific data to only those users who connect through a particular application. Unlike database roles, application roles contain no members and are inactive by default.


Question #5

You are troubleshooting an application that runs a query. The application frequently causes deadlocks.

You need to identify which transaction causes the deadlock.

What should you do?

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

Reveal Solution Hide Solution
Correct Answer: D

Troubleshooting deadlocks

You have been receiving reports from users indicating that certain applications are returning deadlock errors. To maximize the effectiveness of troubleshooting these problems, you decide to focus on the deadlocks that are hit most frequently. You create an Extended Events session that:

/ Configures deadlock event tracking for the session.

/ Specifies a target that aggregates based on an identifier for the deadlock.

You run the Extended Events session, and after additional deadlocks are reported you are able to obtain aggregated deadlock information, along with the complete XML deadlock graph for each source. Using this information you are able to pin point the most common deadlocks and start working on a solution.

Create an Extended Events Session

View Event Session Data



Unlock all 70-465 Exam Questions with Advanced Practice Test Features:
  • Select Question Types you want
  • Set your Desired Pass Percentage
  • Allocate Time (Hours : Minutes)
  • Create Multiple Practice tests with Limited Questions
  • Customer Support
Get Full Access Now

Save Cancel