- All Exams Instant Download
What may be the cause of this?
One of your query is taking a long time to finish, when you open the query profiler you see that lot of data is spilling to the remote disk(Bytes spilled to remote storage). What may be the cause of this?A . The amount of memory available for the servers used...
JSON and PARQUET files can be loaded to columns in the same table
JSON and PARQUET files can be loaded to columns in the same tableA . TRUE B. FALSEView AnswerAnswer: B Explanation: Let us try to answer some logical questions to arrive at the answer for this question
Materialized views based on external tables can improve query performance
Materialized views based on external tables can improve query performanceA . TRUE B. FALSEView AnswerAnswer: A Explanation: Querying data stored external to the database is likely to be slower than querying native database tables; however, materialized views based on external tables can improve query performance. https://docs.snowflake.com/en/user-guide/tables-external-intro.html
One of your colleagues has submitted a long running query in Snowflake. how long the query can run till snowflake automatically cancels the query?
One of your colleagues has submitted a long running query in Snowflake. how long the query can run till snowflake automatically cancels the query?A . 14 hours B. 2 days C. 2 hours D. 24 hoursView AnswerAnswer: B Explanation: This is actually a dangerous thing to happen in production, hence...
Will the above query cost you any compute credits?
create or replace table result_scan_table as select * from table(result_scan(last_query_id())); Will the above query cost you any compute credits?A . It will not cost any compute credit because this query is a metadata operation B. It will cost compute credit because processing is required to insert the data into result_scan_table...
Which of the below approach results in perfromance improvement through linear scaling of data ingestion workload?
Which of the below approach results in perfromance improvement through linear scaling of data ingestion workload?A . Split large files into recommended range of 10 MB to 100 MB B. Organize data by granular path C. Resize virtual warehouse D. All of the aboveView AnswerAnswer: D Explanation: When loading your...
During a database cloning, if a SNOWPIPE is cloned with a fully qualified table in the COPY statement in the pipe definition (in the form of db_name.schema_name.table_name or schema_name.table_name), then what will happen?
During a database cloning, if a SNOWPIPE is cloned with a fully qualified table in the COPY statement in the pipe definition (in the form of db_name.schema_name.table_name or schema_name.table_name), then what will happen?A . Snowpipe loads duplicate data into the source table B. Data loading will fail when the snowpipe...
Which are those?
Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns. Which are those?A . RECORD_CONTENT B. RECORD_METADATA C. RECORD_MESSAGEView AnswerAnswer: A,B Explanation: Schema of Topics for Kafka Topics Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns:
Which statement is true about clustering key?
Which statement is true about clustering key?A . Clustering key can be one per table but the key can have more than one column B. Clustering key can be many per table and each key can have more than one column C. Clustering key can be many per table but...
Directly querying a file from the stage
Directly querying a file from the stageA . 1,2,3,4 B. 4,3,2,1 C. 1,2,4,3 D. 3,2,4,1View AnswerAnswer: A
