Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

DP-203 Data Engineering Azure > 1. DP-203 Microsoft Azure in Data Engineering > Flashcards

1. DP-203 Microsoft Azure in Data Engineering Flashcards

1
Q

High-availability systems must be available most of the time. Service-level agreements (SLAs) specify your organization’s availability expectations. System uptime can be expressed as three nines, four nines, or five nines. These expressions indicate system uptimes of 99.9 percent, 99.99 percent, or 99.999 percent.

How many downtime hours per year will be covered with an SLA of 99.9% uptime?

A

8.76 Hours

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Which of the following terms describes the final cost of owning a given technology and includes the following costs:

Hardware

Software licensing

Labor (installation, upgrades, maintenance)

Datacenter overhead (power, telecommunications, building, heating and cooling)

A

TCO
The total cost of ownership (TCO) is the purchase price of an asset plus the costs of operation. Assessing the total cost of ownership represents taking a bigger picture look at what the product is and what its value is over time.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Azure supports both structured and unstructured data. Unstructured data in Azure would commonly be held in which of the following?
-Azure SQL Data Warehouse
-Azure SQL Database
-Azure Cosmos DB

A

Azure Cosmos DB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

The term lift and shift is used when migrating physical or virtualized servers from an on-premises environment to a Microsoft Azure virtual machine cloud-based environment without the need to rearchitect the application.

Which of the following are benefits of carrying out a Lift and Shift operation?

Select all options that apply.

-Lower operational costs
-Higher Availability
-Take advantage of all Azure Features.

A

-Lower operational costs
-Higher Availability

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

The schema of what data type can be defined at query time.

A

Unstructured data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Which cloud technical requirement is met by duplicating customer content for redundancy and meeting service-level agreements (SLAs) in Azure?

A

High availability

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

As data processing techniques change with technology, new roles are starting to appear. These roles provide specialized skills to help streamline the data engineering process. Which of the following roles have been identified as new roles in modern data Projects?

-Database Administrator
-Artificial Intelligence Engineer
-Data Scientist
-Data Engineer

A

-Artificial Intelligence Engineer
-Data Scientist
-Data Engineer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

The role of a Data Engineer includes which of the following tasks?

Select all options that apply.

-Manage, monitor, and ensure the security and privacy of data to satisfy business needs.

-Working with services such as Cognitive Services, Cognitive Search, and Bot Framework.

-Using services and tools to ingest, egress, and transform data from multiple sources.

-Perform advanced analytics to extract value from data

A

-Manage, monitor, and ensure the security and privacy of data to satisfy business needs.

-Using services and tools to ingest, egress, and transform data from multiple sources.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Data Engineers may sometimes perform ETL process when processing data. The extract may come from many sources including databases, files, and streams. As part of the Extract process which of the following information must be supplied?

-Define the Data Source
-Define the Data
-Define the Transformation

A

-Define the Data Source
-Define the Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

In Microsoft Azure, Data Engineers will use several tools to perform ETL processes.

Which of the following tools will commonly be used to perform ETL processes in Azure?

-Azure Cosmos DB
-Azure Synapse Analytics
-Azure Data Factory

A

-Azure Data Factory

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Which role works with Azure Cognitive Services, Cognitive Search, and the Bot Framework?

A

AI engineer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Which Azure data platform is commonly used to process data in an ELT framework?

-Azure Data Lake Storage
-Azure Data Factory
-Azure Databricks

A

-Azure Data Factory

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Moving resources such as servers and services from an on-premises environment to a cloud-based solution will have a benefit on which of the following.

A

Both capital and operational expenditure

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Which of the following data processing frameworks are used by data engineers to ingest data from an on-premises database to an on-premises data warehouse?

A

Extract, Transform, and Load (ETL)

Extract, Transform and Load (ETL) is a typical process for ingesting data from an on-premises database to an on-premises data warehouse.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Unstructured data differs from Structured Data in many features. \
Which of the following are features of Unstructured data?
Select all options that apply.

-Commonly stored in data warehouses
-Predefined format
-Native format
-Commonly stored in data lakes
-Schema-on-write
-Schema-on-read.

A

-Schema-on-read.
-Commonly stored in data lakes
-Native format

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Data Engineers may sometimes perform ETL process when processing data. The extract may come from many sources including databases, files, and streams. These data sources can have unique data formats including which of the following?
Choose all that apply.

-Unstructured
-Semi-structured
-Structured
-Partially structured

A

-Unstructured
-Semi-structured
-Structured

17
Q

The Extract Load and Transform (ELT) process has which of the following benefits.
Select all options that apply.

-Data will be transformed prior to storage in the destination
-Reduces the time required to load the data into a destination system.
-Data can be stored in its original format.

A

-Reduces the time required to load the data into a destination system.
-Data can be stored in its original format.

18
Q

A Data Engineers scope of work includes the process of getting, ingesting, transforming, validating, and cleaning up data to meet business requirements. Which of the following terms describe this process?

