- All Exams Instant Download
Which of the following are characteristics of Snowflake’s parameter hierarchy?
Which of the following are characteristics of Snowflake’s parameter hierarchy?A . Session parameters override virtual warehouse parameters.B . Virtual warehouse parameters override user parameters.C . Table parameters override virtual warehouse parameters.D . Schema parameters override account parameters.View AnswerAnswer: B Explanation: In Snowflake's parameter hierarchy, virtual warehouse parameters take precedence over...
What are purposes for creating a storage integration? (Choose three.)
What are purposes for creating a storage integration? (Choose three.)A . Control access to Snowflake data using a master encryption key that is maintained in the cloud provider’s key management service.B . Store a generated identity and access management (IAM) entity for an external cloud provider regardless of the cloud...
Which organization-related tasks can be performed by the ORGADMIN role? (Choose three.)
Which organization-related tasks can be performed by the ORGADMIN role? (Choose three.)A . Changing the name of the organizationB . Creating an accountC . Viewing a list of organization accountsD . Changing the name of an accountE . Deleting an accountF . Enabling the replication of a databaseView AnswerAnswer: B,...
Which approach will meet these requirements if Role-Based Access Policies (RBAC) is a viable option for isolating tenants?
A Snowflake Architect is designing an application and tenancy strategy for an organization where strong legal isolation rules as well as multi-tenancy are requirements. Which approach will meet these requirements if Role-Based Access Policies (RBAC) is a viable option for isolating tenants?A . Create accounts for each tenant in the...
At which object type level can the APPLY MASKING POLICY, APPLY ROW ACCESS POLICY and APPLY SESSION POLICY privileges be granted?
At which object type level can the APPLY MASKING POLICY, APPLY ROW ACCESS POLICY and APPLY SESSION POLICY privileges be granted?A . GlobalB . DatabaseC . SchemaD . TableView AnswerAnswer: A Explanation: The object type level at which the APPLY MASKING POLICY, APPLY ROW ACCESS POLICY and APPLY SESSION POLICY...
Which of the following is recommended for optimizing the cost associated with the Snowflake Kafka connector?
An Architect is designing a pipeline to stream event data into Snowflake using the Snowflake Kafka connector. The Architect’s highest priority is to configure the connector to stream data in the MOST cost-effective manner. Which of the following is recommended for optimizing the cost associated with the Snowflake Kafka connector?A...
3) Sales team members who require engineered and protected data for data monetization What Snowflake data modeling approaches will meet these requirements?
The Data Engineering team at a large manufacturing company needs to engineer data coming from many sources to support a wide variety of use cases and data consumer requirements which include: 1) Finance and Vendor Management team members who require reporting and visualization 2) Data Science team members who require...
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...
