Brainscape's Knowledge GenomeTM

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


See full index

Data Fundamentals > Azure Data Fundamentals > Flashcards

Azure Data Fundamentals Flashcards

1
Q

Which type of data structure allows you to store data in a two-column format without requiring a complex database management system?

A

key/value store

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

What is the best DBMS for create, read, update, and delete (CRUD) operations and uses the least amount of storage space

A

relational database

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

What DBMS uses unstructured data such as JSON, and optimized for retrieval

A

document database

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

What type of DBMS is used to store hierarchical data, such as organizational charts that have nodes and edges.

A

graph database

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

What type of databases are commonly used to store and query structured data.

A

Relational databases

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

An entity is a

A

table

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

A table should have what kind of keys

A

Primary and foreign

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

This reduces storage space a data duplication in relational databases

A

Normalization

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

These databases in which each record consists of a unique key and an associated value, which can be in any format.

A

Key-value databases

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

These databases, which are a specific form of key-value database in which the value is a JSON document (which the system is optimized to parse and query)

A

Document databases,

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

These databases, which store tabular data comprising rows and columns, but you can divide the columns into groups known as column-families. Each column family holds a set of columns that are logically related together.

A

Column family databases

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

These databases store entities as nodes with links to define relationships between them.

A

Graph databases

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

These databases organize data as a series of two-dimensional tables with rows and columns.

A

Relational databases

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

Records are frequently created and updated.
Multiple operations have to be completed in a single transaction.
Relationships are enforced using database constraints.
Indexes are used to optimize query performance.

A

RDMS

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

What Azure Services support relational dbs

A

Azure SQL Database
Azure Database for MySQL
Azure Database for PostgreSQL
Azure Database for MariaDB

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

Records are frequently created and updated.
Multiple operations have to be completed in a single transaction.
Relationships are enforced using database constraints.
Indexes are used to optimize query performance.

A

RDMS

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

What data store model requires Data to be highly normalized.
Database schemas are required and enforced.
Many-to-many relationships between data entities in the database.
Constraints are defined in the schema and imposed on any data in the database.
Data requires high integrity. Indexes and relationships need to be maintained accurately.
Data requires strong consistency. Transactions operate in a way that ensures all data are 100% consistent for all users and processes.
Size of individual data entries is small to medium-sized

A

RDMS

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

Where Data is highly normalized.
Database schemas are required and enforced.
Many-to-many relationships between data entities in the database.

A

RDMS

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

Where Constraints are defined in the schema and imposed on any data in the database.
Data requires high integrity. Indexes and relationships need to be maintained accurately.
Data requires strong consistency. Transactions operate in a way that ensures all data are 100% consistent for all users and processes.
Size of individual data entries is small to medium-sized

A

RDMS

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

Where Data requires strong consistency. Transactions operate in a way that ensures all data are 100% consistent for all users and processes.
Size of individual data entries is small to medium-sized

A

RDMS

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

Where each data value with a unique key. Most key/value stores only support simple query, insert, and delete operations. .

A

key/value store

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

What data store model Where modify a value (either partially or completely), an application must overwrite the existing data for the entire value. In most implementations, reading or writing a single value is an atomic operation

A

key/value store

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

Where An application can store arbitrary data as a set of values. Any schema information must be provided by the application. The key/value store simply retrieves or stores the value by key.

A

key/value store

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

What service support key/value pairs

A

Azure Cosmos DB for Table and Azure Cosmos DB for NoSQL
Azure Cache for Redis
Azure Table Storage

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

What data store model should you select where the workload Data is accessed using a single key, like a dictionary.
No joins, lock, or unions are required.
No aggregation mechanisms are used.
Secondary indexes are generally not used.

A

Key value pair

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

What data store model would be suited for Data caching, Session management, User preference and profile management, Product recommendation and ad serving

A

Key value pair

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

What data store model would be suited for workloads where insert and update operations are common.
No object-relational impedance mismatch. Documents can better match the object structures used in application code.
Individual documents are retrieved and written as a single block.
Data requires index on multiple fields.

A

Document databases

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

What data store model would be suited for workloads where datatypes can be managed in de-normalized way.
Size of individual document data is relatively small.
Each document type can use its own schema.
Documents can include optional fields.
Document data is semi-structured, meaning that data types of each field are not strictly defined.

A

Document databases

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

What data store model would be suited for Product catalog
Content management
Inventory management

A

Document databases

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

What Azure services support Document databases

A

