- All Exams Instant Download
A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instanced. The environments host several customer databases
HOTSPOT A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instanced. The environments host several customer databases. You host a local database and a Stretch database that has a table named Members for one specific customer. You need to provide the customer with information about...
What should you create?
You administer a Microsoft SQL Server 2016 database named Contoso on a server named Server01. You need to be notified immediately when fatal errors occur on Server01. What should you create?A . an AlertB . a Server Audit SpecificationC . an Extended Event sessionD . a Resource PoolE . a...
What should you create?
You administer a Microsoft SQL Server 2016 database named Contoso on a server named Server01. You need to prevent users from disabling server audits in Server01. What should you create?A . an AlertB . a Resource PoolC . an Extended Event sessionD . a PolicyE . a Database Audit SpecificationF...
What should you include in the recommendation?
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...
Which backup option should you use?
You administer a Microsoft SQL Server 2016 database. You want to make a full backup of the database to a file on disk. In doing so, you need to output the progress of the backup. Which backup option should you use?A . STATSB . COMPRESSIONC . CHECKSUMD . IN ITView...
What should you do?
You are creating an application that will connect to the AgentPortal database by using a SQL login named AgentPortalUser. Stored procedures in the database will use sp_send_dbmail to send email messages. You create a user account in the msdb database for the AgentPortalUser login. You use the Database Mail Configuration...
What should you include in the recommendation?
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...
What should you do?
You administer a Microsoft SQL Server 2016 database. Users report that an application that accesses the database displays an error, but the error does not provide meaningful information. No entries are found in the SQL Server log or Windows event logs related to the error. You need to identify the...
What should you do?
You administer a Microsoft SQL Server 2016 instance that has multiple databases. You have a two-node SQL Server failover cluster. The cluster uses a storage area network (SAN). You discover I/O issues. The SAN is at capacity and additional disks cannot be added. You need to reduce the I/O workload...
What should you include in the recommendation?
You have a SQL Server 2014 environment That contains 20 servers. The corporate security policy states that all SQL Server 2014 instances must meet specific security standards. You need to recommend a management strategy for the SQL Server 2014 servers. What should you include in the recommendation? More than one...
