70-465 Exam
Abreast of the times Microsoft 70-465 - An Overview 1 to 10
Proper study guides for Leading Microsoft Designing Database Solutions for Microsoft SQL Server 2012 certified begins with Microsoft 70-465 preparation products which designed to deliver the Virtual 70-465 questions by making you pass the 70-465 test at your first time. Try the free 70-465 demo right now.
Q1. 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
Q2. 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 a row to the Customers table each time a classification changes.
B. Add a table to track any changes made to the classification of each customer.
C. Add columns for each classification to the Customers table.
D. Add a column to the Classifications table to track the status of each classification.
E. Implement change data capture.
Answer: AC
Topic 6, Mix Questions
36. DRAG DROP
You need to recommend a backup process for an Online Transaction Processing (OLTP) database.
The process must meet the following requirements:
-Ensure that if a hardware failure occurs, you can bring the database online with a minimum amount of data loss. -Minimize the amount of administrative effort required to restore any lost data.
What should you include in the recommendation?
To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Q3. You need to recommend a solution for Application1 that meets the security requirements.
What should you include in the recommendation?
A. Encrypted columns
B. Certificate Authentication
C. Secure Socket Layer (SSL)
D. Signed stored procedures
Answer: B
Q4. DRAG DROP
You have two servers named SQL1 and SQL2 that have SQL Server 2008 installed. SQL1 contains a database that is mirrored asynchronously to SQL2. The database contents are updated once a month.
You need to upgrade the database to SQL Server 2012. The solution must minimize downtime.
Which upgrade steps should you recommend?
To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Q5. You have two SQL Server 2012 instances named SQLDev and SQLProd.
You plan to create a new database on SQLProd that will use SQL Server Authentication.
You need to ensure that when the new database is copied from SQLProd to SQLDev, users can connect to the database on SQLDev if they do not have a login on the SQLDev instance.
What should you use?
More than one answer choice may achieve the goal. Select the BEST answer.
A. SQL Server Integration Services (SSIS) scripts
B. Extended Events
C. Triggers
D. SQL Server Analysis Services (SSAS) scripts
E. Contained database
Answer: E
Q6. You deploy a database by using SQL Server 2012. The database contains a table named Table1.
You need to recommend a solution that meets the following requirements:
-Stores the most recent data from Table1 by using the fastest storage solution possible.
-Stores the historical data from Table1 by using a slower storage solution.
What should you recommend?
A. partitioned views
B. a database snapshot
C. change data capture
D. table partitioning
Answer: D
Q7. DRAG DROP
You have a server named SQL1 that has SQL Server 2012 installed. SQL1 hosts a database named Database1. Database1 contains a table named Table1. Table1 is partitioned across five filegroups based on the Date field.
The schema of Table1 is configured as shown in the following table.
Table1 contains the indexes shown in the following table.
You need to recommend an index strategy to maximize performance for the queries that consume the indexes available to Table1.
Which type of index storage should you recommend?
To answer, drag the appropriate index storage type to the correct index in the answer area.
Answer:
Q8. 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
Q9. 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
Q10. You have a SQL Server 2012 instance named SQL1.
SQL1 creates error events in the Windows Application event log.
You need to recommend a solution that will run an application when SQL1 logs a specific error in the Application log.
Which SQL elements should you include in the recommendation? (Each correct answer presents part of the solution. Choose all that apply.)
A. A policy
B. A trigger
C. A maintenance plan
D. A job
E. An alert
Answer: CE