- All Exams Instant Download
A user can change object parameters using which of the following roles?
A user can change object parameters using which of the following roles?A . ACCOUNTADMIN, SECURITYADMINB . SYSADMIN, SECURITYADMINC . ACCOUNTADMIN, USER with PRIVILEGED . SECURITYADMIN, USER with PRIVILEGEView AnswerAnswer: C Explanation: According to the Snowflake documentation, object parameters are parameters that can be set on individual objects such as databases,...
What command will accomplish this?
A company has a table with that has corrupted data, named Data. The company wants to recover the data as it was 5 minutes ago using cloning and Time Travel. What command will accomplish this?A . CREATE CLONE TABLE Recover_Data FROM Data AT(OFFSET => -60*5);B . CREATE CLONE Recover_Data FROM...
When loading data into a table that captures the load time in a column with a default value of either CURRENT_TIME () or CURRENT_TIMESTAMP() what will occur?
When loading data into a table that captures the load time in a column with a default value of either CURRENT_TIME () or CURRENT_TIMESTAMP() what will occur?A . All rows loaded using a specific COPY statement will have varying timestamps based on when the rows were inserted.B . Any rows...
Based on Snowflake recommendations, how should the clustering key columns be ordered while defining the multi-column clustering key?
A table contains five columns and it has millions of records. The cardinality distribution of the columns is shown below: Column C4 and C5 are mostly used by SELECT queries in the GROUP BY and ORDER BY clauses. Whereas columns C1, C2 and C3 are heavily used in filter and...
What are the MINIMUM object privileges required for the Snowpipe user to execute Snowpipe?
A Data Engineer is designing a near real-time ingestion pipeline for a retail company to ingest event logs into Snowflake to derive insights. A Snowflake Architect is asked to define security best practices to configure access control privileges for the data load for auto-ingest to Snowpipe. What are the MINIMUM...
Which feature provides the capability to define an alternate cluster key for a table with an existing cluster key?
Which feature provides the capability to define an alternate cluster key for a table with an existing cluster key?A . External tableB . Materialized viewC . Search optimizationD . Result cacheView AnswerAnswer: B Explanation: A materialized view is a feature that provides the capability to define an alternate cluster key...
How is the change of local time due to daylight savings time handled in Snowflake tasks? (Choose two.)
How is the change of local time due to daylight savings time handled in Snowflake tasks? (Choose two.)A . A task scheduled in a UTC-based schedule will have no issues with the time changes.B . Task schedules can be designed to follow specified or local time zones to accommodate the...
What are some of the characteristics of result set caches? (Choose three.)
What are some of the characteristics of result set caches? (Choose three.)A . Time Travel queries can be executed against the result set cache.B . Snowflake persists the data results for 24 hours.C . Each time persisted results for a query are used, a 24-hour retention period is reset.D ....
What configuration can the company’s Architect implement to enhance the performance of this workload?
A company’s daily Snowflake workload consists of a huge number of concurrent queries triggered between 9pm and 11pm. At the individual level, these queries are smaller statements that get completed within a short time period. What configuration can the company’s Architect implement to enhance the performance of this workload? (Choose...
SQL compilation error: invalid parameter 'validation_mode' Assuming the syntax is correct, what is the cause of this error?
Consider the following COPY command which is loading data with CSV format into a Snowflake table from an internal stage through a data transformation query. This command results in the following error: SQL compilation error: invalid parameter 'validation_mode' Assuming the syntax is correct, what is the cause of this error?A...
