ExamGecko
Home / Microsoft / AI-102 / List of questions
Ask Question

Microsoft AI-102 Practice Test - Questions Answers, Page 14

List of questions

Question 131

Report
Export
Collapse

HOTSPOT

Select the answer that correctly completes the sentence.

Microsoft AI-102 image Question 131 84052 09262024054204000
Correct answer: Microsoft AI-102 image answer Question 131 84052 09262024054204000
asked 26/09/2024
Janina Loveria
39 questions

Question 132

Report
Export
Collapse

Which statement is an example of Data Manipulation Language (DML)?

Revoke
Revoke
UPDATE
UPDATE
DROP
DROP
CREATE
CREATE
Suggested answer: B
asked 26/09/2024
Johnny Tien
47 questions

Question 133

Report
Export
Collapse

Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use?

SQL Server on Azure Virtual Machines
SQL Server on Azure Virtual Machines
Azure SOL Database
Azure SOL Database
Azure HDInsight
Azure HDInsight
Azure Cosmos DB
Azure Cosmos DB
Suggested answer: B
asked 26/09/2024
JENNIFER MALIWANAG
38 questions

Question 134

Report
Export
Collapse

You have a SQL query that combines customer data and order dat a. The query includes calculated columns. You need to create a database object that would allow other users to rerun the same SOL query. What should you create?

an Index
an Index
a view
a view
a scalar function
a scalar function
a table
a table
Suggested answer: B
asked 26/09/2024
Ben Clark
34 questions

Question 135

Report
Export
Collapse

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection Is worth one point.

reduced administrative effort for managing the server infrastructure
reduced administrative effort for managing the server infrastructure
complete control over backup and restore processes
complete control over backup and restore processes
in-database machine learning services S3
in-database machine learning services S3
access to the latest features
access to the latest features
Suggested answer: A, D
asked 26/09/2024
Fermin Paneque Cabrera
39 questions

Question 136

Report
Export
Collapse

You have data saved in the following format.

Microsoft AI-102 image Question 31 84057 09262024174204000000

Which format was used?

CSV
CSV
JSON
JSON
HTML
HTML
YAML
YAML
Suggested answer: A
asked 26/09/2024
Russo, Anna
25 questions

Question 137

Report
Export
Collapse

What is a primary characteristic of a relational database?

data is queried and manipulated by using a variant of the SOL language
data is queried and manipulated by using a variant of the SOL language
a lack of dependencies between tables
a lack of dependencies between tables
a flexible data structure
a flexible data structure
a large amount of duplicate data
a large amount of duplicate data
Suggested answer: C
asked 26/09/2024
Keenan Bragg
41 questions

Question 138

Report
Export
Collapse

What ate two uses of data visualization? Each correct answer presents a complete solution. NOTE:

Each correct selection is worth one point.

Communicate the significance of data.
Communicate the significance of data.
Represent trends and patterns over time.
Represent trends and patterns over time.
Implement machine learning to predict future values.
Implement machine learning to predict future values.
Enforce business logic across reports.
Enforce business logic across reports.
Suggested answer: A, B
asked 26/09/2024
Henock Asmerom
34 questions

Question 139

Report
Export
Collapse

What should you use to build a Microsoft Power Bi paginated report?

Power BI Report Builder
Power BI Report Builder
Charciculator
Charciculator
Power BI Desktop
Power BI Desktop
the Power BI service
the Power BI service
Suggested answer: A
asked 26/09/2024
P B
41 questions

Question 140

Report
Export
Collapse

Which scenario is an example of a streaming workload?

sending transactions daily from point of sale (POS) devices
sending transactions daily from point of sale (POS) devices
sending cloud infrastructure metadata every 30 minutes
sending cloud infrastructure metadata every 30 minutes
sending transactions that are older than a month to an archive
sending transactions that are older than a month to an archive
sending telemetry data from edge devices
sending telemetry data from edge devices
Suggested answer: D
asked 26/09/2024
Lietuvis Kau
32 questions
Total 323 questions
Go to page: of 33

Related questions