A

-Data Wrangling

19
Q

Which data processing framework will a data engineer use to ingest data onto cloud data platforms in Azure?

A

Extract, load, and transform (ELT)

ELT is a typical process for ingesting data from an on-premises database into the cloud.

20
Q

Data Engineers may sometimes perform ETL process when processing data. The extract may come from many sources including databases, files, and streams. As part of the Extract process which of the following information must be supplied?
Select all options that apply.

-Define the Data Source
-Define the Data
-Define the Transformation

A

-Define the Data Source
-Define the Data

21
Q

Azure provides many data platform technologies to meet the needs of common data varieties. In relational database systems like Microsoft SQL Server which of the following types of data structures is used?

A

Structured Data

22
Q

Nonstructured data is stored in nonrelational systems, commonly called unstructured or NoSQL systems. Which of the following are types of NoSQL databases?
Select all options that apply.

-Column Store Database
-Document databases.
-Relational database
-Key-value store
-Graph database

A

-Column Store Database
-Document databases.
-Key-value store
-Graph database

23
Q

You need to provision a data store that will store but not query data. You also want to avail of the cheapest storage option. Which of the following is most suitable in this scenario?

-Azure Blob
-Azure Queue
-Azure Files

A

-Azure Blob
Azure Blob is a scalable object store for text and binary data and is the cheapest option for this type of storage.

24
Q

Azure Data Lake Storage Gen 2 is designed to store massive amounts of data for big-data analytics. Which of the following are features of Azure Data Lake?
Select all options that apply.

-Limited support for Zone Redundant storage
-Security support for access control lists (ACLs)
-Hadoop compatibility
-Unlimited scalability

A

-Security support for access control lists (ACLs)
-Hadoop compatibility
-Unlimited scalability

25
Q

Which data platform technology is a globally distributed, multi model database that can perform queries in less than a second?

A

Azure Cosmos DB

26
Q

Which Azure service is the best choice to store documentation about a data source?

A

Azure Data Catalog

27
Q

Synapse SQL offers both serverless and dedicated resource models to work with both descriptive and diagnostic analytical scenarios. To provide predictable performance and cost you should create which of the following.

-Dedicated SQL pools
-Serverless SQL endpoints

A

-Dedicated SQL pools

28
Q

Azure Synapse Pipelines leverages the capabilities of Azure Data Factory and is a cloud-based solution for which of the following types of data ingestion and transformation?

A

ETL

29
Q

Azure Stream Analytics is a perfect solution to implement when your data is which of the following types?

A

Real-time Analysis

30
Q

Data Engineers configure ingestion components of Azure Stream Analytics by configuring data inputs from sources including Azure Event Hubs, Azure IoT Hub, or Azure Blob storage.
Azure Event Hub provides which of the following features.
Select all that apply

-Partitioned consumer model
-Big data streaming service
-Azure Storage

A

-Partitioned consumer model
-Big data streaming service

31
Q

Azure Cosmos DB is a globally distributed, multimodal database and can be deployed using several API models. Which of the following APIs are supported in Cosmos DB?
Select all options that apply.

-SQL
-MongoDB
-Cassandra
-Ansible

A

-SQL
-MongoDB
-Cassandra

32
Q

Which of the following services allow customers to store semi-structured datasets in Microsoft Azure?
Select all options that apply.

-Azure SQL Database
-Azure SQL Datawarehouse
-Azure Blob Storage
-Azure Cosmos DB
-Azure File storage

A

-Azure Blob Storage
-Azure Cosmos DB
-Azure File storage

33
Q

Azure Synapse Analytics is an integrated analytics platform and brings together which of the following features?

-Data integration
-Data backup
-Visualization
-Data warehousing
-Big data analytics

A

-Data integration
-Visualization
-Data warehousing
-Big data analytics

34
Q

Which of the following is a globally distributed multi-model database?

A

Azure Cosmos DB

35
Q

Which Azure service is the best choice to store documentation about a data source?

A

Azure Data Catalog

36
Q

Which of the following are types of NoSQL database?
Select all options that apply.

-Graph Database
-Key-value store
-Relational Database

A

-Graph Database
-Key-value store

37
Q

You have been asked by management to investigate a database solution in Azure that will satisfy the following.

Ability to build applications with guaranteed low latency and high availability anywhere, at any scale, and the capability to migrate existing MongoDB, and other NoSQL workloads to the cloud.
Which of the following solutions will be most appropriate?

-Azure SQL Database
-SQL Server on Virtual Machines
-Azure Database for MySQL
-Azure Cosmos DB

A

-Azure Cosmos DB
Azure Cosmos DB will provide applications with guaranteed low latency and high availability anywhere, at any scale, or migrate Cassandra, MongoDB, and other NoSQL workloads to the cloud

DP-203 Data Engineering Azure (3 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions