Select the answer that correctly completes the sentence.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

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?

• A.an index
• B.a view
• C.a scalar function
• D.a table

Comment: *

Name: *

Email: *

Verification: *

Match the types of workloads to the appropriate scenarios.
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.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/batch-processing

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

You are reviewing the data model 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://en.wikipedia.org/wiki/Snowflake_schema
https://azure.microsoft.com/en-us/blog/data-models-within-azure-analysis-services-and-power-bi/

Comment: *

Name: *

Email: *

Verification: *