You work as a Database Administrator (DBA) for a company named ABC.com. The
company uses a Microsoft SQL Server 2012 infrastructure.
You plan to deploy three new servers running SQL Server 2012 Standard Edition.
You need to configure the three servers to host databases that must be highly available.
Automatic failover is required in the event of a server failure.
Which of the following SQL Server features should you configure?
A.
Peer-to-Peer Transactional Replication.
B.
AlwaysOn Availability Groups.
C.
Database Mirroring.
D.
Transaction Log Shipping.
Explanation:
Database mirroring is being deprecated so this question is not quite valid anymore.
>= 2 servers should use AlwaysOn, answer is B
Says Standard Edition, so it’s Database Mirroring.
C is right – Standard Edition
May be B or C
https://msdn.microsoft.com/en-us/library/cc645993%28v=SQL.110%29.aspx#High_availability
New 70-465 Exam Questions and Answers Updated Recently:
NEW QUESTION 20
What should you recommend for the updates to Sales.TransactionHistory?
A. a REPEATABLE READ isolation level
B. implicit transactions
C. query hints
D. a SNAPSHOT isolation level
Answer: A
NEW QUESTION 21
……
NEW QUESTION 32
You need to recommend a solution to back up DB1. What should you include in the recommendation?
A. Azure Table Storage
B. Azure Queue storage
C. Azure Blob storage
D. Azure Document DB
Answer: C
Explanation:
Explanation: For SQL Server the Azure Blob Storage service offers a better alternative to the often used tape option to archive backups. Tape storage might require physical transportation to an off-site facility and measures to protect the media. Storing your backups in Azure Blob Storage provides an instant, highly available, and a durable archiving option.
NEW QUESTION 33
……
NEW QUESTION 154
You are using dynamic management views to monitor an SQL Server server named SQL1. A database administrator named Dba1 must monitor the health of SQL1. You need to ensure that Dba1 can access dynamic management views for SQL1. The solution must use the principle of least privilege. Which permissions should you assign to Dba1?
A. VIEW ANY DEFINITION
B. VIEW SERVER STATE
C. VIEW DEFINITION
D. CONTROL SERVER
Answer: B
Explanation:
To query a dynamic management view or function requires SELECT permission on object and VIEW SERVER STATE or VIEW DATABASE STATE permission.
NEW QUESTION 155
You have a customer who has several SQL Server 2012 database servers. You are designing a data warehouse for the customer. The data warehouse will use columnstore indexes. The customer identifies that the following must be supported for the column store indexes.
– Data manipulation language (DML) statements
– Nonclustered columnstore indexes
– Clustered columnstore indexes
– Partitioning
You need to identify which technology requires the customer to implement an SQL Server 2014 database. What should you identify?
A. clustered columnstore indexes
B. nonclustered columnstore indexes
C. data manipulation language (DML) statements
D. partitioning
Answer: A
Explanation:
SQL Server 2014 has the features of SQL Server 2012 plus updateable clustered columnstore indexes. This feature is required here as DML statements must be supported in the warehouse.
NEW QUESTION 156
……
NEW QUESTION 157
Drag and Drop Question
You have an SQL Server 2014 server. You plan to create four stored procedures that will use transactions. The stored procedures will be configured as shown in the following table.
IMG: examgod.com/plimages/5ff1a742aa3c_FC1B/1571_thumb8_thumb.jpg
You need to recommend an isolation level for each stored procedure. The solution must support the concurrency strategy of each stored procedure and must minimize locks. What should you recommend? To answer, drag the appropriate isolation levels to the correct stored procedures. Each isolation level may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
IMG: examgod.com/plimages/5ff1a742aa3c_FC1B/1572_thumb4_thumb.jpg
Answer:
IMG: examgod.com/plimages/5ff1a742aa3c_FC1B/1573_thumb4_thumb.png
NEW QUESTION 158
……
P.S. These New 70-465 Exam Questions Were Updated By PassLeader, You Can Get The Newest 70-465 Dumps In PDF And VCE From — https://tr.im/HlLS2 (160q dumps)
Good Luck !!!