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 > 2. DP-203 - Data Storage in Azure > Flashcards

2. DP-203 - Data Storage in Azure Flashcards

1
Q

Which of the following are benefits of Azure cloud-based data storage solutions?

A

-Global Replication
-Automated backup and Recovery
-Multiple Data Types

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

What is data that adheres to a strict schema, often called relational data, referred to as?

A

Structured Data

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

In semi-structured data, the expression and structure of the data are defined by a serialization language. Which of the following are serialization languages?

A

-YAML
-JSON
-XML

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

The organization of unstructured data is ambiguous. Which of the following are examples of unstructured data?

A

-Text Files
-Media Files
-Log Files

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

Which of the following is a transactional database system that commonly support lots of users, has quick response times, and handles large volumes of data?

A

OLTP
Transactional databases are often called OLTP (Online Transaction Processing) systems. OLTP systems commonly support lots of users, have quick response times, and handle large volumes of data. They typically handle small or relatively simple transactions.

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

A YAML file stores which of the following types of data?

A

Semi Structured

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

Office files such as Word documents are an example of which type of data?

A

Unstructured

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

Transactions are often defined by a set of four requirements, referred to as ACID guarantees.

What does ACID stand for?

A

-Atomicity
Atomicity means a transaction must execute exactly once and must be atomic; either all of the work is done, or none of it is. Operations within a transaction usually share a common intent and are interdependent.

-Isolation
Isolation ensures that one transaction is not impacted by another transaction.

-Consistency
Consistency ensures that the data is consistent both before and after the transaction.

-Durability
Durability means that the changes made due to the transaction are permanently saved in the system. Committed data is saved by the system so that even in the event of a failure and system restart, the data is available in its correct state.

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

Which of the following Azure Database services offer the following five consistency levels:

  1. strong,
  2. bounded staleness,
  3. session,
  4. consistent prefix,
  5. eventual
A

Azure Cosmos dB

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

A storage account is a container that groups a set of Azure Storage services together.

Which of the following can be included in a storage account?

Select all options that apply

A

-Azure Tables
-Azure Files
-Azure Queues
-Azure Blobs

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

Suppose you have two video files stored as blobs. One of the videos is business-critical and requires a replication policy that creates multiple copies across geographically diverse datacenters. The other video is non-critical, and a local replication policy is sufficient. Which of the following options would satisfy both data diversity and cost sensitivity consideration?

A

Create two storage accounts. The first account makes use of Geo-redundant storage (GRS) and hosts the business-critical video content. The second account makes use of Local-redundant storage (LRS) and hosts the non-critical video content.

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

The name of a storage account must be:
-globally unique within Azure
-unique within your Azure Subscription
-unique within the containing resource group

A

Globally Unique within Azure

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

A storage account is an Azure resource and must therefore be included in what type of group?

A

Resource Group

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

You have added the required client libraries to your application and are ready to connect to your Azure storage account. To work with data in a storage account, your app will need two pieces of data. What are these pieces of data?

A

-Rest API Endpoint
-Access Key

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

When connecting an app to multiple storage accounts, what will your app require?

A

An access key for each storage account

Each storage account has two unique access keys that are used to secure it. If your app needs to connect to multiple storage accounts, your app will require an access key for each storage account.

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

Each Azure Storage account has two access keys. What is the purpose of having two keys?

A

To allow keys to be rotated (regenerated) periodically

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

When regenerating Access Keys, in which order should the steps be carried out in to prevent causing downtime in those applications that use them?

Select the correct sequence from the following:

A

The proper sequence to prevent downtime is

Update the connection strings in your application code to reference the secondary access key of the storage account.​

Regenerate the primary access key for your storage account using the Azure portal or command line tool.

Update the connection strings in your code to reference the new primary access key.

Finally, regenerate the secondary access key in the same manner.

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

Which of the following is a good analogy for the access keys of a storage account?

A

A username and password

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

Page blobs are used to hold random-access files up to a what size?

A

8 TB

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

You can use either the REST API or the Azure client library to programmatically access a storage account. What is the primary advantage of using the client library?

A

Convenience

Client libraries can save a significant amount of work for app developers because the API is tested, and it often provides nicer wrappers around the data models sent and received by the REST API.

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

Which of the following are features of the Azure Queue service?

A

-Queues are used to store lists of messages to be processed asynchronously.
-Queue messages can be up to 64 kilobytes in size, and a queue can contain millions of messages.
-It can store and retrieve messages

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

Which of the following types of Azure data is most suitable for highly available network file shares that can be accessed using the standard Server Message Block, or SMB, protocol?

A

Files

