A Snowflake Architect is designing a multi-tenant application strategy for an organization in the Snowflake Data Cloud and is considering using an Account Per Tenant strategy. Which requirements will be addressed with this approach? (Choose two.)
Correct Answer: C,D
Question 77
Snowflake has row level security
Correct Answer: A
Question 78
An Architect is troubleshooting a query with poor performance using the QUERY_HIST0RY function. The Architect observes that the COMPILATIONJHME is greater than the EXECUTIONJTIME. What is the reason for this?
Correct Answer: B
Compilation time is the time it takes for the optimizer to create an optimal query plan for the efficient execution of the query. It also involves some pruning of partition files, making the query execution efficient2 If the compilation time is greater than the execution time, it means that the optimizer spent more time analyzing the query than actually running it. This could indicate that the query has overly complex logic, such as multiple joins, subqueries, aggregations, or expressions. The complexity of the query could also affect the size and quality of the query plan, which could impact the performance of the query3 To reduce the compilation time, the Architect can try to simplify the query logic, use views or common table expressions (CTEs) to break down the query into smaller parts, or use hints to guide the optimizer. The Architect can also use the EXPLAIN command to examine the query plan and identify potential bottlenecks or inefficiencies4 Reference: 1: SnowPro Advanced: Architect | Study Guide 5 2: Snowflake Documentation | Query Profile Overview 6 3: Understanding Why Compilation Time in Snowflake Can Be Higher than Execution Time 7 4: Snowflake Documentation | Optimizing Query Performance 8 : SnowPro Advanced: Architect | Study Guide : Query Profile Overview : Understanding Why Compilation Time in Snowflake Can Be Higher than Execution Time : Optimizing Query Performance
Question 79
What considerations need to be taken when using database cloning as a tool for data lifecycle management in a development environment? (Select TWO).
Correct Answer: A,D
Database cloning is a feature of Snowflake that allows creating a copy of a database, schema, table, or view without consuming any additional storage space. Database cloning can be used as a tool for data lifecycle management in a development environment, where developers and testers can work on isolated copies of production data without affecting the original data or each other1. However, there are some considerations that need to be taken when using database cloning in a development environment, such as: * Any pipes in the source are not cloned. Pipes are objects that load data from a stage into a table continuously. Pipes are not cloned because they are associated with a specific stage and table, and cloning them would create duplicate data loading and potential conflicts2. * The clone inherits all granted privileges of all child objects in the source object, including the database. Privileges are the permissions that control the access and actions that can be performed on an object. When a database is cloned, the clone inherits all the privileges that were granted on the source database and its child objects, such as schemas, tables, and views. This means that the same roles that can access and modify the source database can also access and modify the clone, unless the privileges are explicitly revoked or modified3. The other options are not correct because: * B. Any pipes in the source referring to internal stages are not cloned. This is a subset of option A, which states that any pipes in the source are not cloned, regardless of the type of stage they refer to. * C. Any pipes in the source referring to external stages are not cloned. This is also a subset of option A, which states that any pipes in the source are not cloned, regardless of the type of stage they refer to. * E. The clone inherits all granted privileges of all child objects in the source object, excluding the database. This is incorrect, as the clone inherits all granted privileges of the source object, including the database. References: * 1: Database Cloning | Snowflake Documentation * 2: Pipes | Snowflake Documentation * 3: Access Control Privileges | Snowflake Documentation
Question 80
You can define a clustering key directly on top of VARIANT columns
