Font size
S
M
L
XL
WorksheetsAzure Data Fundamentals
Total questions: 29
Worksheet time: 15mins
Name
Class
Date
1.
Objects in which things about data should be captured and stored are called: ____________.
a)
Tables
b)
Entities
c)
Rows
d)
Columns
2.
You need to process data that is generated continuously and near real-time responses are required. You should use _________.
a)
Batch Processing
b)
Scheduled data processing
c)
buffering and processing
d)
streaming data processing
3.
Extract, Transform, Load (ETL)
a)
Optimize data privacy
b)
Provide support for Azure Data Lake
c)
Manage Large volumes of data
4.
Extract, Load, Transform (ELT)
a)
Optimize data privacy
b)
Provide support for Azure Data Lake
c)
Manage Large volumes of data
5.
The technique that provides recommended actions that you should take to achieve a goal or target is called _____________ analytics
a)
Descriptive
b)
Diagnostic
c)
Predictive
d)
Prescriptive
6.
Tables
a)
Create relationships
b)
Improve processing speed for data searches
c)
store instances of entities as rows
d)
display data from predefined queries
7.
Indexes
a)
Create relationships
b)
Improve processing speed for data searches
c)
store instances of entities as rows
d)
display data from predefined queries
8.
Views
a)
Create relationships
b)
Improve processing speed for data searches
c)
store instances of entities as rows
d)
display data from predefined queries
9.
Keys
a)
Create relationships
b)
Improve processing speed for data searches
c)
store instances of entities as rows
d)
display data from predefined queries
10.
The process of splitting an entity into more than one table to reduce data redundancy is called: _____________.
a)
deduplication
b)
denormalization
c)
normalization
d)
optimization
11.
Azure SQL Database is an example of ________________ -as-a-service
a)
platform
b)
infrastructure
c)
software
d)
application
12.
Azure Data Studio
a)
Query data while working within a Visual Studio project.
b)
Query data located in a non-Microsoft platform.
c)
Query data from within the Azure portal.
13.
Azure Query Editor
a)
Query data while working within a Visual Studio project.
b)
Query data located in a non-Microsoft platform.
c)
Query data from within the Azure portal.
14.
SQL Server Data Tools
a)
Query data while working within a Visual Studio project.
b)
Query data located in a non-Microsoft platform.
c)
Query data from within the Azure portal.
15.
The act of increasing or decreasing the resources that are available for a service is called: _____________.
a)
computing
b)
provisioning
c)
networking
d)
scaling
16.
What does this SQL Clause do? JOIN
a)
Filter records
b)
Combine rows from multiple tables
c)
Calculate the total value of a numeric column
d)
Determine the number of rows retrieved
17.
What does this SQL Clause do? WHERE
a)
Filter records
b)
Combine rows from multiple tables
c)
Calculate the total value of a numeric column
d)
Determine the number of rows retrieved
18.
What does this SQL Clause do? SUM
a)
Filter records
b)
Combine rows from multiple tables
c)
Calculate the total value of a numeric column
d)
Determine the number of rows retrieved
19.
What does this SQL Clause do? COUNT
a)
Filter records
b)
Combine rows from multiple tables
c)
Calculate the total value of a numeric column
d)
Determine the number of rows retrieved
20.
What are 3 characteristics of non-relational data?
a)
Forced schema on data structures
b)
Flexible storage of ingested data
c)
Entities are self-describing
d)
Entities may have different fields
e)
Each row has the exact same columns
21.
You need to store the data in an Azure environment that supports efficient non-key, field-based searching. You should use _______________________ as the data store.
a)
Azure Table Storage
b)
Azure Blob Storage
c)
Azure File Storage
d)
Azure Cosmos DB
22.
You need to create a graph database. Which Azure data service should you use?
a)
Azure Table
b)
Azure Cosmos DB
c)
Azure Blob
d)
Azure File
23.
You use Azure Table Storage as a non-relational data store. You need to optimize data retrieval. You should use ______________________________ as query criteria.
a)
only partition keys
b)
only row keys
c)
partition keys and row keys
d)
only properties
24.
You need to use JavaScript Object Notation (JSON) files to provision Azure storage. What should you use?
a)
Azure portal
b)
Azure command-line interface (CLI)
c)
Azure PowerShell
d)
Azure Resource Manager (ARM) templates
25.
For which reason should you deploy a data warehouse?
a)
Record daily sales transactions.
b)
Perform sales trend analyses.
c)
Print sales orders.
d)
Search status of sales orders.
26.
Which 2 Azure data services support Apache Spark clusters?
a)
Azure Synapse Analytics
b)
Azure Cosmos DB
c)
Azure Databricks
d)
Azure Data Factory
27.
You design a data ingestion and transformation solution by using Azure Data Factory service. You need to get data from an Azure SQL database. Which 2 resources should you use? Each correct answer presents part of the solution.
a)
Linked service
b)
Copy data activity
c)
Dataset
d)
Azure Databricks notebook
28.
Which Azure Data Factory component should you use to represent data that you want to ingest for processing?
a)
Linked services
b)
Datasets
c)
Pipelines
d)
Notebooks
29.
You are designing reports by using Microsoft Power BI. For which 3 scenarios can you create Power BI reports as paginated reports?
a)
a report that has a table visual with an ability to print all the data in the table
b)
a report that has a table visual with an ability to see all the data in the table
c)
a report with a repeatable header and footer
d)
a report that is formatted to fit well on a printed page
e)
a report that uses only Power BI visuals
Reset
