PrepAway - Latest Free Exam Questions & Answers

Category: 70-465 (v.2)

Exam 70-465: Designing Database Solutions for Microsoft SQL Server 2012 (update April 27th, 2017)

Which of the following would be most suitable password …

You work as a Developer at ABC.com. All databases are hosted on Windows Server 2012 servers running SQL
Server 2012. You are developing a custom CRM application named CorpCRM. The application will store
usernames and passwords in a SQL Server 2012 database named CorpCRMDB1. You need to ensure the
usernames and passwords are secure. Which of the following would be most suitable password storage
solution?

How can you meet these requirements?

You work as a Developer at ABC.com. All databases are hosted on Windows Server 2012 servers running SQL
Server 2012. The company has a database named Products. Tables in the Products database contain data
including part numbers, product name, color, type and size. Users in the Marketing department have created
brochures for each product. The brochures have been created in the XML Paper Specification (XPS) format.
You have been asked to add a table to the Products database to store the product brochures. The brochures
need to be stored in a folder structure. Company users will also need to access the brochures from Windows
applications using UNC paths. How can you meet these requirements?

What should you configure?

You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft
SQL Server 2012 infrastructure. You have a database named CorpDB. CorpDB contains a table named
SalesInfo. You discover that some table has been deleted from the SalesInfo table. You are unable to find out
who deleted the information. You need to implement a solution to monitor the deletion of any further information
from the SalesInfo table. You want to minimize the development effort required for the solution. What should
you configure?

Which two of the following actions would meet the backu…

You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft
SQL Server 2012 infrastructure. You have a database named CorpDB. A full backup of CorpDB is taken every
week. A differential backup of CorpDB is taken every night at midnight. A transaction log backup of CorpDB is
taken at 8am, 12pm, 4pm and 8pm. You plan to deploy some changes to CorpDB at after the 4pm log backup
completes. You need to ensure that you can undo the changes quickly if the deployment fails. During the
deployment of the changes, no other changes must be made by users to the database. You need a backup and
recovery strategy for deploying the changes.Which two of the following actions would meet the backup and
recovery requirements whilst ensuring the regular backup schedule is not disrupted? (Choose two).

Which of the following failover types should you config…

SQL Server 2012 infrastructure. You are configuring a highly-available database solution using an AlwaysOn
availability group on two servers running SQL Server 2012. The two servers are in separate datacenters. The
two datacenters are connected by a WAN link with a network latency of more than 200ms. Which of the
following failover types should you configure for the availability group?

Which of the following failover types should you config…

You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft
SQL Server 2012 infrastructure. You are configuring a highly-available database solution using an AlwaysOn
availability group on two servers running SQL Server 2012. The two servers are in separate datacenters. The
two datacenters are connected by a fast WAN link with a network latency of less than 10ms. Which of the
following failover types should you configure for the availability group?

How should you configure the backup solution?

You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft
SQL Server 2012 infrastructure. The sales and marketing departments contain a total of 60 users. Each user
uses a custom application that stores data in a SQL Server database. Each user has a separate database. A
server named ABC-SQL1 hosts the 60 databases. You need to configure a backup solution for all the
databases. The solution must ensure that any new databases configured on ABC-SQL1 are automatically
added to the backup schedule. The backup schedule consists of a full backup every night, a differential backup
every hour and a transaction log backup every 15 minutes. How should you configure the backup solution?

What should youconfigure?

You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft
SQL Server 2012 infrastructure. Computer users use custom applications that store data in SQL Server
databases hosted on a server named ABC-SQL1. You discover that the Windows Application event log on
ABC-SQL1 contains error events. You need to configure a solution that will run an application whenever an
event with a specific event ID number is generated in the Windows Application event log. What should youconfigure?


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