You have SQL Server 2019 on an Azure virtual machine that runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory.
You scale up the virtual machine to 16 vCPUSs and 64 GB of memory.
You need to provide the lowest latency for tempdb.
What is the total number of data files that tempdb should contain?

• A.2
• B.4
• C.8
• D.64

Comment: *

Name: *

Email: *

Verification: *

You have an Always On availability group deployed to Azure virtual machines. The availability group contains a
database named DB1 and has two nodes named SQL1 and SQL2. SQL1 is the primary replica.
You need to initiate a full backup of DB1 on SQL2.
Which statement should you run?
BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/

• A.mycontainer/DB1.bak' with (Differential, STATS=5, COMPRESSION);
  BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/
• B.mycontainer/DB1.bak' with (COPY_ONLY, STATS=5, COMPRESSION);
  BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/
• C.mycontainer/DB1.bak' with (File_Snapshot, STATS=5, COMPRESSION);
  BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/
• D.mycontainer/DB1.bak' with (NoInit, STATS=5, COMPRESSION);

Comment: *

Name: *

Email: *

Verification: *

DRAG DROP
You have SQL Server on an Azure virtual machine named SQL1.
SQL1 has an agent job to back up all databases.
You add a user named dbadmin1 as a SQL Server Agent operator.
You need to ensure that dbadmin1 receives an email alert if a job fails.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

Correct Answer:

Section: [none]
Explanation:
Step 1: Enable the email settings for the SQL Server Agent.
To send a notification in response to an alert, you must first configure SQL Server Agent to send mail.
Step 2: Create a job alert
Step 3: Create a job notification
Example:
-- adds an e-mail notification for the specified alert (Test Alert)
-- This example assumes that Test Alert already exists
-- and that François Ajenstat is a valid operator name.
USE msdb ;
GO
EXEC dbo.sp_add_notification
@alert_name = N'Test Alert',
@operator_name = N'François Ajenstat',
@notification_method = 1 ;
GO
Reference:
https://docs.microsoft.com/en-us/sql/ssms/agent/notify-an-operator-of-job-status
https://docs.microsoft.com/en-us/sql/ssms/agent/assign-alerts-to-an-operator

Comment: *

Name: *

Email: *

Verification: *

DRAG DROP
You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 is 30 TB and has a 1-GB daily rate of change.
You back up the database by using a Microsoft SQL Server Agent job that runs Transact-SQL commands. You perform a weekly full backup on Sunday, daily differential backups at 01:00 in the morning, and transaction log backups every five minutes.
The database fails on Wednesday at 10:00 in the morning.
Which three backups should you restore in sequence? To answer, move the appropriate backups from the list of backups to the answer area and arrange them in the correct order.
Select and Place:

Correct Answer:

Section: [none]

Comment: *

Name: *

Email: *

Verification: *

You have an Azure SQL database.
You are reviewing a slow performing query as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/performance/live-query-statistics?view=sql-server-ver15

Comment: *

Name: *

Email: *

Verification: *