Azure Cosmos DB for NoSQL

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

What data store model stores a collection of documents, where each document consists of named fields and data. Documents are retrieved by unique keys.

A

Document databases

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

This data store model stores two types of information, nodes and edges.

A

Graph databases

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

What services support Graph databases?

A

Azure Cosmos DB for Apache Gremlin
SQL Server

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

What data store model would be suited for workloads where Complex relationships between data items involving many hops between related data items.
The relationship between data items are dynamic and change over time.
Relationships between objects are first-class citizens, without requiring foreign-keys and joins to traverse.

A

Graph databases

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

What data store model stores Nodes and relationships.

A

Graph databases

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

These are similar to table rows or JSON documents.
in graph databases

A

Nodes

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

These are just as important as nodes, and are exposed directly in the query language.

A

Relationships

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

These specify relationships between nodes in graph databases

A

Edges

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

This data store model is ideal for Organization charts, Social graphs, Fraud detection, Recommendation engines

A

Graph databases

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

These provide massively parallel solutions for ingesting, storing, and analyzing data. The data is distributed across multiple servers to maximize scalability.

A

Data analytics stores

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

These data stores use large data file formats such as delimiter files (CSV), parquet, and ORC

A

Data Analytics

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

What azure services use data analytics data stores models

A

Azure Synapse Analytics
Azure Data Lake
Azure Data Explorer
Azure Analysis Services
HDInsight
Azure Databricks

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

What data store model would be suited for workloads where Data analytics
Enterprise BI

A

Data analytics

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

Which type of database can be used for semi-structured data that will be processed by an Apache Spark pool in Azure Synapse Analytics?

A

Column-family databases

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

This data base store model organizes data into rows and columns and uses a denormalized approach to structuring sparse data.

A

Column-family databases

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

What azure services provide Column-family databases

A

Azure Cosmos DB for Apache Cassandra
HBase in HDInsight

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

What data store model perform write operations extremely quickly,
Update and delete operations are rare and is
designed to provide high throughput and low-latency access.
Supports easy query access to a particular set of fields within a much larger record.
Massively scalable.

A

column-family

Is an example of a non relational data store

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

What data store model uses tables consisting of a key column and one or more column families.

A

column-family

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

What data store model is ideal for Recommendations
Personalization
Sensor data
Telemetry
Messaging
Social media analytics
Web analytics
Activity monitoring
Weather and other time-series data

A

column-family

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

What data store model is a set of values organized by time and typically collect large amounts of data in real time from a large number of sources.

A

Time series databases

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

What data store model where Updates are rare, and deletes are often done as bulk operations. The records written are generally small, there are often a large number of records, and total data size can grow rapidly.

A

Time series databases

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

What azure services provide a time series database

A

Azure Time Series Insights

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

What data store model is ideal for Monitoring and event telemetry.
Sensor or other IoT data.

A

Time series databases

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

What azure services are commonly used for data object storage

A

Blob Storage
Azure Data Lake Storage Gen2

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

This database does not use the tabular schema of rows and columns found in most traditional database systems.

A

non-relational database

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

This type of database is optimized for the specific requirements of the type of data being stored. For example, data may be stored as simple key/value pairs, as JSON documents, or as a graph consisting of edges and vertices.

A

non-relational database

does not use the tabular schema of rows and columns

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

Document data stores, Columnar data stores, Key/value data stores,
Graph data stores, Time series data stores, Object data stores are all examples of what?

A

Non-relational data and NoSQL

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

Which Azure data service allows you to store document, graph, and column-family databases?

A

Azure Cosmos DB

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

True or false: Azure SQL Database cannot handle column-family databases

A

True

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

This is a fully managed platform-as-a-service (PaaS) database hosted in Azure

A

Azure SQL Database

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

This is a hosted instance of SQL Server with automated maintenance, which allows more flexible configuration than Azure SQL DB but with more administrative responsibility for the owner.

A

Azure SQL Managed Instance

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

This is a virtual machine with an installation of SQL Server, allowing maximum configurability with full management responsibility.

A

Azure SQL VM

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

This role typically provision and manage Azure SQL database systems to support line of business (LOB) applications that need to store transactional data.

A

Database administrators

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

This role may use Azure SQL database systems as sources for data pipelines that perform extract, transform, and load (ETL) operations to ingest the transactional data into an analytical system.

A

Data engineers

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

This role may query Azure SQL databases directly to create reports, though in large organizations the data is generally combined with data from other sources in an analytical data store to support enterprise analytics.

