Course 1 Prep for DP900 Azure Data Fundamentals Flashcards
Tabular data that is represented by rows and columns in a database is referred to as?
Structured data
T or F A key-value store is similar to a relational table except that each row can have any number of columns.
TRUE
Unstructured Data can be made up of which of the following?
,Audio and video files, and binary data file
Structured data is typically stored in which of the following?
SQL Server or Azure SQL Database.
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?
TRUE
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?
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.
Advantages of Batch Processing?
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.
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.
TRUE
Which of the following is an example of a streaming dataset?
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
Which of the following are key roles related to dealing with data in an organization?
Data Administrators
Data Engineers
Data Analysts
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?
Database Administrators manage databases, assigning permissions to users, storing backup copies of data, and restore data in case of any failures.
What is a schema in a relational database?
The structure of the database including table names, data types, index names, and other database objects
You are planning on migrating an existing SQL Server on-premises solution to the cloud. Which deployment option requires the fewest changes when migrating?
SQL Server on a virtual machine.
What is a DDL : Data Definition Language statement?
used to create and modify the structure of objects in a database using predefined commands and a specific syntax.
What tasks can be perform by a DDL?
Can perform the Create, alter and drop tasks