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.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 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; 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...
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...
According to the FBI, what are the six steps of protecting a business from espionage?A . Recognise the (insider or outsider) threat Identify and value trade secrets Implement a proactive plan for protecting trade secrets Secure physical and electronic versions of trade secrets Confine intellectual knowledge to ‘need to know’...
What three questions does a risk assessment attempt to answer?A . What Protocols currently exist? What is the likelihood it would go wrong? What are the consequences? B. What can go wrong? What is the cost associated? What are the consequences? C. What resources are available? What is the likelihood...
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?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):...
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...