A

Data analysts

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

What open source relational databases does azure provide

A

MySQL
MariaDB
PostgreSQL

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

A simple-to-use open-source database management system that is commonly used in Linux, Apache, MySQL, and PHP (LAMP) stack apps.

A

Azure Database for MySQL

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

Open source that offers compatibility with Oracle

A

Azure Database for MariaDB

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

A hybrid relational-object database. You can store data in relational tables, and custom data types, with their own non-relational properties.

A

Azure Database for PostgreSQL

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

A global-scale non-relational (NoSQL) database system that supports multiple application programming interfaces (APIs), enabling you to store and manage data as JSON documents, key-value pairs, column-families, and graphs.

A

Azure Cosmos DB

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

WhatAzure service provides key/attribute storage for applications that need to read and write data values quickly at a low cost

A

Azure tables

You can store any number of entities in a table,

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

network file shares such as you typically find in corporate networks

A

AzureFiles

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

scalable, cost-effective storage for binary files.

A

Blob containers

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

This azure service enables you to define and schedule data pipelines to transfer and transform data. You can integrate your pipelines with other Azure services, enabling you to ingest data from cloud data stores, process the data using cloud-based compute, and persist the results in another data store.

A

Azure Data Factory

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

ThisAzure service is a comprehensive, unified Platform-as-a-Service (PaaS) solution for data analytics that provides a single service interface for multiple analytical capabilities,

A

Azure Synapse Analytics

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

Which combines the Apache Spark data processing platform with SQL database semantics and an integrated management interface to enable large-scale data analytics.

A

Databricks

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

Azure service that provides Azure-hosted clusters for popular Apache open-source big data processing technologies, including:

Apache Spark
Apache Hadoop
Apache Hive
Apache Kafka

A

Azure HDInsight

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

This analytics PaaS provides a single service interface for multiple analytical capabilities, including
Pipelines
SQL
Apache Spark
Azure Synapse Data Explorer

A

Azure Synapse Analytics

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

A real-time stream processing engine that captures a stream of data from an input, applies a query to extract and manipulate data from the input stream, and writes the results to an output for analysis or further processing.

A

Azure Stream Analytics

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

A standalone service that offers the same high-performance querying of log and telemetry data as the Azure Synapse Data Explorer runtime in Azure Synapse Analytics.

A

Azure Data Explorer

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

You have data stored in two tables in a database.

You create a relationship between the tables.

Which type of data do you have?

A

structured

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

This data format has some structure, but which allows for some variation between entity instances.
One common format for semi-structured data is JavaScript Object Notation (JSON).

A

Semi-structured data

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

This data format adheres to a fixed schema, so all of the data has the same fields or properties. The data is represented in one or more tables that consist of rows to represent each instance of a data entity, and columns to represent attributes of the entity.

A

Structured data

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

This data format is information that has some structure, but which allows for some variation between entity instances.

A

Semi-structured data

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

You have a folder that contains documents, images, and audio files.

Which type of data do you have?

A

unstructured

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

Which type of data should be sent from video cameras in a native binary format?

A

unstructured

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

Which type of database should you use to store sequential data in the fastest way possible?

A

Time series database

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

What database is used to store hierarchical data, such as organizational charts that have nodes and edges

A

Graph

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

What azure service database is the best option for create, read, update, and delete (CRUD) operations, uses the least amount of storage space.

A

Azure SQL Database

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

Which Azure Cosmos DB API allows you to implement a non-relational database and model nodes that have relationships between them?

A

Apache Gremlin

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

This data is often stored in plain text format with specific field delimiters and row terminators.

A

Delimited text files

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

is a ubiquitous format in which a hierarchical document schema is used to define data entities (objects) that have multiple attributes. Each attribute might be an object (or a collection of objects);

A

JSON

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

This file storage format format that’s good for both structured and semi-structured data.

A

JSON

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

Type of workload

highly denormalized
optimized for read operations are two attributes are characteristics of ?

A

analytical data workload?

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

ACID

A

Atomicity
Consistency
Isolation
Durability

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

This guarantees that each transaction is treated as a single “unit”, which either succeeds completely or fails completely: if any of the statements constituting a transaction fails to complete, the entire transaction fails and the database is left unchanged.

A

Atomicity

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

This ensures that a transaction can only bring the database from one consistent state to another, preserving database invariants: any data written to the database must be valid according to all defined rules, including constraints, cascades, triggers, and any combination thereof.

A

Consistency

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

