70-465 Exam
Top 10 pack 70-465 for consumer (21 to 30)
Master the 70-465 Designing Database Solutions for Microsoft SQL Server 2012 content and be ready for exam day success quickly with this Testking 70-465 download. We guarantee it!We make it a reality and give you real 70-465 questions in our Microsoft 70-465 braindumps.Latest 100% VALID Microsoft 70-465 Exam Questions Dumps at below page. You can use our Microsoft 70-465 braindumps and pass your exam.
Q21. You need to recommend a solution to meet the security requirements of the junior database administrators.
What should you include in the recommendation?
A. a database role
B. a server role
C. a shared login
D. a credential
Answer: B
Q22. DRAG DROP
You have a SQL Azure database named Database1.
You need to design the schema for a table named table1. Table1 will have less than one million rows. Table1 will contain the following information for each row:
The solution must minimize the amount of space used to store each row.
Which data types should you recommend for each column?
To answer, drag the appropriate data type to the correct column in the answer area.
Answer:
Q23. 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 resuse 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. Data encryption
B. Transparent Data Encryption (TDE)
C. Encrypting File System (EFS)
D. Data hashing
Answer: A
Q24. DRAG DROP
You need to design a stored procedure to update rows.
The stored procedure must meet the following requirements:
-If more than one row is updated, an error must be raised to the application and the update must be discarded. -The stored procedure must be designed to maximize concurrency.
What should you include in the design?
To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Q25. You need to recommend a disaster recovery solution for the Dev database.
What should you include in the recommendation?
A. The simple recovery model and full backups
B. The full recovery model, full backups, and transaction log backups
C. The full recovery model, full backups, and differential backups
D. The bulk-logged recovery model and full backups
Answer: A
Q26. 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.
A. Query the sys.dm_exec_requests dynamic management view.
B. Create a trace in SQL Server Profiler that contains the Deadlock graph event.
C. Query the sys.dm_exec_sessions dynamic management view.
D. Create an extended events session to capture deadlock information.
Answer: D
Q27. 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 SQL Azure.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
A. A database snapshot
B. A data-tier application
C. Change data capture
D. SQL Server Integration Services (SSIS)
Answer: B
Q28. You need to recommend a disk monitoring solution that meets the business requirements.
What should you include in the recommendation?
A. a SQL Server Agent alert
B. a dynamic management view
C. a maintenance plan
D. an audit
Answer: A
Q29. You need to recommend a solution that addresses the index fragmentation and index width issue.
What should you include in the recommendation? (Each correct answer presents part of the solution. Choose all that apply.)
A. Change the data type of the modifiedBy column to tinyint.
B. Change the data type of the lastModified column to smalldatetime.
C. Remove the id column from the clustered index.
D. Remove the modifiedBy column from the clustered index.
E. Change the data type of the id column to bigint.
F. Remove the lastModified column from the clustered index.
Answer: ABF
Q30. You need to recommend a solution to synchronize Database2 to App1_Db1.
What should you recommend?
A. Snapshot replication
B. Change data capture
C. Transactional replication
D. Master Data Services
Answer: C