- All Exams Instant Download
Which actions can the company take with the inbound share?
A company has an inbound share set up with eight tables and five secure views. The company plans to make the share part of its production data pipelines. Which actions can the company take with the inbound share? (Choose two.)A . Clone a table from a share.B . Grant modify...
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...
Which is the LEAST complex approach to use to populate the QA account with the Production account’s data and database objects on a nightly basis?
An Architect has chosen to separate their Snowflake Production and QA environments using two separate Snowflake accounts. The QA account is intended to run and test changes on data and database objects before pushing those changes to the Production account. It is a requirement that all database objects and data...
Which Snowflake feature can the Architect use to accomplish this?
An Architect would like to save quarter-end financial results for the previous six years. Which Snowflake feature can the Architect use to accomplish this?A . Search optimization serviceB . Materialized viewC . Time TravelD . Zero-copy cloningE . Secure viewsView AnswerAnswer: D Explanation: Zero-copy cloning is a Snowflake feature that...
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,...
How can an Architect enable optimal clustering to enhance performance for different access paths on a given table?
How can an Architect enable optimal clustering to enhance performance for different access paths on a given table?A . Create multiple clustering keys for a table.B . Create multiple materialized views with different cluster keys.C . Create super projections that will automatically create clustering.D . Create a clustering key that...
What is the best practice recommendation for the order of priority when applications authenticate to Snowflake?
A company’s client application supports multiple authentication methods, and is using Okta. What is the best practice recommendation for the order of priority when applications authenticate to Snowflake?A . 1) OAuth (either Snowflake OAuth or External OAuth) 2) External browser 3) Okta native authentication 4) Key Pair Authentication, mostly used...
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...
Which steps are recommended best practices for prioritizing cluster keys in Snowflake? (Choose two.)
Which steps are recommended best practices for prioritizing cluster keys in Snowflake? (Choose two.)A . Choose columns that are frequently used in join predicates.B . Choose lower cardinality columns to support clustering keys and cost effectiveness.C . Choose TIMESTAMP columns with nanoseconds for the highest number of unique rows.D ....
What is a valid object hierarchy when building a Snowflake environment?
What is a valid object hierarchy when building a Snowflake environment?A . Account --> Database --> Schema --> WarehouseB . Organization --> Account --> Database --> Schema --> StageC . Account --> Schema > Table --> StageD . Organization --> Account --> Stage --> Table --> ViewView AnswerAnswer: B Explanation:...
