Pre-Summer Sale Special - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

What is the primary purpose of a data warehou se?

A.

to provide answers to complex queries that rely on data from multiple sources

B.

to provide transformation services between source and target data stores

C.

to provide read-only storage of relational and non-relational historical data

D.

to provide storage for transactional line-of-business (LOB) applications

Which statement is an example of Data Manipulation Language (DML)?

A.

INSERT

B.

DISABLE

C.

ALTER

D.

DROP

What is a difference between structured data and semi-structured data?

A.

Structured data has a fixed schema and semi-structured data has a flexible schema.

B.

Only Structured data supports entities.

C.

Structured data has a flexible schema and semi-structured data has a fixed schema.

D.

Only Structured data supports attributes.

Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?

A.

WHERE

B.

SELECT

C.

JOIN

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

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

A.

database

B.

partition

C.

collection

D.

account

Match the security components to the appropriate scenarios.

To answer, drag the appropriate component from the column on the left to its scenario on the right. Each component may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

Select the answer that correctly completes the sentence.

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.

Select the answer that correctly completes the sentence.