You have SQL Server on an Azure virtual machine.
You need to add a 4-TB volume that meets the following requirements:
Maximizes IOPs
Uses premium solid state drives (SSDs)
What should you do?

• A.Attach two mirrored 4-TB SSDs.
• B.Attach a stripe set that contains four 1-TB SSDs.
• C.Attach a RAID-5 array that contains five 1-TB SSDs.
• D.Attach a single 4-TB SSD.

Comment: *

Name: *

Email: *

Verification: *

You have SQL Server on an Azure virtual machine that contains a database named DB1.
You view a plan summary that shows the duration in milliseconds of each execution of query 1178902 as shown in the following exhibit:

What should you do to ensure that the query uses the execution plan which executes in the least amount of time?

• A.Force the query execution plan for plan 1221065.
• B.Run the DBCC FREEPROCCACHEcommand.
• C.Force the query execution plan for plan 1220917.
• D.Disable parameter sniffing.

Comment: *

Name: *

Email: *

Verification: *

You have a Microsoft SQL Server database named DB1 that contains a table named Table1.
The database role membership for a user named User1 is 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/security/authentication-access/database-level-roles

Comment: *

Name: *

Email: *

Verification: *

D18912E1457D5D1DDCBD40AB3BF70D5D
What should you do after a failover of SalesSQLDb1 to ensure that the database remains accessible to SalesSQLDb1App1?

• A.Configure SalesSQLDb1 as writable.
• B.Update the connection strings of SalesSQLDb1App1.
• C.Update the firewall rules of SalesSQLDb1.
• D.Update the users in SalesSQLDb1.

Comment: *

Name: *

Email: *

Verification: *

Your company uses Azure Stream Analytics to monitor devices.
The company plans to double the number of devices that are monitored.
You need to monitor a Stream Analytics job to ensure that there are enough processing resources to handle the additional load.
Which metric should you monitor?

• A.Input Deserialization Errors
• B.Late Input Events
• C.Early Input Events
• D.Watermark delay

Comment: *

Name: *

Email: *

Verification: *