SQL

SQL Q & A

When a customer stops using a product or service

What does churn mean?

A left join returns all rows from the left table and matching rows from the right table.

What is the difference between an inner join and left join?

WHERE filters before aggregation. HAVING filters groups after aggregation.

When to use WHERE vs. HAVING?

Summarize data to one value.

What do aggregate functions do?

Metrics that track performance against business goals.

What is a KPI?

The delivery of computing services over the internet

What is cloud computing?

Data Lake Gen 2

Which type of Azure Storage is used to store large amounts of data that must be processed by services such as Azure Databricks, Azure Synapse Analytics, and Azure HDInsight?

SQL Server on Azure VM

Which data service allows you to control the amount of RAM, change the I/O subsystem configuration, and add or remove CPUs?

Archive

The ___ access tier is intended for data that must be retained but not frequently accessed.

Azure Cosmos

Which storage solution should you use to store unstructured documents, graph databases, and key/value pairs?

Unstructured

data contains data such as documents, images, audio data, video data, and binary files.