DP-900 quiz wiedzy

1 / 44

Transcribing audio files is an example of ??? analystics.

cognitive

descriptive

predictive

prescriptive

2 / 44

To configure an Azure Storage account to support access control lists that have object-level permissions,

set Performance to Premium

set Account kind to BlobStorage

enable the hierarchical namespace

set Replication to Read-access geo-redundant storage (RA-GRS)

3 / 44

A key/value data store is optimized for

emforcing constraints

table joins

simple lookups

transactions

4 / 44

... Enables the use of SQL queries against data stored in JSON documents.

Azure Cosmos DB

Azure Files

Azure Blob Storage

Azure Table Storage

5 / 44

To configure an Azure Storage account to support both security at the folder level and atomic directory manipulation,

enable the hierarchical namespace

set Replication to Read-access geo-redundant storage (RA-GRS)

set Performance to Premium

set Account kind to BlobStorage

6 / 44

Transparent Data Encryption (TDE) encrypts

a column to protect data at rest and in transit

the database to protect data at rest

the server to protect data at rest

queries and their result in order to protect data in transit

7 / 44

Which Azure storage solution provides native support for POSIX-complaint access control lists (ACLs)?

Azure Queue storage

Azure Data Lake Storage

Azure Files

Azure Table storage

8 / 44

When provisioning an Azure Cosmos DB account, which features provides redundancy within an Azure region?

Availability Zones

automatic failover

the strong consistency level

multi-master replication

9 / 44

A relational database must be used when

data will be stored as key/value pairs

strong consitency guarantees are required

a dynamic schema is requied

strong large images and videos

10 / 44

Descriptive analytics tells you

why something occured in the past

what is most likely to occur in the future

which actions you can perform to affect outcomes

what occured in the past

11 / 44

In batch processing

data is processed in real-time

processing can only execute serially

latency is expected

data is always inserted one row at a time

12 / 44

What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

bulit-in high availability

support for encription at rest

system-initatied automatic backups

Native support for cross-database queries and transactions

13 / 44

An extract, load and transform (ELT) process requires

a matching schema in the data source and data target

that the data target be a relation database

data that is fully processed before being loaded to the target data store

a target data store powerful enough to transform data

14 / 44

A relational database is appropriate for scenarios that involve a high volume of

changes to relationships between entities

transactional writes

writes that have varying data structures

geographically distributed writes

15 / 44

Relational data uses ... to enforce relationships between different tables

collections

partitions

keys

columns

16 / 44

Azure Database for PostgreSQL

Infrastructure as a Service (IaaS)

Software as a service (SaaS)

Platform as a service (PaaS)

17 / 44

An extract, transform, and load (ETL) process requires

data that is fully processed before being loaded to the target data store

that the data target be a relation database

a matching schema in the data source and data target

a target data store powerful enough to transform data

18 / 44

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

DISABLE

CREATE

UPDATE

REVOKE

19 / 44

When using the Azure Cosmos DB Gremlin API, the container resource type is projected as a

document

table

graph

partition key

20 / 44

In Azure Data Factory, you can use ..... to orchestrate pipeline activities that depend on the output of their pipeline activities

a control flow

a linked service

an integration runtime

a dataset

21 / 44

A visualization that shows a university's current student enrollment versus the maximum capacity is an example of..... analystics.

cognitive

descriptive

prescriptive

predictive

22 / 44

...Enables users to access data by using the server message block (SMB) version processed.

Azure Files

Azure Cosmos DB

Azure Blob Storage

Azure Table Storage

23 / 44

You can query a graph database in Azure Cosmos DB

an nodes and edges by using Gremlin language.

as a partitioned raw store by using Language Integrated Query (LINQ)

as JSON document by using a SQL-lije language

as a partitioned raw store by using Cassandra Query Language (CQL)

24 / 44

Creating closed caption text for audio files is an example of .... analytics.

cognitive

prescriptive

predictive

descriptive

