NEW QUESTION 1
When you create an Azure SQL database, which account can always connect to the database ?

• A. the Azure Active director/ (Azure AO) account that created the database
• B. the Azure Active Directly Azure AD) administrator account
• C. the sa account
• D. the server admin login account of the logical server

Answer: B

NEW QUESTION 2
To complete the sentence, select the appropriate option in the answer area.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 3
To complete the sentence, select the appropriate option in the answer area.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 4
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 5
Your company recently reported sales from the third quarter. You have the chart shown in the following exhibit.

Which type of analysis is shown for the fourth quarter?

• A. predictive
• B. prescription
• C. descriptive
• D. diagnostic

Answer: B

NEW QUESTION 6
You have a SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours. You need to minimize the cost of the SQL pool during idle times. The solution must ensure that the data remains intact.
What should you do on the SQL pool?

• A. Scale down the data warehouse units (DWUs).
• B. Pause the pool.
• C. Create a user-defined restore point.
• D. Delete the pool

Answer: B

NEW QUESTION 7
To complete the sentence, select the appropriate option in the answer area.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 8
You have the following JSON document.

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

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 9
Which two activities can be performed entirely by using the Microsoft Power BI service? Each correct answer presents a complete solution. (Choose two.)
NOTE: Each correct selection is worth one point.

• A. report and dashboard creation
• B. report sharing and distribution
• C. data modeling
• D. data acquisition and preparation

Answer: AD

NEW QUESTION 10
Which storage solution supports role-based access control (RBAC) at the file and folder level?

• A. Azure Disk Storage
• B. Azure Data Lake Storage
• C. Azure Blob storage
• D. Azure Queue storage

Answer: B

NEW QUESTION 11
When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?

• A. multi-master replication
• B. Availability Zones
• C. automatic failover
• D. the strong consistency level

Answer: B

NEW QUESTION 12
You have a transactional application that stem data in an Azure SQ1 managed instance. When should you implement a read-only database replica?

• A. You need to generate reports without affecting the transactional workload.
• B. You need to audit the transactional application.
• C. You need to implement high availability in the event of a regional outage
• D. You need to improve the recovery point objective (RPO).

Answer: C

NEW QUESTION 13
For each of the following statements, select yes if he statement is true, Otherwise select No. NOTE: Each correct selection is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 14
To complete the sentence, select the appropriate option in the answer area.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 15
What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

• A. complete control over backup and restore processes
• B. access to the latest features
• C. in-database machine learning services
• D. reduced administrative effort for managing the server infrastructure

Answer: BC

NEW QUESTION 16
Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?

• A. Azure SQL Database Hyperscale
• B. Azure SQL managed instance
• C. Azure SQL Database serveless
• D. Azure SQL Database elastic pod

Answer: B

NEW QUESTION 17
At which level in Azure Cosmos DB can you configure multiple write regions and read regions?

• A. database
• B. partition
• C. collection
• D. account

Answer: C

NEW QUESTION 18
......