Files are suitable for managed file shares for cloud or on-premises deployments that can be accessed using the standard Server Message Block, or SMB, protocol.

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

Azure Storage provides a REST API to work with the containers and data stored in each storage account.

What would this HTTP command return?

GET https://[url-for-service-account]/?comp=list&include=metadata

A

A list of all Blobs in a container

The Storage REST APIs are accessible from anywhere on the Internet, by any app that can send an HTTP/HTTPS request and receive an HTTP/HTTPS response. To list all the blobs in a container, you would send something like this command.

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

Microsoft Azure Storage is a managed service that provides durable, secure, and scalable storage in the cloud. Azure Files enables you to set up highly available network file shares that can be accessed using the standard Server Message Block (SMB) protocol.

Which of the following are common scenarios where file shares can be used?

A

-Storing shared configuration files for VMs, tools, or utilities so that everyone is using the same version.

-Sharing data between on-premises applications and Azure VMs to allow migration of apps to the cloud over a period of time.

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

Identify the missing word(s) in the following sentence within the context of Microsoft Azure.

A single Azure subscription can host up to ____ storage accounts, each of which can hold ____ TB of data.

A

200 Storage Accounts / 500 TB of Data

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

True or false?

All data written to Azure Storage is automatically encrypted.

A

True

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

Azure Storage supports Azure Active Directory and role-based access control (or RBAC) for both resource management and data operations. You can assign RBAC roles that are scoped to which of the following?

Select all options that apply.

A

-A Resource Group
-A Subscription
-A Storage Account
-An Individual Container or Queue

28
Q

Azure Storage accounts can create authorized apps in Active Directory to control access to the data in which of the following?

-Azure Tables
-Azure Files
-Azure Blobs
-Azure Queues

A

-Azure Blobs
-Azure Queues

29
Q

In Azure Storage, clients can use a shared key or shared secret for authentication and to restrict access to resources. A Shared key is supported by which of the following storage models?

Select all options that apply.
-Disks
-Files
-Queues
-Tables
-Blobs

A

-Files
-Queues
-Tables
-Blobs

30
Q

True or False
In Azure Storage accounts, shared keys give access to everything in the account.

A

True

31
Q

You are required to grant access to a third-party app that uploads pictures to one of your Blob Stores. From a security perspective which of the following is recommended to delegate access and specify constraints such as permissions?

A

Shared Access Signature (SAS)

32
Q

You have a requirement to allow an app to retrieve a list of files in a file system and also be able to download files. Which type of Shared Access Signature should you implement?

A

Service Level SAS

33
Q

You have an Azure Storage service that must handle large amounts of data and high-volume transactions. Which of the following solutions in your opinion would be the most appropriate to reduce complexity and cost while still providing authentication?

A

Lightweight Service

34
Q

Question 4
By default, storage accounts accept connections from clients on any network. To limit access to selected networks you must first change this default action. Which of the following can you use to restrict access to selected networks?

-Resource Group
-Virtual Networks
-Specific IP Addresses
-Range of IP Addresses

A

-Virtual Networks
-Specific IP Addresses
-Range of IP Addresses

35
Q

Security alerts are triggered when anomalies occur. Azure provides various services including monitoring, recommendations, and remediation advice.

Which of the following notification features are available in Azure to trigger security alerts?

-Email Alerts
-SMS Messages
-Azure Security Center

A

-Email Alerts
-Azure Security Center

36
Q

Azure Defender for Storage provides an extra layer of security intelligence that detects unusual and potentially harmful attempts to access or exploit storage accounts. Azure Defender for Storage is currently available for which of the following storage types?

-Azure Data Lake Storage Gen 2
-Azure Disks
-Azure File Storage
-Blob Storage

A

-Azure File Storage
-Blob Storage
-Azure Data Lake Storage Gen 2

37
Q

A storage account has two keys that provide full access to the account.

Which of the following are good reasons to regenerate your storage account keys?

A

-As security best practice, similar to changing a password on a user account.
-The key may have been compromised due to a hacking attack which could allow the hacker full access to your storage account.
-

38
Q

Azure Storage Analytics service can be used to audit which of the following?
-Authentication mechanism
-Success of operations
-Resources that have been accessed
-Azure AD permission changes

A

-Authentication mechanism
-Success of operations
-Resources that have been accessed

39
Q

You have a requirement to allow an app to retrieve a list of files in a file system, download files, and create file systems. Which type of Shared Access Signature should you implement?

A

Account level SAS

40
Q

Azure Data Lake Storage Gen2 is built on which of the following storage services?

A

Azure Blob Storage

41
Q

Which of the following is a key characteristic of Azure Government?

A

