- All Exams Instant Download
Who can view account-level Credit and Storage Usage?
Who can view account-level Credit and Storage Usage?A . ACCOUNTADMIN B. A role which has been granted the MONITOR USAGE global privilege C. STORAGEADMIN D. STORAGEMONITORView AnswerAnswer: A,B Explanation: If you have the necessary administrator privileges, you can use the Snowflake web interface to view details about the number of...
What does Percentage scanned from cache in the query profile signify?
What does Percentage scanned from cache in the query profile signify?A . The percentage of data scanned from the local disk cache B. The percentage of data scanned from the METADATA cache C. The percentage of data scanned from the QUERY cacheView AnswerAnswer: A Explanation: Understanding caching in snowflake is...
Your business team runs a set of identical queries every day after the batch ETL run is complete. From the following actions, what is the best action that you will recommend.
Your business team runs a set of identical queries every day after the batch ETL run is complete. From the following actions, what is the best action that you will recommend.A . After the ETL run, execute the identical queries so that they remain in the result cache B. After...
If a multi-cluster warehouse is resized, the new size applies to
If a multi-cluster warehouse is resized, the new size applies toA . Clusters that are currently running B. Clusters that are started after the warehouse is resized C. All of the aboveView AnswerAnswer: C Explanation: Multi-cluster Size and Credit Usage The number of servers in each cluster is determined by...
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...
