Online Access Free 070-465 Exam Questions

You are creating a database that will store usernames and credit card numbers for an application.
You need to recommend a solution to store and reuse the credit card numbers in the database.
What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

• A.Transparent Data Encryption (TDE)
• B.Encrypting File System (EPS)
• C.Data encryption
• D.Data hashing

You administer a SQL Server 2014 instance.
Users report that the SQL Server has seemed slow today. A large database was being restored for much of the day, which could be causing issues.
You want to write a query of the system views that will report the following:
Number of users that have a connection to the server
Whether a user's connection is active
Whether any connections are blocked
What queries are being executed
Whether the database restore is still executing and, if it is, what percentage of the restore is complete.
Which system objects should you use in your query to best achieve this task?
----

• A.sys.dm_exec_sessions, sys.dm_exec_query_stats, sys.dm_exec_query_text,sys.objects
• B.sys.dm_exec_requests, sys.dm_exec_sessions, sys.dm_exec_query_text
• C.sys.sysprocesses, sys.dm_exec_query_text, sys.objects
• D.sys.dm_exec_requests, sys.dm_exec_sessions, sys.objects

You have a SQL Server 2014 environment that includes four servers. The servers are configured as shown in the following table.

You plan to configure Policy-Based Management to enforce the following rules:
- On Server1, enable SQL Server password policies and enable the default trace. - On Server3, ensure that the names of user-defined stored procedures begin with the prefix "usp_" and ensure that all databases use a case-sensitive collation.
You need to recommend which server you must configure as a Central Management Server.
Which server should you recommend? (Each correct answer presents a complete solution. Choose all that apply.)

• A.Server2
• B.Server1
• C.Server3
• D.Seiver4

You need to recommend a solution for the deployment of SQL Server 2014. The solution must meet the business requirements.
What should you include in the recommendation?

• A.Deploy two servers that have SQL Server 2014 installed and implement database mirroring.
• B.Deploy two servers that have SQL Server 2014 installed and implement Failover Clustering.
• C.Create a new instance of SQL Server 2014 on the server that hosts the SQL Server 2008 instance.
• D.Upgrade the existing SQL Server 2008 instance to SQL Server 2014.

You need to recommend a solution for the planned changes to the customer classifications.
What should you recommend? (Each correct answer presents part of the solution. Choose all that apply.)

• A.Add columns for each classification to the Customers table.
• B.Add a row to the Customers table each time a classification changes.
• C.Implement change data capture.
• D.Add a table to track any changes made to the classification of each customer.
• E.Add a column to the Classifications table to track the status of each classification.