NEW QUESTION 1
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 2
What should you use to build a Microsoft Power BI paginated report?

• A. Power BI report Builder
• B. Power BI Desktop
• C. Charticulator
• D. the Power BI service

Answer: B

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
You need to recommend a non-relational data store that is optimized for storing and retrieving files, videos, audio stream, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file.
Which type of data store should you recommend?

• A. document
• B. key/value
• C. object
• D. columnar

Answer: C

NEW QUESTION 5
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 6
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 7
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 8
Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance.
Which Azure service should you use?

• A. Azure HDInsight
• B. Azure SQL Database
• C. Azure Cosmos DB
• D. SQL Server on Azure virtual machines

Answer: B

NEW QUESTION 9
You need to query a table named Products in an Azure SQL database.
Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. (Choose three.)
NOTE: Each correct selection is worth one point.

• A. You must be assigned the Reader role for the resource group that contains the database.
• B. You must have SELECT access to the Products table.
• C. You must have a user in the database.
• D. You must be assigned the Contributor role for the resource group that contains the database.
• E. Your IP address must be allowed to connect to the database.

Answer: ACE

NEW QUESTION 10
Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?

• A. Azure Queue storage
• B. Azure Data Lake Storage
• C. Azure table storage
• D. Azure Files

Answer: C

NEW QUESTION 11
Match the types of analytics that can be used to answer the business questions.
To answer, drag the appropriate analytics type from the column on the left to its question on the right. Each analytics type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 12
You have the following SQL query.

NOTE: Each correct selection is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 13
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 14
You have a quality assurance application that reads data from a data warehouse. Which type of processing does the application use?

• A. Online Transaction Processing (OLTP)
• B. batch processing
• C. Online Analytical Processing (OLAP)
• D. stream processing

Answer: A

NEW QUESTION 15
Your company if designing an application that will write a high volume of JSON data and will have an application-defined schema.
Which type of data store should you use?

• A. key/value
• B. document
• C. graph
• D. columnar

Answer: A

NEW QUESTION 16
When can you use an Azure Resource Manager template?

• A. to automate the creation of an interdependent group of Azure resources in a repeatable way
• B. to automate the creation of an interdependent and develop can deploy from the Azure portal
• C. To provision Azure subscriptions and apply policies for multi-tenant deployments
• D. To set complex permissions automatically on existing objects in an Azure subscription

Answer: C

NEW QUESTION 17
......