DSD632 Recap Quiz
Authored by Deogratias Phiri
Information Technology (IT)
University
Used 3+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
30 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Relational Schema refers to the structure of tables and relationships in a database that follows data modeling principles.
True
False
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
CREATE EXTERNAL TABLE AS SELECT (CETAS) is a statement to create an external table from a SELECT query in Azure Synapse Analytics.
True
False
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
SQL statement to create a new database in Azure Synapse Analytics.
(select the correct term)
Data Ingestion
CREATE DATABASE
OPENROWSET function
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
FORMAT is a function in SQL used to access and process data from external data sources.
True
False
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Character used to quote fields in a text file when querying JSON files.
WITH CLAUSE
ROWTERMINATOR
FIELDTERMINATOR
FIELDQUOTE
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
