DP-900 pt 3

A block of code that runs in a database is called ​ (a)  

• stored procedure
• table
• view
• index

Match the types of analytics that can be used to answer the business questions.

a

b

c

Diagnostic

Prescriptive

Cognitive

​ (a)   presents content defined by a query.

• view
• heap
• index
• stored procedure

Which type of database is Azure Database for PostgreSQL?

• Platform as a service (PaaS)

• Infrastructure as a service (IaaS)

• Microsoft SQL Server

• on-premises

Which storage solution supports access control lists (ACLs) at the file and folder level?

• Azure Data Lake Storage

• Azure Queue storage

• Azure Blob storage

• Azure Cosmos DB

A ​ (a)   is a chart of colored rectangles. the size of rectangles represent the relative value of each item. the chart can be hierarchical, displaying data as a set of rectangles nested within the main rectangle.

• treemap
• matrix
• scatter
• line chart

What is a characteristic of batch processing?

• The data ingested during batch processing must be processed as soon as the data is received.

• Large datasets must be split into batches of less than 1 GB before the data can be processed.

• There is a noticeable time delay between ingesting data and obtaining the data processing results.

• Batch processing can only process data that is structured.

Ina SQL statement, ​ (a)   are examples of aggregate functions

• MAX and MIN
• JOIN and MERGE
• GROUP BY and ORDER BY
• FROM and WHERE

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

• yes

• no

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

• yes

• no