70-764 exam

You are designing a SQL Server database for an order fulfillment system. You create a table named Sales.Orders by using the following script: Each order is tracked by using one of the following statuses: - Fulfilled - Shipped - Ordered - Received You need to design the database to ensure...

You administer all the deployments of Microsoft SQL Server 2016 in your company. You need to ensure that data changes are sent to a non-SQL Server database server in near real time. You also need to ensure that data on the primary server is unaffected. Which configuration should you use?A...

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

You work as a Database Administrator (DBA) at ABC.com. You are in the process of deploying new servers running SQL Server 2012. You need to deploy a SQL Server 2012 server to host databases used to host databases used by Research and Development department. The databases used by the Research...

You administer a Microsoft SQL Server 2016 server. The MSSQLSERVER service uses a domain account named CONTOSOSQLService. You plan to configure Instant File Initialization. You need to ensure that Data File Autogrow operations use Instant File Initialization. What should you do? Choose all that apply.A . Restart the SQL Server...

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

You collect performance metrics on multiple Microsoft SQL Server instances and store the data in a single repository. You need to examine disk usage, query statistics, and server activity without building custom counters. What should you use?A . Activity MonitorB . Sp_who3 stored procedureC . Object Explorer in the Microsoft...

You are a database administrator for a Microsoft SQL Server 2016 instance. You need to ensure that data can be replicated from a production server to two reporting servers in real time. You also need to ensure that data on the reporting server is always accessible. Which solution should you...

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

You administer a Microsoft SQL Server 2016 database named Contoso on a server named Server01. You need to track all SELECT statements issued in the Contoso database only by users in a role named Sales. What should you create?A . An AlertB . A Resource PoolC . An Extended Event...