Online Access Free 70-765 Practice Test

You have just completed a new Microsoft SQL Server installation.
You need to configure a new SQL Server Agent alert to send an email to the DBA team for severity 20 errors.
Which three actions should you perform? Each correct answer presents part of the solution. (Choose three.)

• A.Define the alert settings.
• B.Set up an External Events collector.
• C.Set up SQL Mail.
• D.Define an operator.
• E.Configure a proxy.
• F.Set up Database Mail.
• G.Configure a credential object.

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You need to run a Transact-SQL script against a Microsoft Azure SQL database daily at 01:00.
Solution: You deploy Microsoft SQL Server to an Azure virtual machine, and then you use the SQL Server Agent to schedule a job.
Does this meet the goal?

• A.No
• B.Yes

You have a database named db1 and an application named App1. App1 queries DB1.
You discover that a non-clustered index in obi is corrupt.
You need to repair the index- App1 must be able to query osi while the index is being repaired.
What should you do?

• A.Run checkdb repair database and specify the allon_oata_loss parameter.
• B.Run checkdb repair database and specify the repair_rebuild parameter.
• C.Restore DB1 from a backup.
• D.Drop and recreate the index.

Your company has a single Microsoft SQL Server instance that hosts all company databases.
The SQL Server has the following configuration requirements:
The SQL Server Agent service is configured to start automatically on the SQL instance.
Autogrowth for databases is not permitted.
The SQL Server instance contains a database named Orders that stores order information from a web site application.
The MaxSize property for the database is set to 1 gigabyte (GB).
The SQL Server must email an administrator when the Orders database falls below 20 percent of available disk space.
You need to configure SQL Server objects to enable the email alerts.
Which SQL Server objects should you create? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
References:
https://solutioncenter.apexsql.com/how-to-be-proactively-alerted-of-sql-server-performance-problems/

You need to configure the data entry and business intelligence databases.
In the table below, identify the option that you must use for each database.
NOTE: Make only one selection in each column.

Correct Answer:

Explanation:
Data Entry: Geo-replicated database only
From Contoso scenario: Each location database for the data entry application may have an unpredictable amount of activity. Data must be replicated to secondary databases in Azure datacenters in different regions.
Business intelligence: Elastic database pools only
From Contoso scenario: For the business intelligence application, corporate executives must be able to view all data in near real-time with low network latency.
SQL DB elastic pools provide a simple cost effective solution to manage the performance goals for multiple databases that have widely varying and unpredictable usage patterns.
References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool