ARA-C01 Free Practice Test

Is it possible for a data provider account with a Snowflake Business Critical edition to share data with an Enterprise edition data consumer account?

1. A. A Business Critical account cannot be a data sharing provider to an Enterprise consume
2. B. Any consumer accounts must also be Business Critical.
3. C. If a user in the provider account with role authority to create or alter share adds an Enterprise account as a consumer, it can import the share.
4. D. If a user in the provider account with a share owning role sets share_restrictions to False when adding an Enterprise consumer account, it can import the share.
5. E. If a user in the provider account with a share owning role which also has override share restrictions privilege share_restrictions set to False when adding an Enterprise consumer account, it can import the share.

Correct Answer: B
In Snowflake, data sharing capabilities allow a Business Critical edition account to share data with an Enterprise edition consumer account. The ability to share data is contingent upon the role permissions within the provider account. If a user has the necessary role authority (like ACCOUNTADMIN or a role with similar privileges to create or manage shares), they can add an Enterprise edition account as a consumer. This feature enables flexibility in data sharing across different Snowflake account editions, facilitating broader data collaboration and accessibility.References: Snowflake's data sharing documentation and the specifics of edition-based capabilities discussed in SnowPro Advanced: Architect certification materials.

A retailer's enterprise data organization is exploring the use of Data Vault 2.0 to model its data lake solution. A Snowflake Architect has been asked to provide recommendations for using Data Vault 2.0 on Snowflake.
What should the Architect tell the data organization? (Select TWO).

1. A. Change data capture can be performed using the Data Vault 2.0 HASH_DIFF concept.
2. B. Change data capture can be performed using the Data Vault 2.0 HASH_DELTA concept.
3. C. Using the multi-table insert feature in Snowflake, multiple Point-in-Time (PIT) tables can be loaded in parallel from a single join query from the data vault.
4. D. Using the multi-table insert feature, multiple Point-in-Time (PIT) tables can be loaded sequentially from a single join query from the data vault.
5. E. There are performance challenges when using Snowflake to load multiple Point-in-Time(PIT) tables in parallel from a single join query from the data vault.

Correct Answer: AC
Data Vault 2.0 on Snowflake supports the HASH_DIFF concept for change data capture, which is a method to detect changes in the data by comparing the hash values of the records. Additionally, Snowflake??s multi-table insert feature allows for the loading of multiple PIT tables in parallel from a single join query, which can significantly streamline the data loading process and improve performance1.
References =
•Snowflake??s documentation on multi-table inserts1
•Blog post on optimizing Data Vault architecture on Snowflake2

A data platform team creates two multi-cluster virtual warehouses with the AUTO_SUSPEND value set to NULL on one. and '0' on the other. What would be the execution behavior of these virtual warehouses?

1. A. Setting a '0' or NULL value means the warehouses will never suspend.
2. B. Setting a '0' or NULL value means the warehouses will suspend immediately.
3. C. Setting a '0' or NULL value means the warehouses will suspend after the default of 600 seconds.
4. D. Setting a '0' value means the warehouses will suspend immediately, and NULL means the warehouses will never suspend.

Correct Answer: D
The AUTO_SUSPEND parameter controls the amount of time, in seconds, of inactivity after which a warehouse is automatically suspended. If the parameter is set to NULL, the warehouse never suspends. If the parameter is set to ??0??, the warehouse suspends immediately after executing a query. Therefore, the execution behavior of the two virtual warehouses will be different depending on the AUTO_SUSPEND value. The warehouse with NULL value will keep running until it is manually suspended or the resource monitor limits are reached. The warehouse with ??0?? value will suspend as soon as it finishes a query and release the compute resources. References:
✑ ALTER WAREHOUSE
✑ Parameters

Which of the below commands will use warehouse credits?

1. A. SHOW TABLES LIKE 'SNOWFL%';
2. B. SELECT MAX(FLAKE_ID) FROM SNOWFLAKE;
3. C. SELECT COUNT(*) FROM SNOWFLAKE;
4. D. SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY FLAKE_ID;

Correct Answer: BCD
✑ Warehouse credits are used to pay for the processing time used by each virtual warehouse in Snowflake. A virtual warehouse is a cluster of compute resources that enables executing queries, loading data, and performing other DML operations. Warehouse credits are charged based on the number of virtual warehouses you use, how long they run, and their size1.
✑ Among the commands listed in the question, the following ones will use warehouse credits:
✑ The command that will not use warehouse credits is:
References: : Understanding Compute Cost : MAX Function : COUNT Function : GROUP BY Clause : SHOW TABLES

A user can change object parameters using which of the following roles?

1. A. ACCOUNTADMIN, SECURITYADMIN
2. B. SYSADMIN, SECURITYADMIN
3. C. ACCOUNTADMIN, USER with PRIVILEGE
4. D. SECURITYADMIN, USER with PRIVILEGE

Correct Answer: C
According to the Snowflake documentation, object parameters are parameters that can be set on individual objects such as databases, schemas, tables, and stages. Object parameters can be set by users with the appropriate privileges on the objects. For example, to set the object parameter AUTO_REFRESH on a table, the user must have the MODIFY privilege on the table. The ACCOUNTADMIN role has the highest level of privileges on all objects in the account, so it can set any object parameter on any
object. However, other roles, such as SECURITYADMIN or SYSADMIN, do not have the same level of privileges on all objects, so they cannot set object parameters on objects they do not own or have the required privileges on. Therefore, the correct answer is C. ACCOUNTADMIN, USER with PRIVILEGE.
References:
✑ Parameters | Snowflake Documentation
✑ Object Parameters | Snowflake Documentation
✑ Object Privileges | Snowflake Documentation