These are often executed concurrently (e.g., multiple transactions reading and writing to a table at the same time). and ensures that concurrent execution of transactions leaves the database in the same state that would have been obtained if the transactions were executed sequentially.

A

Isolation

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

This guarantees that once a transaction has been committed, it will remain committed even in the case of a system failure (e.g., power outage or crash).

A

Durability

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

Normalization, Schema, Consistency, Tabularare traits of what type of data store

A

traits of transactional data

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

Which type of data workload is optimized for updates and relies on relationships between entities to correlate data?

A

transactional

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

These workloads are optimized for create, read, update, and delete (CRUD) operations and are highly denormalized

A

Transactional workloads

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

These workloads store hierarchical data.

A

Graph

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

type of workload

Read operations are optimized.
They calculate business metrics over time.
They operate on historical data.

A

analytical data workloads

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

These data workloads operate on historical data, are optimized for read operations, and calculate business metrics over time.

A

Analytical data workloads

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

Which feature of transactional data processing guarantees that concurrent processes cannot see the data in an inconsistent state?

A

isolation

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

This in transactional data processing ensures that concurrent transactions cannot interfere with one another and must result in a consistent database state.

A

Isolation

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

Which job role is responsible for designing database solutions, creating databases, and developing stored procedures?

A

database engineer

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

Which job role is responsible for troubleshooting index performance, provisioning access to databases, and backing up databases?

A

database administrator

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

Which job role is responsible for building data models and finding hidden data patterns?

A

data analyst

104
Q

Which two keys are needed to create a one-to-many relationship between two tables in a relational database? Each correct answer presents part of the solution.

A

a foreign key, a primary key

105
Q

Which SQL operation is used to combine the content of two tables based on a shared column?

A

JOIN

106
Q

This is used to combine data from two tables based on a shared key

A

JOIN

107
Q

Select the answer that correctly completes the sentence.

[Answer choice] is a process to reduce duplicate data in a database and ensure data integrity.

A

Normalization

108
Q

This is a process to reduce data duplication. This can be done by separating entities into their own tables and establishing relationships between the tables.

A

Normalization

109
Q

Nmae 2

Which two DML statements are used to modify the existing data in a table? Each correct answer presents a complete solution.

A

MERGE
UPDATE

110
Q

In a relational database, what can you use to create a virtual table from the results of a SELECT statement?

A

a view

111
Q

This defines SQL statements that can be run on command.

A

A stored procedure

112
Q

Which service is managed and serverless, avoids the use of Windows Server licenses, and allows for each workload to have its own instance of the service being used?

A

Azure SQL Database

113
Q

This is a PaaS service, but databases are maintained in the same SQL Managed Instance cluster

A

SQL Managed Instance

114
Q

Which data service provides a fully managed relational database with close to 100 percent feature parity with Microsoft SQL Server?

A

Azure SQL Managed Instance

115
Q

Which three open-source databases are available as platform as a service (PaaS) in Azure? Each correct answer presents a complete solution.

A

MariaDB
MySQL
PostgreSQL

116
Q

Name 2

What open source DB can you use on a virtual machine.

A

CockroachDB and CouchDB

117
Q

Which data service allows you to create a single database that can scale up and down without downtime?

A

SQL Azure SQL Database

118
Q

Which data service allows you to migrate an entire Microsoft SQL Server to the cloud without requiring that you manage the infrastructure after the migration?

A

Azure SQL Managed Instance

119
Q

Uptime of Azure SQL Database

A

99.995%

120
Q

Uptime of Azure SQL Managed Instance

A

99.99%

121
Q

Uptime of SQL Server on Azure VMs

A

99.99%

122
Q

This approach is suitable for migrations and applications requiring access to operating system features that might be unsupported at the PaaS level.

A

SQL Server on Azure Virtual Machines

123
Q

This approach is suitable for if you want to lift-and-shift an on-premises SQL Server instance and all its databases to the cloud, without incurring the management overhead of running SQL Server on a virtual machine

A

Azure SQL Database Managed Instance

124
Q

This PaaS offering allows the creation of a managed database server in the cloud, and then deploy your databases on this server. Available as a Single Database or an Elastic Pool.

A

Azure SQL Database

125
Q

Which data service allows you to migrate an entire Microsoft SQL Server to the cloud without requiring that you manage the infrastructure after the migration?

A

Azure SQL Managed Instance

126
Q

Which open-source database is a hybrid relational-object database?

A

PostgreSQL

127
Q

