70-765 Exam Questions | You are a database administrator

Question: 2

You are a database administrator for a Microsoft SQL Server 2014 environment. You want to deploy a new application that will scale out the workload to at least five different SQL Server instances. You need to ensure that for each copy of the database, users are able to read and write data that will then be synchronized between all of the database instances. Which feature should you use?

A. Database Mirroring
B. Peer-to-Peer Replication
C. Log Shipping
D. Availability Groups

Answer: B

70-765 Exam Questions | You administer two instances

Question: 1

You administer two instances of Microsoft SQL Server 2014. You deploy an application that uses a database on the named instance. The application is unable to connect to the database on the named instance. You need to ensure that the application can connect to the named instance. What should you do?

A. Configure the application as data-tiered.
B. Open port 1433 on the Windows firewall on the server.
C. Configure the named SQL Server instance to use an account that is a member of the
Domain Admins group.
D. Start the SQL Server Browser Service.

Answer: D