Things I don't know from practice exams

Azure HDInsight

A fully managed, cloud-based service from Microsoft Azure that allows you to run open-source frameworks like Apache Hadoop, Spark, Hive, Kafka, and more. It’s designed for processing large volumes of data using distributed computing. HDInsight enables big data analytics, real-time processing, and machine learning at scale, all integrated with Azure storage and other services.

Azure Synapse Analytics

A Microsoft Azure service that lets you store, manage, and analyze large amounts of data using SQL or Spark. It combines features of a data warehouse and big data tools in one place, so you can run fast queries, build dashboards, and work with machine learning.

Scala

A high-level programming language that combines object-oriented and functional programming concepts. It was created to address some of the limitations of Java and runs on the Java Virtual Machine (JVM), which means it can use Java libraries and tools.

Apache Kafka

An open-sourced distributed, fault-tolerant, high-throughput, and scalable platform for building real-time data pipelines and streaming applications

SQL SELECT INTO Statement

This (SQL) statement copies data from one table into a new table.

inline function

A type of user-defined function in SQL that returns a table as its result, similar to a view. it cannot modify nor create objects. It can be used to query a database.

SQL Server on an Azure Virtual Machines running Windows

A data service that allows you to use every feature of Microsoft SQL Server in the cloud

Virtual Hard Disk

a file format that functions as a virtualized hard drive, essentially a disk image file. It's commonly used in virtualization to create and manage virtual machines (VMs).

page blob

are optimized for random read and write operations, and used for Virtual Hard Disks

Server Message Block (SMB)

A network protocol used mainly by Windows systems to share files, printers, and other resources over a local network. It allows devices to communicate and access shared services, typically using TCP port 445. Commonly used in enterprise and home networks for file and printer sharing.

Analytical databases

Optimized for read operations and stores large amounts of aggregated data

Highly denormalized to store large amounts of aggregated data and are optimized for reads.

Types of applications that are used in transactional systems

• Line-of-business (LOB) applications: a type of live application that processes business data.

• Live applications: used in transactional data processing systems.