Azure Data Foundations
Yes
Does Azure Cosmos DB Table API support multiple read replicas?
No
Does Azure Cosmos DB Table Storage support multiple write regions?
Video or Binary files
Examples of unstructured data
in memory, row by row
How do batch workloads process data?
1
How many workspaces can BI Dashboards be associated to?
No
In the Azure Data Lake storage service is there a cost for transactions?
DBMS set of files some other type of fast easily accessible storage
Ingested data can be stored where?
no
Is the Azure Cosmos DB API is configured separately for each database in an Azure Cosmos DB account?
Storage
Non clustered indexes require what?
Data streaming
Processing data as it arrives is called what?
Cosmos DB
Semi-structured data is typically stored in...
Relational databases such as SQL
Structured data is typically stored in...
MySQL Workbench
Tool to assist MySQL administrators
pgAdmin
Tool to assist PostgreSQL administrators
SQL Server Management Studio
Tool to assist SQL DB administrators
Analytical System
Type of data processing system designed to provide a big picture view of the information held in the database. Concerned with capturing raw data and using it to generate insights.
Transactional System
Type of data processing system that is often broken up into smaller parts, requires fast processing, and records transactions such as financial, retails, payments, etc.
Relational Database
Type of database that leverages structured data in tubular format
Blob Storage
Unstructured data is typically stored in...
Azure Storage for backups Azure Event Hubs Azure Active Directory Azure Key Vault
What 4 additional Azure services are needed to run an Azure SQL Managed instance?
Gremlin
What API would you use if you plan to store data as a graph?
Cassandra
What API would you use if you plan to store data as a wide-column?
MongoDB API
What Azure Cosmos DB API is most appropriate for JSON documents?
Azure SQL Database serverless
What Azure SQL database offering that supports automatic database scaling and automatic pausing of the database during inactive periods?
Azure Database Migration Service (DMS)
What Azure service enables you to restore a backup of your on-premise databases directly to databases running in Azure Data Services and allows you to enable replication from and on-premise database?
Azure Data Lake
What Azure storage solution that provides native support for POSIX-compliant access control lists?
Azure SQL Managed Instance
What allows existing SQL Server customers to lift and shift their on-premises applications to the cloud with minimal application and database changes. At the same time, preserving all PaaS capabilities (automatic patching and version updates, automated backups, high availability) that drastically reduce management overhead and TCO
Mapping data flows
What allows you to create and manage graphs of data transformation logic build-up a reusable library of data transformation routines execute those processes in a scaled-out manner from your ADF pipelines.
Parameters
What are key-value pairs of read-only configuration that are defined in the pipeline?
Linked services
What are much like connection strings, which define the connection information that's needed for Data Factory to connect to external resources?
Facts
What are observations, events, or the subject of an analysis called?
Music, video, or other media files - blob storage Social networking sites, highly complex web of relationships - Graph Database
What are relational databases not ideal for?
Data Bricks Functions Cognitive Services
What are some Azure services to help with data processing?
Create Alter Drop
What are some DML commands?
Schema-less data means inconsistent data Denormalized means redundant data Redundant data means inaccuracies and conflicts
What are some NoSQL database limitations?
MongoDB Redis Hbase
What are some NoSQL database solutions?
Data is stored before transformed More suitable for constructing complex models Iterative approach, often using periodic batch processing Suitable for the cloud Use Azure Data Factory to create and schedule data driven workflows
What are some characteristics of ELT data processing?
Raw data is retrieved and transformed before being saved Suitable for systems that require simple models Stream oriented approach - focus is on throughput Better suited to assist with privacy and compliance by removing sensitive data before it arrives in the analytical model Performed as a continuous pipeline of operations SSIS (SQL Server Integration Service) can be used
What are some characteristics of ETL data processing?
Time delay between ingesting the data and getting the results Minor data error can affect the whole batch
What are some disadvantages of batch processing?
No delay between event and result
What are some stream processing advantages?
Can only process small volume of data, at real time Have to process at real time
What are some stream processing disadvantages?
IoT - store information quickly Retail and Marketing - ecommerce Gaming - stats Web and Mobile Applications - modeling social interactions
What are some use cases for non-relational databases?
Databricks SQL Databricks Data Science & Engineering Databricks Machine Learning
What are the 3 Databrick solutions?
Single Database Elastic Pool Managed Instance
What are the 3 deployment options for Azure SQL Database?
Network Security - approved IPs only can access Access Management - RBAC Threat Protection - Monitoring Information Protection - Information Protection/Encryption
What are the 4 layers of defense securing your Azure SQL server and associated data?
Document Graph Key-Value Wide-Colum
What are the 4 types of NoSQL databases
Pipelines Activities Datasets Linked Services Data Flows Integration Runtimes
What are the 6 components of a Data Factory?
Data sources Azure Data Factory - Ingest Azure Data Lake - Store Azure SQL Data Warehouse (Polybase) - Explore Azure Data Bricks - Explore, Prep & Train Azure SQL Data Warehouse - Model & Serve Power BI - Visualization
What are the 7 components of a modern Data Warehouse architecture?
SELECT - retrieve data from the a database. INSERT - insert data into a table. UPDATE - updates existing data within a table. DELETE - deletes all records from a table, the space for the records remain. MERGE - UPSERT operation (insert or update) CALL - call a PL/SQL or Java subprogram
What are the DML commands?
Large volumes of data can be process at a convenient time Utilize system resource by running at the idle time
What are the 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.
What are the advantages of batch processing?
Highly Availability Scalable Secure data, at both at rest and in transit Automated backups Monitoring Enterprise level security and compliance
What are the benefits for Azure Database for MySQL
Consistency - maintains data consistency across applications and database queries Commitment and Atomicity - handles business rules and policies at a very granular level with strict policies Locking and Concurrency - prevents other users and applications from accessing data while being updated
What are the benefits of a relational database?
Best for analysis of information in a database for the purpose of making management decisions Big picture view of the information held in the database Generate insights to make business decisions
What are the characteristics of a OLAP data processing system?
Best for day-to-day handling of transactions that result from enterprise operation Small, discrete, unit of work Often high-volume Data processed very quickly
What are the characteristics of a OLTP data processing system?
Buffering and processing the data in groups Example - credit card bill
What are the characteristics of batch processing of data?
Data is processed in real time Ideal for time-critical operations that require an instant real-time response Example - stock market, heat alarm system, YouTube, Netflix
What are the characteristics of streaming processing of data?
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, such as typographical errors in dates, can prevent a batch job from running.
What are the disadvantages of batch processing?
Pipelines Activities Datasets Linked Services Data Flows Integration Runtimes
What are the key 6 components of the Data Factory Service
All data is tabular. Entities are modeled as tables, each instance of an entity is a row in the table, and each property is defined as a column. All rows in the same table have the same set of columns. A table can contain any number of rows. A primary key uniquely identifies each row in a table. No two rows can share the same primary key. A foreign key references rows in another, related table. For each value in the foreign key column, there should be a row with the same value in the corresponding primary key column in the other table.
What are the main characteristics of a relational database?
ADS can run on Linux and macOS while SSMS is only Windows ADS allows for notebooks and the writing of scripts
What are the major differences between Azure Data Studio and SSMS?
Azure SQL Database is optimized for OLTP/CRUD, Symmetric Multi Processing (vertical scale) Azure SQL Data Warehouse is optimized for OLAP/querying and reporting, Massively Parallel Processing (horizontal scaling), ability to pause cluster node.
What are the major differences between Azure SQL Database and Azure SQL Data Warehouse?
Big Data and real-time web applications Where relationships b/w data is not important When data changes frequently
What are the most common use cases for NoSQL databases?
IP Firewall rules Virtual Network Firewall rules
What are the networking components to SQL server security?
First normal form - Eliminate repeating groups in individual tables. 2nd normal form - Create a separate table for each set of related data. 3rd normal form- Identify each set of related data with a primary key.
What are the normal form rules?
Azure SQL Database MySQL MariaDB PostgreSQL
What are the relational data services available in Azure?
Database Administrator Data engineers Data Analysts
What are the roles in the world of data?
Normal Forms
What are the rules for database nomalization called?
Azure Portal SQL Server Management Studio Azure Data Studio Sqlcmd utility Visual Studio Code
What are the tools available to query database data in Azure?
Azure Databricks Azure HD Insights
What are the two Azure services that can provision Spark Clusters?
Azure AD SQL Authentication - using DB username and password
What are the two ways you can authenticate into a database?
Analytical Workloads
What are typically read-only systems that store vast volumes of historical data or business metrics, such as sales performance and inventory levels
Partition Keys
What are used in Azure Cosmos DB to assist with optimizing queries?
Variables
What can be used inside of pipelines to store temporary values and can also be used in conjunction with parameters to enable passing values between pipelines, data flows, and other activities?
Create tables, insert, delete, update rows in tables, and query data
What can you do with SQL?
Parquet
What columnar data format was created by Cloudera and Twitter and contains row groups.
Cosmos DB
What data offering is ideal for non-relational data stores?
Blob
What data offering is ideal for storing binary data like images and videos?
Azure Synapse Analytics formerly Azure Data Warehouse
What data offering is ideal for: Enterprise Data Analytics (OLAP) Provides a set of tools to organize and analyze enterprise data MPP architecture
Azure SQL Server
What data offering is ideal: To perform high-speed OLTP operations Highly normalized data with enforced schemas Requires high integrity and strong consistency Relationships are maintained between data tables
ETL (Extract Transform Load)
What data processing mechanism improves data privacy and compliance while at the same time does not require specialist skills?
ELT (Extract Load and Transform)
What data processing mechanism supports Data Lakes, and is ideal for large volumes of data?
Data Analyst
What data role explores and analyzes data to create visualizations and charts to enable organizations to make informed decisions.
Data Engineer
What data role is vital in working with data, applying data cleaning routines, identifying business rules, and turning data into useful information.
Database Administrator
What data role manages databases, assigning permissions to users, storing backup copies of data and restore data in case of any failures.
Non-relational
What data system allows you store the information for entities in collections or containers rather than relational tables.
Azure SQL Managed Instance
What database option allows you to run a fully controllable instance of SQL Server in the cloud. You can install multiple databases on the same instance. You have complete control over this instance, much as you would for an on-premises server. Included automates backups, software patching, database monitoring, and other general tasks
Elastic Pool
What database option enables multiple databases to share the same resources, such as memory, data storage space, and processing power through multiple-tenancy?
Single Database
What database option option enables you to quickly set up and run a single SQL Server database?
Linked Service
What defines the connection to a data source?
Clustered Index
What defines the order in which data is physically stored in a table? Or when we sort a table by a specific column.
To enable the hierarchical namespace
What do you need to configure in an Azure Storage account to support both security at a folder level and atomic directory manipulation?
Atomicity Consistency Isolation Durability
What does ACID stand for?
"Database Transaction Unit" and it describes a performance unit metric for the Azure SQL Database
What does DTU stand for?
Data Warehouse Unit
What does DWU stand for?
Extract Load and Transform
What does ELT stand for?
Extract Transform and Load
What does ETL stand for?
Massive Parallel Processing
What does MPP stand for?
Structured Query Language
What does SQL mean?
CPU + Memory + IO
What does a DWU consist of?
Non Clustered Index
What doesn't sort the physical data inside the table?
Consistency
What ensures that a transaction can only take the data in the database from one valid state to another and never lose or create data in a manner that can't be accounted for.
Isolation
What ensures that concurrent execution of transactions leaves the database in the same state that would have been obtained if the transactions were executed sequentially.
Atomicity
What guarantees that each transaction is treated as a single unit, which either succeeds completely, or fails completely?
Durability
What 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.
Database Management System (DBMS)
What handles the physical aspects of a database, such as where and how it's stored, who can access it, and how to ensure that it's available when required?
Primary Key
What indicates the column (or combination of columns) that uniquely identify each row?
Star Schema
What is a Data Mart design patter consisting of fact and dimension tables resembling a star like shape
Visual Studio Code
What is a Microsoft SQL Server extension that supports connections to SQL Server and provides a rich editing experience for T-SQL?
Azure Table Storage
What is a NoSQL key-value storage service in Azure?
Azure Cosmos DB supports a multi-master model
What is a benefit of the Azure Cosmos DB Table API when compared to Azure Table storage?
Stored Procedure
What is a block of code that runs inside your database?
Azure HD Insight
What is a cloud distribution of Hadoop components that makes it easy, fast, and cost-effective to process massive amounts of data?
Data Factory
What is a cloud-based data integration service that allows you to create data-driven workflows for orchestrating data movement and transforming data at scale?
Azure SQL Database - Elastic Pool
What is a collection of single databases with a shared set of resources, such as CPU or memory?
Linked server
What is a connection from one database server to another?
Primary Key
What is a constraint that is used to enforce data integrity in relational databases by indicating which column (or combination of columns) uniquely identifies each row in a table. It must have a unique value across a table?
Azure Data Studio
What is a cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux. ... It's engineered with the data platform user in mind, with the built-in charting of query result sets and customizable dashboards?
Azure Data Studio
What is a cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux?
Data Bricks
What is a data analytics platform optimized for the Microsoft Azure cloud services platform
Clustered Index
What is a data structure associated with a table that defines the order in which rows are stored on a disk?
Microsoft SQL Server Data Tools
What is a development tool for building Azure SQL Databases, Microsoft SQL Server relational databases, SQL Server Analysis services data models, SQL Server Integration Services packages and SQL Server Reporting Services reports?
PostgreSQL
What is a hybrid relational-object database that enables you to store custom data types, with their own non-relational properties. The database management system is extensible; you can add code modules to the database, which can be run by queries. Another key feature is the ability to store and manipulate geometric data, such as lines, circles, and polygons.
PostgreSQL
What is a hybrid-relational object database that enables you to: store custom data types, with their own non-relational properties Add code modules Manipulate geometric data such as lines circles and polygons
Costs for compute and storage are separate
What is a key benefit of the modern data warehouse solution leveraging Azure Data Lake storage?
Azure Data Studio
What is a lightweight editor that can run on-demand SQL queries and view and save results as text, JSON or Microsoft Excel files?
Pipeline
What is a logical grouping of activities that performs a unit of work?
Pipeline
What is a logical grouping of activities that together perform a task?
Apache Spark
What is a parallel processing framework that supports in-memory processing to boost the performance of big-data analytic applications?
an Activity
What is a processing step within an Azure Data Factory pipeline?
Avro
What is a row-based semi-structured data format created by Apache?
Transaction
What is a sequence of operations that are atomic. This means that either all operations in the sequence must be completed successfully, or if something goes wrong, all operations run so far in the sequence must be undone.
Transact-SQL
What is a set of programming extensions from Microsoft that adds several features to the Structured Query Language (SQL), including transaction control, exception and error handling, row processing, and declared variables.
SQL Server Management Studio
What is a software application first launched with Microsoft SQL Server 2005 that is used for configuring, managing, and administering all components within Microsoft SQL Server.
Visual Studio Code
What is a streamlined code editor with support for development operations like debugging, task running, and version control and aims to provide just the tools a developer needs for a quick code-build-debug cycle?
View
What is a virtual table based on the result set of a query?
a View within your DBMS
What is a virtual table?
MySQL Workbench
What is a visual database design tool that integrates SQL development, administration, database design, creation and maintenance into a single integrated development environment for the MySQL database system.
Azure Synapse Analytics
What is a workspace from where you can access all data warehouse core services seamlessly without network or security issues?
Pipeline run
What is an instance of the pipeline execution?
SQL Server Management Studio (SSMS)
What is an integrated environment for managing any SQL infrastructure. Use it to access, configure, manage, administer, and develop all components of SQL Server, Azure SQL Database, and Azure Synapse Analytics
MySQL
What is an open-source database management system that can be used for LAMP stacks and has several editions like Community, Standard, and Enterprise?
Control Flow
What is an orchestration of pipeline activities that includes chaining activities in a sequence, branching, defining parameters at the pipeline level, and passing arguments while invoking the pipeline on-demand or from a trigger. It also includes custom-state passing and looping containers, that is, For-each iterators
Data Analytics
What is concerned with examining, transforming, and arranging data so that you can study it and extract useful information?
Data Analytics
What is concerned with taking data and finding meaningful information and inferences from it?
Un-structured data
What is data that does not naturally contain fields?
Entity
What is described as a thing about which information needs to be known or held?
Azure Table Storage
What is ideal for storing structured, non-relational data?
Data processing
What is it called when data, taking in its raw format, is cleansed and converted into a more meaningful format (tables, graphs, documents, etc.)
Azure Data Factory
What is like SSIS but for the cloud?
Normalization
What is the act of splitting tables into separate groups of columns.
DDL (Data Definition Language) is used to Specify the database schema database structure. On the other hand, DML (Data Manipulation Language) is used to access, modify or retrieve the data from the database
What is the basic difference between DDL and DML?
Dimensions
What is the context of an analysis, that would "describe" the thing being modeled called
Data Processing
What is the conversion of raw data to meaningful information through a process.
Gremlin API in Azure Cosmos DB
What is the graph database service in Azure?
Data Visualization
What is the graphical representation of information and data?
Azure SQL Managed Instance
What is the intelligent, scalable cloud database service that combines the broadest SQL Server database engine compatibility with all the benefits of a fully managed and evergreen platform as a service?
MySQL
What is the leading open source relational database for (LAMP) stack apps?
Create Read Update Delete
What is the meaning of CRUD
Wrangling
What is the process by which you transform and map raw data into a more useful format for analysis? It can involve writing code to capture, filter, clean, combine, and aggregate data from many sources.
Data Ingestion
What is the process of obtaining and importing data for immediate use or storage in a database?
Data Ingestion
What is the process of obtaining and importing data?
Normalization
What is the process of organizing data in a database. This includes creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency.
Reporting
What is the process of organizing data into informational summaries to monitor how different areas of an organization are performing?
Normalization
What is the process that is used to split an entity into multiple tables?
Data Processing
What is the process to take data in its raw form, cleans it, and converts it into a more meaningful format (tables, graphs, documents, and so on).
PL/SQL
What is the query language that supports Oracle?
TSQL
What is the query language that supports SQL Server?
Key-value store
What is the simplest (and often quickest) type of NoSQL database for inserting and querying data?
OLTP (Online Transactional Processing)
What is the work performed by transactional systems often referred to as?
Structured Data
What is tubular data that is represented by rows and columns in a database
RBAC
What is used for Authorization to a database?
Advanced Threat Protection
What is used to analyze your SQL Server Logs to detect unusual behavior and harmful attempts?
Vulnerability Assessment
What is used to discover, track, and remediate potential database vulnerabilities?
TLS - Transport Layer Security
What is used to encrypt data in transit for SQL database?
Data Discovery & Classification
What is used to identify and label sensitive data for monitoring and alerting?
Transparent Data Encryption (TDE)
What is used to protect SQL server data at rest from offline access to raw files or backups Leverages AES algorithm (Advanced Encryption Standard) for encryption and Azure Key Vault to store keys
Dynamic Data Masking
What is used to protect sensitive SQL server data by masking it from non-privileged users?
SQL auditing in Azure Monitor logs and Event Hubs
What is used to track database activities and help maintain compliance with security standards?
Graph Database
What non-relational database type enables you to not only store entities but the primary focus is on the relationships that these entities have with each other.
Column Family Database
What non-relational database type organizes data into rows and columns?
MariaDB
What open source DBMS was created by the original developers of MySQL but optimized for performance and have built in support for temporal data?
Single Database Elastic Pool Managed Instance
What options are available with Azure SQL Database?
Clustered Index
What physically reorganizes a table by the index key?
Locks
What prevents another process from reading the data until a transaction is committed or rolled back
ACID
What properties must a transactional database adhere to?
SQL Server Management Studio
What provides a graphical interface, enabling you to query data, perform general database administration tasks, and generate scripts for automating database maintenance and support operations.
Azure Data Studio
What provides a graphical user interface for managing many different database systems. It currently provides connections to on-premises SQL Server databases, Azure SQL Database, PostgreSQL, Azure SQL Data Warehouse, and SQL Server Big Data Clusters, amongst others.
Foreign Key
What references, or links to, the primary key of another table, and are used to maintain the relationships between tables.
Business Intelligence
What refers to technologies, applications, and practices for the collection, integration, analysis, and presentation of business information?
Azure SQL Server - Virtual Machines
What relational data offering allows you to install a specific version of SQL server and allows for operating system level access?
Azure SQL Server - Managed Instance
What relational data offering has the most PaaS benefits and is highly compatibly with on-premise instance so is best for lift and shift scenarios?
Azure SQL Server - Single Instance
What relational data offering is an up to date relational database service but not fully compatible with on-premise instance?
Azure SQL Database - Single Instance
What represents a fully managed, isolated database? You might use this option if you have modern cloud applications and microservices that need a single reliable data source.
Activity
What represents a processing step in a pipeline?
Datasets
What represents data structures within the data stores, which simply point to or reference the data you want to use in your activities as inputs or outputs?
Dataset
What represents the structure of the data?
Trigger
What represents the unit of processing that determines when a pipeline execution needs to be kicked off?
ORC (Optimized Row Columnar Format)
What semi-structured data format organizes data into columns rather than rows and was developed by HortonWorks for optimizing read and write operations in Apache Hive.
Massive Parallel Processing (MPP) Architecture
What type of architecture does the Azure Synapse Analytics Service run on?
Cognitive Analytics
What type of data analytics attempts to draw inferences from existing data and patterns, derive conclusions based on existing knowledge bases, and then add these findings back into the knowledge base for future inferences--a self-learning feedback loop?
Prescriptive Analytics
What type of data analytics helps answer questions about what actions should be taken to achieve a goal or target?
Descriptive Analytics
What type of data analytics helps answer questions about what has happened, based on historical data?
Predictive Analytics
What type of data analytics helps answer questions about what will happen in the future?
Diagnostic Analytics
What type of data analytics helps answer questions about why things happened?
Semi-structured
What type of data contains fields but the fields don't have to be the same in every entity?
Semi-structured data
What type of data doesn't reside in a relational database but that still has some structure to it like JSON, key-value stores and graph databases
Stream
What type of data processing is designed for real-time or near real-time data processing, often as a data load process with minimal processing.
Document
What type of data store is needed if you are designing an application that will write a high volume of JSON data and will have an application - defined schema?
NoSQL
What type of database generally falls into four categories: key-value stores, document databases, column family databases, and graph databases?
Relational database
What type of database is best for OLTP applications?
Document Database
What type of database represents the opposite end of the NoSQL spectrum from a key-value store where as each document has a unique ID, but the fields in the documents are transparent to the database management system.
Distributed Database
What type of database stores its data across different physical locations?
Batch
What type of processing is collected over time, often from different data sources, and it is processed as a dataset that includes a range of rows or all rows in the dataset
Sqlcmd
What utility in SQL Server is a command-line tool that lets you submit T-SQL statements or batches to local and remote instances of SQL Server
Most scenarios where new, dynamic data is generated on a continual basis like financial institutions, gaming, real estate, etc. Time-critical operations that require an instant real-time response
When is streaming data processing beneficial or ideal?
The server admin login account of the logical server
When you initially create an Azure SQL Database, which of the following can always be used to connect to the database?
An integration runtime
Which Azure Data Factory component provides the compute environment for activities?
Azure Data Lake
Which storage solution supports role-based access control (RBAC) at the file and folder level?
Yes
Will you incur cost for bandwidth when data is ingested from Azure Data Lake Storage across Azure regions?
Yes
With Azure Synapse does compute and storage scale independently?
throughput the partition key
You have an Azure Cosmos DB account of the Core SQL API. What are 2 settings that can be configured at the container level?
Data ingestion Data transformation Data querying Data visualization
4 core Tasks of an Analytical Data Processing System
Un-structured
A Data lake is for what type of data?
Structured
A Data warehouse is for what type of data?
Workspace
A Power BI dashboard is associated with a singe?
The account level
At what level is the Cosmos DB API configured at?
Account
At which level in Azure Cosmos DB can you configure multiple write regions and read regions?
Database Container
At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution?
99.99% availability
Azure Data Services carry what SLA?
Azure Synapse
Azure SQL Data Warehouse is now call what?
Batch processing
Buffering data and processing it in groups is called what?
Yes
Can Azure Data Factory execute other pipelines?
No
Can items contained in the same Azure Cosmos DB logical partition have different partition keys?
No
Can you restore a SQL managed instance to a SQL server in a VM?