Azure Government is a physically separate instance of Azure.

42
Q

Azure Defender for Storage is available in which of the following environments?
-Sovereign cloud regions
-All public clouds
-US Government Clouds
-Azure Government

A

-All public clouds
-US Government Clouds

43
Q

When you create an Azure Storage Account a default network, rule is created. What is the default rule that is applied?

A

To allow all connections from all networks

44
Q

Managing network access rules for Azure Storage accounts can be done with which of the following?
-Azure Portal
-Azure Powershell
-Azure CLI
-ARM Templates

A

-Azure Portal
-Azure Powershell
-Azure CLI (Command Line Interface)

45
Q

Which of the following describes a storage account that contains PDF documents, JPG images, JSON files, and video content?

A

Unstructured data

46
Q

Which of the following scenarios are suitable for Blob Storage solutions?
-Storing data for backup and restore, disaster recovery, and archiving
-Storing data that is queried frequently
-Serving images or documents directly to a browser
-Storing data for analysis by an on-premises or Azure-hosted service

A

-Storing data for backup and restore, disaster recovery, and archiving
-Serving images or documents directly to a browser
-Storing data for analysis by an on-premises or Azure-hosted service

47
Q

True or False?

Azure Virtual Machines uses blobs for hard-disk storage.​

A

True

48
Q

Which of the following statements is true of storage accounts and blob containers?

A

Every blob lives inside a blob container. You can store an unlimited number of blobs in a container and an unlimited number of containers in a storage account.

49
Q

Suppose you need to store profile and order information about your customers. You also need to query the data to answer questions like “who are my top visitors to my website.?” and “how many customers live in a specific town or city?” What storage solution would you recommend?

A

Relational Database

50
Q

How many access keys are provided for accessing your Azure storage account?

A

2

51
Q

Blobs are usually not appropriate for structured data that will be queried frequently. Which of the following is a characteristic? of blobs?

A

High Latency

52
Q

You are working on a new project and need to create storage accounts and blob containers for your application.

What is the best way to do this?

A

Create Azure storage accounts before deploying your app and then create containers in your application as needed.

53
Q

Which of the following are types of blobs that can store data?

-File
-Page
-Queue
-Append
-Block

A

-Page
-Append
-Block

54
Q

Azure Storage supports three kinds of blobs. Which type of blob storage is used for structures like OS and data disks for Virtual Machines
-Append Blobs
-Block Blobs
-Page Blobs

A

-Page Blobs

55
Q

You can use a service-level SAS to allow access to specific resources in a storage account. What can you use this type of SAS for?
-To allow an app to download a file
-To allow an app or user to create file systems
-To allow an app to retrieve a list of files in a file system

A

-To allow an app to download a file
-To allow an app to retrieve a list of files in a file system

56
Q

The organization you work at has two types of data:

  1. Private consumption
  2. Public consumption.

When considering Azure storage accounts, which of the following approaches is recommended to provide access control to the different types of data?

A

Enable virtual directories for the proprietary data and not for the public data with separate storage accounts for the proprietary and public data.

57
Q

What type of data would be in a storage account that holds customer information and sales records in tables with rows and columns?

A

Structured Data

58
Q

A JSON file stores which of the following types of data?

A

Semi Structured

59
Q

Azure Storage offers several types of storage accounts. What is the recommended storage type for block blobs and append blobs?
-Premium Storage
-Standard General Purpose v2

A

-Premium Storage

60
Q

What is the maximum size of a block blob storing text or binary files?

A

5 TB

61
Q

Azure Storage accounts can create authorized apps in Active Directory to control access to data in which of the following storage services?

Select all options that apply.
-Azure Files
-Azure Tables
-Azure Blobs
-Azure Queues

A

-Azure Blobs
-Azure Queues

62
Q

Your company is developing some new apps that need to access files in Blob storage. The company wants the Blob names in these apps to look like traditional file names and include file name extensions like .jpg to indicate what kind of data they contain. What type of storage design will need to be implemented to provide this feature?

A

Implement Virtual Directories

63
Q

Azure File Storage exposes file shares using what protocol?

A

Server Message Block 3.0

64
Q

Which of the following statements is true of Resource Groups, Storage Accounts, and Azure Cosmos DB?

A

Azure Cosmos DB can be included in an Azure Resource Group but cannot be included in an Azure Storage Account.

65
Q

Question 1
Which of the following are benefits of Azure cloud-based data storage solutions?

Select all options that apply.

-Automated backup and Recovery
-Global Replication
-Multiple Data Types
-Increased Capital Expenditure

A

-Automated backup and Recovery
-Global Replication
-Multiple Data Types

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