You can store data in relational tables, or you can store custom data types with non-relational properties.

A

PostgreSQL

128
Q

Which open-source database has built-in support for temporal data?

A

MariaDB

129
Q

Open source relational database offering database management system for web applications, running under Linux

A

MySQL

130
Q

Open source relational database offering offers compatibility with Oracle and support for temporal data

A

MariaDB

131
Q

Which type of Azure Storage is the least expensive option that allows you to store new or modified image files?

A

block blobs in the Archive tier

132
Q

Open source relational database offering hybrid relational-object database.

A

PostgreSQL

133
Q

Open source relational database offering enables you to store custom data types, with their own non-relational properties.

A

PostgreSQL

134
Q

Open source relational database offering the ability to store and manipulate geometric data, such as lines, circles, and polygons.

A

PostgreSQL

135
Q

This blob are best used to store discrete, large, binary objects that change infrequently.

A

block blob

136
Q

This blob is used to implement virtual disk storage for virtual machines.

A

page blobs

137
Q

This blobs can only add blocks to the end of an append blob; updating or deleting existing blocks isn’t supported.

A

Append blobs

138
Q

Which type of Azure Storage is used to store large amounts of files to be shared with virtual machines by using SMB?

A

Azure Files

139
Q

Which two storage solutions can be mounted in Azure Synapse Analytics and used to process large volumes of data? Each correct answer presents a complete solution.

A

Azure Blob storage
Azure Data Lake Storage

140
Q

Which type of blob should you use to store data blocks that are added to a file frequently but cannot be deleted?

A

append

141
Q

This blob allows you to frequently add new data to a file, but it does not allow for the modification or deletion of existing data.

A

append blob

142
Q

You need to replace an existing on-premises SMB shared folder with a cloud solution.

Which storage option should you choose?

A

Azure Files

143
Q

Which Azure Cosmos DB API should you use for data in a column-family storage structure?

A

Apache Cassandra

144
Q

API stores data in the Binary JSON (BSON) format

A

MongoDB

145
Q

Which Azure Cosmos DB API should you use for data in key/value tables?

A

Table

146
Q

You need to process many JSON files every minute, while keeping the data from the files accessible by using native queries.

Which Azure Cosmos DB API should you use?

A

NoSQL

147
Q

Which Azure Cosmos DB API is queried by using a syntax based on SQL?

A

Apache Cassandra

148
Q

Which Azure Cosmos DB API is queried by using MQL?

A

The MongoDB API

149
Q

Which Azure Cosmos DB API is queried by using Graph

A

Gremlin API

150
Q

Which Azure Cosmos DB API is queried by using OData and LINQ

A

The Table API

151
Q

Which storage solution allows you to aggregate data stored in JSON files for use in analytical reports without additional development effort?

A

Azure Cosmos DB

152
Q

What should you use to create and run data ingestion pipelines?

A

Azure Data Factory

153
Q

Which type of data store uses star schemas, fact tables, and dimension tables?

A

data warehouse

154
Q

Which two services allow you to create a pipeline to process data in response to an event? Each correct answer presents a complete solution.

A

Azure Data Factory
Azure Synapse Analytics

155
Q

Which two services allow you to pre-process a large volume of data by using Scala? Each correct answer presents a complete solution.

A

a serverless Apache Spark pool in Azure Synapse Analytics
Azure Databricks

156
Q

Latency is measured in seconds or milliseconds. is a characteristic of ?

A

stream processing

157
Q

processing is fast. It processes data as it arrives.
executes simple analytics or simply writes data to a sink. handles small chunks of data are characteristics of what

A

Stream processing

158
Q

Complex analysis can be performed. is a characteristic of ?

A

batch processing

159
Q

execute complex analysis. handles a large amount of data at a time. is usually measured in minutes and hours are characteristics of what

A

Batch processing

160
Q

Which two services can be used as a source for stream processing? Each correct answer presents a complete solution.

A

Azure Event Hubs
Azure IoT Hub

161
Q

In a stream processing architecture, what can you use to persist the processed results as files?

A

Azure Data Lake Storage Gen2

162
Q

blank is a data ingestion service

A

Event Hubs

163
Q

Which service allows you to perform on-demand analysis of large volumes of data from text logs, websites and IoT devices by using a common querying language for all the data sources?

A

Azure Data Explorer

164
Q

Blank is used for the analysis of large amounts of text log data, websites, and IoT devices and uses a common querying language.

A

Data Explorer

165
Q

