Search optimization service in Snowflake - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a search optimization service in Snowflake.

Snowflake

CREATE SEARCH OPTIMIZATION SERVICE [1] ON TABLE my_database.my_schema.my_table;

Drag options to blanks, or click blank then click option'

Asearch_index

Bmy_search_service

Coptimize_search

Dsearch_service_1

Attempts:

3 left

💡 Hint

Common Mistakes

Using reserved keywords as service names.

Including spaces or special characters in the service name.

The name search_index is a valid and clear identifier for the search optimization service.

2fill in blank

medium

Complete the code to enable automatic maintenance for the search optimization service.

Snowflake

ALTER SEARCH OPTIMIZATION SERVICE search_index SET AUTOMATIC_MAINTENANCE = [1];

Drag options to blanks, or click blank then click option'

A'OFF'

B'ON'

C'TRUE'

D'FALSE'

Attempts:

3 left

💡 Hint

Common Mistakes

Using boolean literals instead of string values.

Setting the value to 'FALSE' or 'OFF' when enabling is required.

Setting AUTOMATIC_MAINTENANCE to 'ON' enables automatic updates for the service.

3fill in blank

hard

Fix the error in the code to drop the search optimization service correctly.

Snowflake

DROP SEARCH OPTIMIZATION SERVICE [1];

Drag options to blanks, or click blank then click option'

Amy_search_service

Bmy_table

Csearch_index

Dmy_database

Attempts:

3 left

💡 Hint

Common Mistakes

Using table or database names instead of the service name.

Misspelling the service name.

The service name search_index must be used to drop the correct search optimization service.

4fill in blank

hard

Fill both blanks to create a search optimization service with a comment.

Snowflake

CREATE SEARCH OPTIMIZATION SERVICE [1] ON TABLE my_db.my_schema.my_table COMMENT = '[2]';

Drag options to blanks, or click blank then click option'

Asearch_index

Bfast_search

CImproves search speed

DOptimizes queries

Attempts:

3 left

💡 Hint

Common Mistakes

Using a comment that is too vague or unrelated.

Choosing a service name that is not descriptive.

The service name search_index and the comment Improves search speed clearly describe the purpose.

5fill in blank

hard

Fill all three blanks to alter the search optimization service to set automatic maintenance and a new comment.

Snowflake

ALTER SEARCH OPTIMIZATION SERVICE [1] SET AUTOMATIC_MAINTENANCE = [2] COMMENT = '[3]';

Drag options to blanks, or click blank then click option'

Asearch_index

B'ON'

CUpdated for better performance

Dfast_search

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect service names.

Using boolean literals instead of string values.

Leaving comments empty or unclear.

The service search_index is updated to enable automatic maintenance with 'ON' and a clear comment.