70-764

Overview General Overview ADatum Corporation has offices in Miami and Montreal. The network contains a single Active Directory forest named adatum.com. The offices connect to each other by using a WAN link that has 5-ms latency. A. Datum standardizes its database platform by using SQL Server 2014 Enterprise edition. Databases...

Overview You are a database administrator for a company named Litware, Inc. Litware is a book publishing house. Litware has a main office and a branch office. You are designing the database infrastructure to support a new web-based application that is being developed. The web application will be accessed at...

Your company has offices in Seattle and Montreal. The network contains two servers named Server1 and Server2 that have SQL Server 2012 installed. The servers are located in separate building within your campus. The latency of the WAN link between the buildings is less than 10 ms. You plan to...

You observe that several indexes are fragmented. You need to rebuild the indexes. What should you use?A . Activity MonitorB . Sp_who3C . Object Explorer in the SQL Server Management Studio (SSMS)D . SQL Server Data CollectorE . SQL Server Data Tools (SSDT)F . SQL Server Configuration ManagerView AnswerAnswer: C...

DRAG DROP You are designing an authentication strategy for a new server that has SQL Server 2014 installed. The strategy must meet the following business requirements: The account used to generate reports must be allowed to make a connection during certain hours only. Failed authentication requests must be logged. You...

HOTSPOT You manage a Microsoft-SQL Server database named sales Orders. You need to verify the integrity of the database and attempt to repair any errors that are found. Repair must not cause any data to be lost in the database. How should you complete the DBCC command? To answer, select...

Overview Application Overview Contoso, Ltd., is the developer of an enterprise resource planning (ERP) application. Contoso is designing a new version of the ERP application. The previous version of the ERP application used SQL Server 2008 R2. The new version will use SQL Server 2014. The ERP application relies on...

DRAG DROP You plan to install two SQL Server 2012 environments named Environment1 and Environment2. Your company identifies the following availability requirements for each environment: Environment1 must have mirroring with manual failover implemented. Environment2 must have AlwaysOn with automatic failover implemented. You need to identify the minimum number of SQL...

HOTSPOT You have a Microsoft SQL Server instance that hosts a database named DB1 that contains 800 gigabyte (GB) of data. The database is used 24 hours each day. You implement indexes and set the value of the Auto Update Statistics option set to True. Users report that queries take...

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 reuse 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...