Blank is used to define streaming jobs, apply a perpetual query, and write the results to an output.

A

Azure Stream Analytics

166
Q

Which type of visual in Microsoft Power BI should you use to identify the correlation between two numeric measures?

A

scatter plots

167
Q

Which type of visual in Microsoft Power BI should you use to compare categorized values as the proportions of a total value?

A

pie chart

168
Q

Which visual in Microsoft Power BI allows you to view trends, such as changes in sales over time?

A

a line chart

169
Q

In the Power BI service, what should you create to share a single page with the most important visuals from reports?

A

a dashboard

170
Q

You need to share a report that you created in Microsoft Power BI Desktop with other users.

What should you do first?

A

Publish the report to the Power BI service.

171
Q

Blank charts are a good way to visually compare numeric values for discrete categories.

A

Bar and column

172
Q

Blank can also be used to compare categorized values and are useful when you need to examine trends, often over time.

A

Line charts

173
Q

Blank are often used in business reports to visually compare categorized values as proportions of a total.

A

Pie charts

174
Q

Blank are useful when you want to compare two numeric measures and identify a relationship or correlation between them.

A

Scatter plots

175
Q

this sql cmd is used to filter content from a GROUP BY command

A

HAVING

176
Q

this sql cmd displays the content of two sets of columns from two tables but is not based on a shared key

A

UNION

177
Q

this sql cmd shows only values that exist in both tables.

A

INTERSECT

178
Q

Use this to encapsulate any type of business logic that can be reused in the application and modify existing data as well as add new entries to tables.

A

A stored procedure

179
Q

A common format for semi-structured data

A

JSON

180
Q

blank data has some structure but allows for variations between entity instances.

A

Semi-structured

181
Q

Which two types of file store data in columnar format? Each correct answer presents a complete solution.

A

Parquet
ORC

182
Q

Which Azure Cosmos DB API should you use for data in the BSON format?

A

Mongo

183
Q

Which service allows you to aggregate data over a specific time window before the data is written to a data lake?

A

Azure Stream Analytics

184
Q

Which two visuals in Microsoft Power BI allow you to visually compare numeric values for discrete categories? Each correct answer presents a complete solution.

A

a bar chart
a column chart

185
Q

You have an Azure Cosmos DB service running the SQL API. One of the operational databases has a lot of transactions.

Which service allows you to perform near real-time analytics on the operational data stored in Azure Cosmos DB?

A

Azure Synapse

186
Q

Which type of visual in Microsoft Power BI should you use to display a single value, such total sales?

A

Card

187
Q

This data format adheres to a fixed schema, data is represented in one or more tables that consist of rows to represent each instance of a data entity, and columns to represent attributes of the entity

A

Structured data

188
Q

This data format allows for some variation between entity instances.

One common format for semi-structured data is JavaScript Object Notation (JSON).

A

Semi-structured data

189
Q

This data format may be comprised of documents, images, audio and video data, and binary files might

A

unstructured data.

190
Q

What are the two types of datastores

A

File stores
Databases

191
Q

Common file formats for data storage?

A

Delimited text files, JSON, XML, BLOB

192
Q

Some common optimized file formats

A

Avro, ORC, and Parquet

193
Q

This is a row-based optimized file format

A

Avro

194
Q

These are 2 column-based optimized file formats

A

ORC, Parquet

195
Q

Types of databases

A

relational, Non-relational databases

196
Q

Four common types of Non-relational database commonly in use

A

Key-value databases, Document databases, Column family databases, Graph databases

197
Q

This data workload relies on a database system in which data storage is optimized for both read and write operations,

A

transactional data processing (OLTP)

198
Q

This data workload typically uses read-only (or read-mostly) systems that store vast volumes of historical data or business metrics.

A

Analytical data processing (OLAP)

199
Q

These are three examples of data analytic workloads

A

Data lakes, Data warehouses, lakehouse

200
Q

This data workload model is an aggregated type of data storage Data aggregations are across dimensions at different levels, enabling you to drill up/down to view aggregations at multiple hierarchical levels;

A

OLAP model

201
Q

This data workload model stores data in a relational schema that is optimized for read operations

A

Data warehouses

202
Q

This data workload model combines the flexible and scalable storage of a data lake with the relational querying semantics of a data warehouse.

A

Data Lakehouses

203
Q

This data workload model are common in large-scale data analytical processing scenarios, where a large volume of file-based data must be collected and analyzed

A

Datalake

204
Q

This type of database don’t apply a relational schema to the data.

