- All Exams Instant Download
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...
What built-in Snowflake features make use of the change tracking metadata for a table? (Choose two.)
What built-in Snowflake features make use of the change tracking metadata for a table? (Choose two.)A . The MERGE commandB . The UPSERT commandC . The CHANGES clauseD . A STREAM objectE . The CHANGE_DATA_CAPTURE commandView AnswerAnswer: C, D Explanation: The built-in Snowflake features that make use of the change...
Which statements describe characteristics of the use of materialized views in Snowflake? (Choose two.)
Which statements describe characteristics of the use of materialized views in Snowflake? (Choose two.)A . They can include ORDER BY clauses.B . They cannot include nested subqueries.C . They can include context functions, such as CURRENT_TIME ().D . They can support MIN and MAX aggregates.E . They can support inner...
Which security, governance, and data protection features require, at a MINIMUM, the Business Critical edition of Snowflake? (Choose two.)
Which security, governance, and data protection features require, at a MINIMUM, the Business Critical edition of Snowflake? (Choose two.)A . Extended Time Travel (up to 90 days)B . Customer-managed encryption keys through Tri-Secret SecureC . Periodic rekeying of encrypted dataD . AWS, Azure, or Google Cloud private connectivity to SnowflakeE...
How can a Snowflake Architect meet this requirement with the LEAST amount of coding?
Files arrive in an external stage every 10 seconds from a proprietary system. The files range in size from 500 K to 3 MB. The data must be accessible by dashboards as soon as it arrives. How can a Snowflake Architect meet this requirement with the LEAST amount of coding?...
How does a standard virtual warehouse policy work in Snowflake?
How does a standard virtual warehouse policy work in Snowflake?A . It conserves credits by keeping running clusters fully loaded rather than starting additional clusters.B . It starts only if the system estimates that there is a query load that will keep the cluster busy for at least 6 minutes.C...
Assuming MY_WH is set to auto_suspend C 60 and used exclusively for this task, which statement is true?
The following DDL command was used to create a task based on a stream: Assuming MY_WH is set to auto_suspend C 60 and used exclusively for this task, which statement is true?A . The warehouse MY_WH will be made active every five minutes to check the stream.B . The warehouse...
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 Snowflake data modeling approach is designed for BI queries?
Which Snowflake data modeling approach is designed for BI queries?A . 3NFB . Star schemaC . Data VaultD . Snowflake schemaView AnswerAnswer: B Explanation: A star schema is a Snowflake data modeling approach that is designed for BI queries. A star schema is a type of dimensional modeling that organizes...
If the user loads this column data into another column that does not have a masking policy, what will occur?
A user has the appropriate privilege to see unmasked data in a column. If the user loads this column data into another column that does not have a masking policy, what will occur?A . Unmasked data will be loaded in the new column.B . Masked data will be loaded into...
