NEW QUESTION 1
You need to develop a solution to provide data to executives. the solution must provide an interactive graphic interface, depict various key performance indications, and support data exploration by using drill down.
What should you use in Microsoft Power BI?

• A. a dashboard
• B. Microsoft Power Apps
• C. a dataflow
• D. a report

Answer: D

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
Match the types of data to the appropriate Azure data services.
To answer, drag the appropriate data types from the column on the left to its service on the right. Each data 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 4
What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. (Choose three.)
NOTE: Each correct selection is worth one point.

• A. denormalized data
• B. heavy writes and moderate reads
• C. light writes and heavy reads
• D. schema on write
• E. schema on read
• F. normalized data

Answer: BDE

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

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 6
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 7
Which Azure Data Factory component provides the compute environment for activities?

• A. a linked service
• B. an integration runtime
• C. a control flow
• D. a pipeline

Answer: A

NEW QUESTION 8
You have a table named Sales that contains the following data.

You need to query the table to return the average sales amount day. The output must produce the following results.

How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 9
Match the types of workloads the appropriate scenario.
To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload 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 10
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 11
Which command-line tool can you use to query Azure SQL databases?

• A. sqlcmd
• B. bcp
• C. azdata
• D. Azure CLI

Answer: D

NEW QUESTION 12
match the Azure data factory components to the appropriate descriptions.
To answer, drag the appropriate component from the column on the left to its description on the right. Each component 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 13
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 14
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 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
Match the Azure services to the appropriate locations in the architecture.
To answer, drag the appropriate service from the column on the left to its location on the right. Each service 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 17
To complete the sentence, select the appropriate option in the answer area.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 18
......