A

non-relational

205
Q

How is data in a relational table organized?

A

Rows and Columns

206
Q

Which of the following is an example of unstructured data?

A

Audio and Video files

207
Q

What is a data warehouse?

A

A relational database optimized for read operations

208
Q

A SQL engine that is optimized for Internet-of-things (IoT) scenarios that need to work with streaming time-series data.

A

Azure SQL Edge

209
Q

Three opensource relational database management systems that are tailored for different specializations.

A

MySQL, MariaDB, and PostgreSQL

210
Q

A fully managed, highly scalable PaaS database service. A good option when you need to create a new application in the cloud.

A

Azure SQL Database

211
Q

A platform-as-a-service (PaaS) option that provides near-100% compatibility with on-premises SQL Server instances while abstracting the underlying hardware and operating system. The service includes automated software update management, backups, and other maintenance tasks, reducing the administrative burden of supporting a database server instance.

A

Azure SQL Managed Instance

212
Q

an infrastructure-as-a-service (IaaS) solution that virtualizes hardware infrastructure for compute, storage, and networking in Azure; making it a great option for “lift and shift” migration of existing on-premises SQL Server installations to the cloud.

A

SQL Server on Azure Virtual Machines (VMs)

213
Q

The best option for low cost with minimal administration. It isn’t fully compatible with on-premises SQL Server installations. It’s often used in new cloud projects where the application design can accommodate any required changes to your applications.

A

Azure SQL Database

214
Q

Which deployment option offers the best compatibility when migrating an existing SQL Server on-premises solution?

A

Azure SQL Managed Instance

Azure SQL Managed Instance offers near 100% compatibility with SQL Servr

215
Q

Which database service is the simplest option for migrating a LAMP application to Azure?

A

Azure Database for MySQL

Correct. LAMP standard for Linux, Apache, MySQL, and PHP.

216
Q

Storage options for non-relational data

A

Blob Storage, Azure DataLake Storage Gen2,Azure Files, Azure Tables

217
Q

What is a Azure Table Storage is a NoSQL storage solution that makes use of tables containing key/value data items, semi-structured data and is comprised of a partition and a row key

A

Azure Table Storage

218
Q

Storage solution that uses SMB and NFS protocols

A

Azure Files

219
Q

hierarchical data storage for analytical data lakes and can be mounted by Hadoop in Azure HDInsight, Azure Databricks, and Azure Synapse Analytics

A

Azure DataLake Storage Gen2

220
Q

What are the elements of an Azure Table storage key?

A

Partition key and row key

221
Q

What should you do to an existing Azure Storage account in order to support a data lake for Azure Synapse Analytics?

A

Upgrade the account to enable hierarchical namespace and create a blob container

222
Q

Why might you use Azure File storage?

A

To enable users at different sites to share files.

223
Q

Microsoft’s native non-relational service for working with the document data model. It manages data in JSON document format, and despite being a NoSQL data storage solution, uses SQL syntax to work with the data.

A

Azure Cosmos DB for NoSQL

224
Q

is a popular open source database in which data is stored in Binary JSON (BSON) format

A

Azure Cosmos DB for MongoDB

225
Q

This is a globally distributed relational database that automatically shards data to help you build highly scalable apps. seamlessly scale to multiple nodes by transparently distributing your tables.

A

Azure Cosmos DB for PostgreSQL

226
Q

To create an Azure Data Lake Store Gen2 files system, you must enable the?

A

Hierarchical Namespace

227
Q

In this azure service All rows in a table must have a unique key (composed of a partition key and a row key)

A

Azure tables

228
Q

What are the elements of an Azure Table storage key?

A

Partition key and row key

229
Q

What should you do to an existing Azure Storage account in order to support a data lake for Azure Synapse Analytics?

A

Upgrade the account to enable hierarchical namespace and create a blob container

230
Q

Why might you use Azure File storage?

A

To enable users at different sites to share files.

231
Q

Cosmos DB use cases

A

IoT and telematics
Retail and marketing
Gaming
Web and mobile applications.

232
Q

Which API should you use to store and query JSON documents in Azure Cosmos DB?

A
233
Q

Which Azure Cosmos DB API should you use to work with data in which entities and their relationships to one another are represented in a graph using vertices and edges?

A

Azure Cosmos DB for Apache Gremlin

234
Q

How can you enable globally distributed users to work with their own local replica of a Cosmos DB database?

A

Enable multi-region writes and add the regions where you have users.

