You have a SQL query that combines customer data and order data. The query includes calculated columns. You need to persist the SQL query so that other users can use the query. What should you create?
Correct Answer:
D
A view is a virtual table whose contents are defined by a query. A view acts as a filter on the underlying tables referenced in the view. The query that defines the view can be from one or more tables or from other views in the current or other databases.
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?
Correct Answer:
D
Which setting can only be configured during the creation of an Azure Cosmos DB account?
Correct Answer:
D
You must create a separate account for each API.
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.
Solution:
Does this meet the goal?
Correct Answer:
A
Match the types of activities to the appropriate Azure Data Factory activities.
To answer, drag the appropriate activity type from the column on the left to its Data Factory activity on the right. Each activity type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Solution:
Does this meet the goal?
Correct Answer:
A