25 / 44

When provisioning an Azure Cosmos DB ......, you need to specify which type od API you will use.

item

account

database

container

26 / 44

.... natively support the analysis of relationships between entities.

Key-value stores

Column family databases

Graph databases

Document databases

27 / 44

You need to create an Azure resource to store data in Azure Table storage. Which command should you run?

az cosmosdb create

az storage share create

az storage account create

az storage container create

28 / 44

The Azure Cosmos DB .... API enables the use of SELECT statemnets to retrieve documents form Azure Cosmos DB

Table

Gremlin

Core (SQL)

MongoDB

29 / 44

Which type of database is Azure Database for PostgreSQL?

on-premises

Platform as a service (PaaS)

Microsoft SQL Server

Infrastructure as a Service (IaaS)

30 / 44

A visualization that illustartes a university's current enrollment per department is an example of ..... analytics

prescriptive

descriptive

cognitive

predictive

31 / 44

Batch workloads,

process data as new data us received in near real-time

collect and process data at most once a day

collect data and the process the data when a condition is met

process data in memory, row-by-row

32 / 44

... is a virtual table that contains contect defined by a query

a heap

a stored procedure

an index

a view

33 / 44

In a data warehouse workload, data

from a single source is distributed to multiple locations

from multiple sources us combined in a single location

is added to a queue for multiple systems to process

is used to train machine learning models

34 / 44

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

GRANT

REVOKE

INSERT

DISABLE

35 / 44

In a SQL statement, ... are examples od aggregate functions

FROM and WHERE

JOIN and MERGE

GROUP BY and ORDER BY

MAX and MIN

36 / 44

By default, each Azure SQL database is protected by

a network security group (NSG)

Azure Firewall

a server-level firewall

Azure Front Door

37 / 44

Relational data is stored in

a tabular form of rows and columns

comma-separated value (CSV) files

a file system as unstructered data

a hierarchical folder structure

38 / 44

A block of code that runs in a database is called

an index

a table

a stored procedure

a view

39 / 44

Which statement is an example of Data Definition Language (DDL)?

DELETE

DROP

SELECT

INSERT

40 / 44

The massively parallel processing (MPP) engine of Azure Synapse Analystics

redirects client connections across computes nodes

distributes processing across compute nodes

distributes processing across control nodes

redirects client connections across computes nodes

41 / 44

........ is an object aassociated with a table that sorts and stores the data rows in the table based on their key values

A clustered index

A FileTable

A stored procedure

A foreign key

42 / 44

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

Azure Queue storage

Azure Cosmos DB

Azure Data Lake Storage

Azure Blob storage

43 / 44

PostgreSQL on Azure VMs

Infrastructure as a Service (IaaS)

Platform as a service (PaaS)

Software as a service (SaaS)

44 / 44

... presents content defined by a query

a heap

an index

a stored procedure

a view

Zakończ quiz

Podobne quizy

Quiz wiedzy

10 pytań z wiedzy ogólnej - dasz radę zdobyć 8/10? #18

pixabay.com

Quiz wiedzy

Codzienny quiz wiedzy - podejmij wyzwanie QuizMe! #114

pixabay.com

Quiz wiedzy

Codzienny quiz wiedzy - podejmij wyzwanie QuizMe! #65

pixabay.com

Quiz na czas

150 sekund - maksymalnie tyle zajmie Ci rozwiązanie tego quizu wiedzy ogólnej! #52

pixabay.com

Quiz wiedzy

Codzienny quiz wiedzy - podejmij wyzwanie QuizMe! #32

pixabay.com

Quiz wiedzy

Codzienny quiz wiedzy - podejmij wyzwanie QuizMe! #12

Podobne działy

Uzupełnij brakujący wyraz

Rozsypane litery

Poniedziałkowe ekspresy

Rozsypane litery - Imiona

Quizy wielkanocne

Quizy bożonarodzeniowe

Gra państwa-miasta

Disney