Pass the Microsoft Microsoft Certified: Azure Data Fundamentals DP-900 Questions and answers with CertsForce

Viewing page 9 out of 10 pages
Viewing questions 81-90 out of questions
Questions # 81:

Select the answer that correctly completes the sentence.

Question # 81


Expert Solution
Questions # 82:

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Question # 82


Expert Solution
Questions # 83:

You have data in a tabular format as shown in the following table.

Question # 83

Of which type of data is this an example?

Options:

A.

unstructured data


B.

semi-structured data


C.

document


D.

structured data


Expert Solution
Questions # 84:

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

Options:

A.

INSERT


B.

DISABLE


C.

ALTER


D.

DROP


Expert Solution
Questions # 85:

You have the following SQL query.

Question # 85

NOTE: Each correct selection is worth one point.

Question # 85


Expert Solution
Questions # 86:

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

NOTE: Each correct selection is worth one point.

Question # 86


Expert Solution
Questions # 87:

Select the answer that correctly completes the sentence.

Question # 87


Expert Solution
Questions # 88:

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

NOTE: Each correct selection is worth one point.

Question # 88


Expert Solution
Questions # 89:

Your company has a reporting solution that has paginated reports. The reports query a dimensional model in a data warehouse. Which type of processing does the reporting solution use?

Options:

A.

stream processing


B.

Online Transaction Processing (OLTP)


C.

batch processing


D.

Online Analytical Processing (OLAP)


Expert Solution
Questions # 90:

Select the answer that correctly completes the sentence.

Question # 90


Expert Solution
Viewing page 9 out of 10 pages
Viewing questions 81-90 out of questions