235
Q

You can create pipelines with these azure services

A

Azure Data Factory, Azure Synapse Analytics,Microsoft Fabric

236
Q
A
237
Q

There are two common types of analytical data store

A

Data warehouses,Data lakehouses

238
Q

On Azure, there are three main platform-as-a-service (PaaS) services that you can use to implement a large-scale analytical store

A

Azure Synapse Analytics

239
Q

is a great choice when you want to create a single, unified analytics solution on Azure.

A

Synapse Analytics

240
Q

as your analytical store if you want to use existing expertise with the platform or if you need to operate in a multicloud environment or support a cloud-portable solutionAzure Databricks is an Azu

A

Azure Databricks

241
Q

suitable option if your analytics solution relies on multiple open-source frameworks or if you need to migrate an existing on-premises Hadoop-based solution to the cloud.

A

HDI INsight

242
Q

is a unified software-as-a-service (SaaS) offering, with all your data stored in a single open format in OneLake.

A

Fabric

243
Q

Which Azure PaaS services can you use to create a pipeline for data ingestion and processing?

A

Azure Synapse Analytics and Azure Data Factory

244
Q

What must you define to implement a pipeline that reads data from Azure Blob Storage?

A

A linked service for your Azure Blob Storage account

245
Q

Which open-source distributed processing engine does Azure Synapse Analytics include?

A

Apache Spark

246
Q

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 are advantages of?

A

Batch processing

247
Q

The time delay between ingesting the data and getting the results.
All of a batch job’s input data must be ready before a batch can be processed. This means data must be carefully checked. Problems with data, errors, and program crashes that occur during batch jobs bring the whole process to a halt. The input data must be carefully checked before the job can be run again. Even minor data errors can prevent a batch job from running. are advantages of?

A

Batch processing

248
Q

is ideal for time-critical operations that require an instant real-time response. For example, a system that monitors a building for smoke and heat needs to trigger alarms and unlock doors to allow residents to escape immediately in the event of a fire.

A

Stream processing

249
Q

,Batch processing can process all the data in the dataset. Batch processing is suitable for handling large datasets efficiently, typically a few hours. You typically use batch processing to perform complex analytics.
.

A
250
Q

typically only has access to the most recent data received, or within a rolling time window (the last 30 seconds, for example), is intended for individual records or micro batches consisting of few records, typically occurs immediately, with latency in the order of seconds or milliseconds, is used for simple response functions, aggregates, or calculations such as rolling averages

A

Stream processing

251
Q

Azure Event Hubs:,Azure IoT Hub,Azure Data Lake Store Gen 2,Apache Kafka are all sources for

A

Steam processing

252
Q

Azure Event Hubs:
Azure Data Lake Store Gen 2 Azure blob storage:
Azure SQL Database or Azure Synapse Analytics, or Azure Databricks:
Microsoft Power BI:

A

Sinks for Streams

253
Q

Used to queue the processed data for further downstream processing.

A

Azure Event Hubs

254
Q

Used to persist the processed results as a file

A

Azure Data Lake Store Gen 2 or Azure blob storage:

255
Q

Used to persist the processed results in a database table for querying and analysis.

A

Azure SQL Database or Azure Synapse Analytics, or Azure Databricks:

256
Q

Used to generate real time data visualizations in reports and dashboards.

A

Microsoft Power BI:

257
Q

This distributed processing framework for large scale data analytics. You can use in the following services:

Azure Synapse Analytics
Azure Databricks
Azure HDInsight

A

Apache Spark

258
Q

This is an open-source storage layer that adds support for transactional consistency, schema enforcement, and other common data warehousing features to data lake storage.

A

Delta Lake

259
Q

This represent the entities by which you want to aggregate numeric measures

A

Dimension tables

260
Q

are a good way to visually compare numeric values for discrete categories.

A

Bar and column charts

261
Q

can also be used to compare categorized values and are useful when you need to examine trends, often over time.

A

Line charts

262
Q

are often used in business reports to visually compare categorized values as proportions of a total

A

Pie charts

263
Q

are useful when you want to compare two numeric measures and identify a relationship or correlation between them.

A

Scatter plots

264
Q

. Which kind of visualization should you use to analyze pass rates for multiple exams over time?

A

A line chart

265
Q

What should you define in your data model to enable drill-up/down analysis?

A

A hierarchy

266
Q

Which tool should you use to import data from multiple data sources and create a report?

A

Power BI Desktop

Data Fundamentals (1 decks)

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