Course 1 Prep for DP900 Azure Data Fundamentals Flashcards

1
Q

Tabular data that is represented by rows and columns in a database is referred to as?

A

Structured data

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

T or F A key-value store is similar to a relational table except that each row can have any number of columns.

A

TRUE

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

Unstructured Data can be made up of which of the following?

A

,Audio and video files, and binary data file

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

Structured data is typically stored in which of the following?

A

SQL Server or Azure SQL Database.

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

T or F The process of splitting data into a large number of narrow, well-defined tables with references from one table to another is referred to as normalization?

A

TRUE

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

A transaction is defined as a sequence of operations that are atomic and the transactional database must adhere to the ACID properties. In this context, what does ACID stands for?

A

Atomicity guarantees that each transaction is treated as a single unit, which either succeeds completely, or fails completely.

Consistency ensures that a transaction can only take the data in the database from one valid state to another.

Isolation ensures that concurrent execution of transactions leaves the database in the same state that would have been obtained if the transactions were executed sequentially.

Durability guarantees that once a transaction has been committed, it will remain committed even if there’s a system failure such as a power outage or crash.

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

Advantages of Batch Processing?

A

Large volumes of data can be processed at a convenient time.

It can be scheduled to run at a time when computers or systems might otherwise be idle, such as overnight, or during off-peak hours.

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

T OR F Batch processing is suitable for handling large datasets efficiently. Stream processing is intended for individual records or micro-batches consisting of few records.

A

TRUE

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

Which of the following is an example of a streaming dataset?

A

Data from sensors and devices. EXAMPLE

Streaming handles data in real-time. Unlike batch processing, there’s no waiting until the next batch processing interval, and data is processed as individual pieces rather than being processed a batch at a time

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

Which of the following are key roles related to dealing with data in an organization?

A

Data Administrators
Data Engineers
Data Analysts

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

Who is responsible for the design, implementation, maintenance, and operational aspects of on-premises and cloud-based database solutions built on Azure data services and SQL Server?

A

Database Administrators manage databases, assigning permissions to users, storing backup copies of data, and restore data in case of any failures.

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

What is a schema in a relational database?

A

The structure of the database including table names, data types, index names, and other database objects

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

You are planning on migrating an existing SQL Server on-premises solution to the cloud. Which deployment option requires the fewest changes when migrating?

A

SQL Server on a virtual machine.

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

What is a DDL : Data Definition Language statement?

A

used to create and modify the structure of objects in a database using predefined commands and a specific syntax.

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

What tasks can be perform by a DDL?

A

Can perform the Create, alter and drop tasks

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

Which of the following can be used to present a virtual table of data based on a query?

A

A view is a virtual table based on the result set of a query

17
Q

Which data service in Azure uses a hierarchical namespace to store data?

A

Azure Data Lake Storage

18
Q

Question 8
Which of the following Azure SQL services allows for pausing the database during inactive periods and also provides automatic scaling when required?

A

Serverless SQL Database

19
Q

What is a security principal?

A

An object such as a user, group, or service that requests access to resources in Azure.