HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
HOTSPOT
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
What are two uses of data visualization? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. Represent trends and patterns over time.
B. Communicate the significance of data.
C. implement machine learning to predict future values.
D. Consistently implement business logic across reports
Which storage solution supports role-based access control (RBAC) at the file and folder level?
A. Azure Disk Storage
B. Azure Data Lake Storage
C. Azure Blob storage
D. Azure Queue storage
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
You have a quality assurance application that reads data from a data warehouse. Which type of processing does the application use?
A. Online Transaction Processing (OLTP)
B. batch processing
C. Online Analytical Processing (OLAP)
D. stream processing
Which statement is an example of Data Definition Language (DDL)?
A. SELECT
B. INSERT
C. DELETE
D. DROP
Which clause should you use in a SELECT statement to combine rows in one table with rows in another table?
A. SET
B. VALUES
C. KEY
D. JOIN
What is a primary characteristic of a relational database?
A. data is queried and manipulated by using a variant of the SQL language
B. a flexible data structure
C. a lack of dependencies between tables
D. a large amount of duplicate data