Exam: AI-102: Azure AI Engineer Associate

Review questions, reveal answers, and move through the exam one card at a time.

Total Questions: 336

Questions per page

Page 1 of 1

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
Box 2: No
Box 3: No

Which statement is an example of Data Manipulation Language (DML)?
A. REVOKE
B. DISABLE
C. INSERT
D. GRANT

Answer : C
✅ Explanation:
-Data Manipulation Language (DML) is used to manage data within schema objects. Common DML commands include:
SELECT
INSERT
UPDATE
DELETE
MERGE
-So, INSERT is a DML command because it adds data to a table.
-Here’s what the others represent:
A. REVOKE – A Data Control Language (DCL) command, used to remove permissions.
B. DISABLE – Typically used to disable triggers or constraints, not classified under DML.
D. GRANT – Another DCL command, used to give user access privileges.

DRAG DROP -
Match the types of workloads to the appropriate scenarios.
To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:

Answer :

Box 1: Batch
Box 2: Streaming
Box 3: Batch

DRAG DROP -
Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process.
Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to
drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Answer :

Box 1: The CRM system
Box 2: The data warehouse
Box 3: A standalone data analysis tool

Your company recently reported sales from the third quarter.
You have the chart shown in the following exhibit.

Which type of analysis is shown in the fourth quarter?
A. predictive
B. prescriptive
C. descriptive
D. diagnostic

Answer : A

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
✅ Explanation:
-To use Azure Table storage, you must first create an Azure Storage Account. Table storage is one of the -services under a storage account (along with blob, queue, and file storage).
-Here's what the options do:
A. az storage share create – Used to create an Azure File share, not Table storage.
B. az storage account create – ✅ Correct: This command creates a storage account, which is required before creating or using Table storage.
C. az cosmosdb create – Creates an Azure Cosmos DB account, which can also support table APIs, but it's different from standard Azure Table storage.

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 :
Box 1: Diagnostic
Box 2: Prescriptive
Box 3: Cognitive

HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:

Answer : treemap

HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:

Answer : MAX and MIN

HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:

Answer : graph database

Back Next Question