Free SNOWPRO-ADVANCED-ARCHITECT Snowflake SNOWPRO-ADVANCED-ARCHITECT Practice Test Question - Page 4

Question 10 (Topic 1)

Assuming all Snowflake accounts are using an Enterprise edition or higher, in which development and testing scenarios would copying of data be required, and zero-copy cloning not be suitable? (Choose two.)

Select an option, then click Submit answer.

○ Developers create their own datasets to work against transformed versions of the live data.
○ Production and development run in different databases in the same account, and Developers need to see production-like data but with specific columns masked.
○ Data is in a production Snowflake account that needs to be provided to Developers in a separate development/testing Snowflake account in the same cloud region.
○ Developers create their own copies of a standard test database previously created for them in the development account, for their initial development and unit testing.
○ The release process requires pre-production testing of changes with data of production scale and complexity. For security reasons, pre-production also runs in the production account.

Reference / correct answer:

Production and development run in different databases in the same account, and Developers need to see production-like data but with specific columns masked.

Most accepted answer: B. Production and development run in different databases in the same account, and Developers need to see production-like data but with specific columns masked.

Community votes: B=1, C=1

Selected Answer: BC B: Maksing policy can not be cloned C: Need a share, not a clone upvoted 4 times ywan1600 1 year, 4 months ago B and C look like the best choices. Just a heads-up, though: masking policies can be copied over, or referenced by the clone if they're not already in the cloned database. It seems like we're working on the idea that the production data doesn't have any policies on it. https://docs.snowflake.com/en/user-guide/tag-based-masking-policies#considerations upvoted 1 times ...

B and C look like the best choices. Just a heads-up, though: masking policies can be copied over, or referenced by the clone if they're not already in the cloned database. It seems like we're working on the idea that the production data doesn't have any policies on it. https://docs.snowflake.com/en/user-guide/tag-based-masking-policies#considerations upvoted 1 times

B: Zero-copy cloning in Snowflake allows for efficient creation of clones that share the underlying storage and metadata with the original object. However, if developers need to work with production data that has specific columns masked (potentially using different views or transformations), a direct copy of the data may be necessary to apply these transformations without affecting the original production data. C: When developers require a separate Snowflake account for development and testing purposes, especially in scenarios where they need to work independently and may need to modify the data structure or content significantly, a copy of the production data into the development/testing account ensures isolation and control over their own environment. Zero-copy cloning does not provide this level of isolation between different Snowflake accounts. upvoted 1 times

Question 11 (Topic 1)

An Architect is investigating a performance issue with an existing architecture and found a query where the Query Profile indicates a high number of bytes spilled to remote storage. The query includes a where clause that filters out a high percentage of records. What actions can be taken to reduce the spillage to remote storage and improve the query performance? (Choose two.)

Select an option, then click Submit answer.

○ Increase the size of the virtual warehouse.
○ Increase the maximum number of clusters for the virtual warehouse.
○ Define a clustering key on columns used for selective filtering with a high clustering depth.
○ Ensure primary keys and foreign keys are defined for large tables referenced by the query.
○ Decrease the data retention period for tables referenced by the query.

Question 12 (Topic 1)

An Architect created a database using the role DB_OWNER and a schema with managed access within this database using the role SCHEMA_OWNER. The team created a table inside this schema using the role OBJECT_OWNER. Which role will be required to grant privileges on the table to other roles?

Select an option, then click Submit answer.

○ DB_OWNER
○ OBJECT_OWNER
○ SECURITYADMIN
○ SYSADMIN

Free SNOWPRO-ADVANCED-ARCHITECT – Snowflake SNOWPRO-ADVANCED-ARCHITECT Practice Test Question