- All Exams Instant Download
Search optimization does not support Materialized views and External Tables
Search optimization does not support Materialized views and External TablesA . TRUE B. FALSEView AnswerAnswer: A Explanation: Current Limitations of the Search Optimization Service The search optimization service does not support the following:
For the best performance while loading data into table from a stage, you should avoid applying patterns that filter on a large number of files.
For the best performance while loading data into table from a stage, you should avoid applying patterns that filter on a large number of files.A . FALSE B. TRUEView AnswerAnswer: B Explanation: PATTERN = 'regex_pattern' A regular expression pattern string, enclosed in single quotes, specifying the file names and/or paths...
External functions must be scalar functions
External functions must be scalar functionsA . TRUE B. FALSEView AnswerAnswer: A Explanation: Limitations of External Functions External functions have the following limitations: Snowflake calls remote services indirectly through a cloud HTTP proxy service (such as the Amazon AWS API gateway), so the remote service for an external function must...
select metadata$filename, metadata$file_row_number from @filestage/data1.json.gz;
select metadata$filename, metadata$file_row_number from @filestage/data1.json.gz; Please select the correct statements for the above-mentioned query.A . FILESTAGE is the stage name, METADATA$FILE_ROW_NUMBER will give the row number for each record in the container staged data file B. FILESTAGE is the file name, METADATA$FILE_ROW_NUMBER will give the path to the data file...
Why is this error thrown and who can give you the required privilege?
You are creating a TASK to query a table streams created on the raw table and insert subsets of rows into multiple tables. You are following the below steps, but when you reached the step to resume the task, you received an error message as below. Why is this error...
Why is this error thrown and who can give you the required privilege?
You are creating a TASK to query a table streams created on the raw table and insert subsets of rows into multiple tables. You are following the below steps, but when you reached the step to resume the task, you received an error message as below. Why is this error...
When loading data from stage using COPY INTO, what options can you specify for the ON_ERROR clause?
When loading data from stage using COPY INTO, what options can you specify for the ON_ERROR clause?A . CONTINUE B. SKIP_FILE C. ABORT_STATEMENT D. FAILView AnswerAnswer: A,B,C Explanation: Copy Options (copyOptions) You can specify one or more of the following copy options (separated by blank spaces, commas, or new lines):...
What may be the issue?
One of your joins is taking a lot of time. The query profile view looks like this. What may be the issue? A . This may be an "exploding join" issue. The query has provided a condition where records from one table match multiple records from another table resulting in...
When unloading from a snowflake table to an internal or external stage, the COPY INTO command supports which of the below ones?
When unloading from a snowflake table to an internal or external stage, the COPY INTO command supports which of the below ones?A . String truncation B. Reordering columns C. Casts D. Join E. Omission of columnsView AnswerAnswer: A,B,C,D,E Explanation: Unloading operation is more flexible than the load operation. All the...
You can define a clustering key directly on top of VARIANT columns
You can define a clustering key directly on top of VARIANT columnsA . TRUE B. FALSEView AnswerAnswer: B Explanation: You cannot use a VARIANT column in clustering key. However, you can specify an expression to extract value in clustering key.
