Microsoft Azure Data Fundamentals v1.0
Question 1
You need to create an Azure resource to store data in Azure Table storage.
Which command should you run?
- A. az storage share create
- B. az storage account create
- C. az cosmosdb create
- D. az storage container create
Answer : D
Reference:
https://docs.microsoft.com/en-us/cli/azure/storage/container?view=azure-cli-latest
Question 2
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Answer : 
Azure Cosmos DB SQL API accounts provide support for querying items using the Structured Query Language (SQL) syntax.
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/choose-api
Question 3
You need to modify a view in a relational database by adding a new column.
Which statement should you use?
- A. MERGE
- B. ALTER
- C. INSERT
- D. UPDATE
Answer : B
Question 4
HOTSPOT -
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
Answer : 
Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl
Question 5
HOTSPOT -
You plan to deploy a PostgreSQL database to Azure.
Which hosting model corresponds to the available deployment options? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Answer : 
Reference:
https://azure.microsoft.com/en-us/overview/what-is-saas/
https://azure.microsoft.com/en-us/overview/what-is-paas/
Question 6
Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?
- A. Azure Table storage
- B. Azure Data Lake Storage
- C. Azure Queue storage
- D. Azure Files
Answer : B
Reference:
https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control
Question 7
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Answer : 
Question 8
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Answer : 
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/stored-procedures-database-engine?view=sql-server-ver15
Question 9
DRAG DROP -
Match the types of analytics that can be used to answer the business questions.
To answer, drag the appropriate analytics type from the column on the left to its question on the right. Each analytics type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
Answer : Incorrect Answer:
Box 1: Diagnostic -
Diagnostic Analytics: At this stage you can begin to answer some of those why questions. Historical data can begin to be measured against other data to answer the question of why something happened in the past. This is the process of gathering and interpreting different data sets to identify anomalies, detect patters, and determine relationships.
Box 2: Prescriptive -
Prescriptive analytics is a combination of data, mathematical models, and various business rules to infer actions to influence future desired outcomes.
Predictive analytics, broadly speaking, is a category of business intelligence that uses descriptive and predictive variables from the past to analyze and identify the likelihood of an unknown future outcome
Box 3: Cognitive -
Reference:
https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/ https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/
Question 10
Which type of database is Azure Database for PostgreSQL?
- A. Platform as a service (PaaS)
- B. Infrastructure as a service (IaaS)
- C. Microsoft SQL Server
- D. on-premises
Answer : A
Reference:
https://docs.microsoft.com/en-us/azure/postgresql/overview-postgres-choose-server-options
Question 11
Which storage solution supports access control lists (ACLs) at the file and folder level?
- A. Azure Data Lake Storage
- B. Azure Queue storage
- C. Azure Blob storage
- D. Azure Cosmos DB
Answer : A
Azure Data Lake Storage Gen2 implements an access control model that supports both Azure role-based access control (Azure RBAC) and POSIX-like access control lists (ACLs).
Reference:
https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control
Question 12
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Answer : 
A treemap chart divides the chart area into rectangles that represent the different levels and relative sizes of the data hierarchy.
Reference:
https://docs.microsoft.com/en-us/sql/reporting-services/report-design/tree-map-and-sunburst-charts-in-reporting-services?view=sql-server-ver15
Question 13
What is a characteristic of batch processing?
- A. The data ingested during batch processing must be processed as soon as the data is received.
- B. Large datasets must be split into batches of less than 1 GB before the data can be processed.
- C. There is a noticeable time delay between ingesting data and obtaining the data processing results.
- D. Batch processing can only process data that is structured.
Answer : D
Question 14
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Answer : 
An aggregate function performs a calculation on a set of values, and returns a single value. The following are aggregate functions:
✑ APPROX_COUNT_DISTINCT
✑ AVG
✑ CHECKSUM_AGG
✑ COUNT
✑ COUNT_BIG
GROUPING -
✑ GROUPING_ID
✑ MAX
✑ MIN
✑ STDEV
✑ STDEVP
✑ STRING_AGG
✑ SUM
✑ VAR
✑ VARP
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/functions/aggregate-functions-transact-sql?view=sql-server-ver15
Question 15
HOTSPOT -
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
Answer : 
Box 1: Yes -
Batch processing refers to processing of high volume of data in batch within a specific time span. It processes large volume of data all at once. Batch processing is used when data size is known and finite. It takes little longer time to processes data.
Box 2: Yes -
Stream processing refers to processing of continuous stream of data immediately as it is produced. It analyzes streaming data in real time. Stream processing is used when the data size is unknown and infinite and continuous.
Box 3: No -
Reference:
https://www.geeksforgeeks.org/difference-between-batch-processing-and-stream-processing/