AI-102 Practice Questions

In SQL, DML (Data Manipulation Language) statements include SELECT , INSERT , UPDATE , and DELETE . Often, you need to filter which rows are affected or returned. That filtering is done with the WHERE clause.

Let’s review the options:

ALTER

Used in Data Definition Language (DDL), not DML.

Alters the structure of a database object (e.g., add/remove columns, modify constraints).

Not used to filter rows.

ON

Used in JOIN operations to specify the relationship between tables.

Does not specify row-level filtering criteria in general DML.

SET

Used in the UPDATE statement to assign new values to columns.

Does not specify which rows to update.

WHERE

Used in DML statements to specify criteria for rows that must match.

Examples:

SELECT * FROM Customers WHERE Country = ' USA ' ;

DELETE FROM Orders WHERE OrderDate < ' 2020-01-01 ' ;

UPDATE Products SET Price = Price * 1.1 WHERE CategoryID = 5;

Thus, the correct clause is WHER

E.  

Correct Answer: WHERE

Microsoft References

SQL WHERE clause

SQL UPDATE with WHERE

SQL DELETE with WHERE

1. Number of Projection Groups

A projection group in a knowledge store is an array of projections ( tables , objects , or files ) that are stored together.

In the provided JSON, the projections array contains the following two top-level sections:

The array of tables :

JSON

" tables " : [

{ ... },

{ ... }

]

The array of objects :

JSON

" objects " : [

{ ... }

]

Each of these top-level arrays ( tables and objects ) represents a distinct projection group in the knowledge store. Therefore, there are two projection groups .

2. Image Saving

The files projection is used to save images, normalized images, or application files generated during the enrichment process.

In the provided JSON, the files array is present but is empty :

JSON

" files " : []

Since there are no file projections defined, the images (or any files) generated during the enrichment process will not be saved to the knowledge store. They are processed in the pipeline but not persisted in the output storage defined by the knowledgeStore configuration.

Scenario: Support autocompletion and autosuggestion based on all product name variants.

A: Call a suggester-enabled query, in the form of a Suggestion request or Autocomplete request, using an API. API usage is illustrated in the following call to the Autocomplete REST API.

POST /indexes/myxboxgames/docs/autocomplete?search & api-version=2020-06-30

{

" search " : " minecraf " ,

" suggesterName " : " sg "

}

B: In Azure Cognitive Search, typeahead or " search-as-you-type " is enabled through a suggester. A suggester provides a list of fields that undergo additional tokenization, generating prefix sequences to support matches on partial terms. For example, a suggester that includes a City field with a value for " Seattle " will have prefix combinations of " sea " , " seat " , " seatt " , and " seattl " to support typeahead.

F.  

Cognitive Insights Widget URL

https: / /www.videoindexer.ai/embed/insights/ {accountId}/{videoId}/ ?w idgets=people,keywords & controls=search

Player Widget URL

https: / /www.videoindexer.ai/embed/player/ {accountId}/{videoId}/ ?s howcaptions= true & captions=en- US

Comprehensive Detailed Explanation

The requirements are:

Ensure that users can search for keywords.

In the Cognitive Insights Widget, the controls parameter can be set to search to allow keyword search.

Display the names and faces of people in the video.

The widgets parameter in the Cognitive Insights Widget determines which insights are shown.

To show people and keywords, use people,keywords .

Show captions in the video in English (United States).

For the Player Widget, captions are controlled by two parameters:

showcaptions=true enables captions.

captions=en-US specifies the language.

Final Placement of Values

Cognitive Insights Widget

widgets=people,keywords

controls=search

Player Widget

showcaptions=true

captions=en-US

Microsoft References

Embed Video Indexer widgets

Video Indexer parameters and customization