- All Exams Instant Download
Which of the following statements will accommodate this request?
A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH. Which of the following statements will accommodate this request?A . ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;B . GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;C . GRANT MODIFY...
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?A . STATEMENT_TIMEOUT__IN__SECONDSB . STATEMENT_QUEUED_TIMEOUT_IN_SECONDSC . MAX_CONCURRENCY__LEVELD . QUERY_TIMEOUT_IN_SECONDSView AnswerAnswer: B Explanation: The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get...
Will data cached in a warehouse be lost when the warehouse is resized?
Will data cached in a warehouse be lost when the warehouse is resized?A . Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.B . Yes. because the compute resource is replaced in its entirety with a new compute resource.C . No. because the...
What are the default Time Travel and Fail-safe retention periods for transient tables?
What are the default Time Travel and Fail-safe retention periods for transient tables?A . Time Travel - 1 day. Fail-safe - 1 dayB . Time Travel - 0 days. Fail-safe - 1 dayC . Time Travel - 1 day. Fail-safe - 0 daysD . Transient tables are retained in neither...
What happens when a cloned table is replicated to a secondary database? (Select TWO)
What happens when a cloned table is replicated to a secondary database? (Select TWO)A . A read-only copy of the cloned tables is stored.B . The replication will not be successful.C . The physical data is replicatedD . Additional costs for storage are charged to a secondary accountE . Metadata...
How did Snowflake fulfill this query?
A sales table FCT_SALES has 100 million records. The following Query was executed SELECT COUNT (1) FROM FCT__SALES; How did Snowflake fulfill this query?A . Query against the result set cacheB . Query against a virtual warehouse cacheC . Query against the most-recently created micro-partitionD . Query against the metadata...
Which statement about billing applies to Snowflake credits?
Which statement about billing applies to Snowflake credits?A . Credits are billed per-minute with a 60-minute minimumB . Credits are used to pay for cloud data storage usageC . Credits are consumed based on the number of credits billed for each hour that a warehouse runsD . Credits are consumed...
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).A . Load files that are approximately 25 MB or smaller.B . Remove all dates and timestamps.C . Load files that are approximately 100-250 MB (or larger)D . Avoid using embedded characters...
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)A . SCIMB . Federated authenticationC . TLS 1.2D . Key-pair authenticationE . OAuthF . OCSP authenticationView AnswerAnswer: B, D, E Explanation: Snowflake supports several methods for authenticating users, including federated authentication, key-pair authentication, and...
When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?
When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?A . A single join node uses more than 50% of the query timeB . Partitions scanned is equal to partitions totalC . An AggregateOperacor node is presentD . The query...
