DSD632 Recap Quiz

Relational Schema refers to the structure of tables and relationships in a database that follows data modeling principles.

• True

• False

CREATE EXTERNAL TABLE AS SELECT (CETAS) is a statement to create an external table from a SELECT query in Azure Synapse Analytics.

• True

• False

The Database Designer is a database in Azure Synapse Analytics where data is stored in files in a data lake, accessible through SQL pools or Spark pools.

• True

• False

SQL statement to create a new database in Azure Synapse Analytics.
(select the correct term)

• Data Ingestion

• CREATE DATABASE

• OPENROWSET function

FORMAT is a function in SQL used to access and process data from external data sources.

• True

• False

What is Data ingestion?

• SQL statement to create a new database in Azure Synapse Analytics.

• Function used to access and process data from external data source

• Process of importing and storing data in a database or data lake

• Character used to quote fields in a text file when querying JSON files

Character used to quote fields in a text file when querying JSON files.

• WITH CLAUSE

• ROWTERMINATOR

• FIELDTERMINATOR

• FIELDQUOTE

Scenarios where serverless SQL pools are commonly used, such as relational data warehousing, enterprise business intelligence, and data exploration.

• External table

• Typical use cases

• Scoped credential

• Serverless sql pool

Relational abstraction over data in external files, created to query external data.

• External Data Source

• Stored Procedure

• User Defined Table

• External Table

Parameter in SQL specifying file path(s) for bulk operations.

• BULK parameter

• Json files

• Format parameter

• External file format