Free SnowPro Advanced: Architect Recertification Exam ARA-R01 Exam Practice Test

Which Snowflake objects can be used in a data share? (Select TWO).

• Standard view
• Secure view
• Stored procedure
• External table
• Stream

What are characteristics of the use of transactions in Snowflake? (Select TWO).

• Explicit transactions can contain DDL, DML, and query statements.
• The autocommit setting can be changed inside a stored procedure.
• A transaction can be started explicitly by executing a begin work statement and end explicitly by executing a commit work statement.
• A transaction can be started explicitly by executing a begin transaction statement and end explicitly by executing an end transaction statement.
• Explicit transactions should contain only DML statements and query statements. All DDL statements implicitly commit active transactions.

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

• ACCOUNTADMIN, SECURITYADMIN
• SYSADMIN, SECURITYADMIN
• ACCOUNTADMIN, USER with PRIVILEGE
• SECURITYADMIN, USER with PRIVILEGE

Data is being imported and stored as JSON in a VARIANT column. Query performance was fine, but most recently, poor query performance has been reported.What could be causing this?

• There were JSON nulls in the recent data imports.
• The order of the keys in the JSON was changed.
• The recent data imports contained fewer fields than usual.
• There were variations in string lengths for the JSON values in the recent data imports.

Which steps are recommended best practices for prioritizing cluster keys in Snowflake? (Choose two.)

• Choose columns that are frequently used in join predicates.
• Choose lower cardinality columns to support clustering keys and cost effectiveness.
• Choose TIMESTAMP columns with nanoseconds for the highest number of unique rows.
• Choose cluster columns that are most actively used in selective filters.
• Choose cluster columns that are actively used in the GROUP BY clauses.

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?

• All rows loaded using a specific COPY statement will have varying timestamps based on when the rows were inserted.
• Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were read from the source.
• Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were created in the source.
• All rows loaded using a specific COPY statement will have the same timestamp value.

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?

• CREATE CLONE TABLE Recover_Data FROM Data AT(OFFSET => -60*5);
• CREATE CLONE Recover_Data FROM Data AT(OFFSET => -60*5);
• CREATE TABLE Recover_Data CLONE Data AT(OFFSET => -60*5);
• CREATE TABLE Recover Data CLONE Data AT(TIME => -60*5);

What Snowflake system functions are used to view and or monitor the clustering metadata for a table? (Select TWO).

• SYSTEMSCLUSTERING
• SYSTEMSTABLE_CLUSTERING
• SYSTEMSCLUSTERING_DEPTH
• SYSTEMSCLUSTERING_RATIO
• SYSTEMSCLUSTERING_INFORMATION

A Developer is having a performance issue with a Snowflake query. The query receives up to 10 different values for one parameter and then performs an aggregation over the majority of a fact table. It thenjoins against a smaller dimension table. This parameter value is selected by the different query users when they execute it during business hours. Both the fact and dimension tables are loaded with new data in an overnight import process.On a Small or Medium-sized virtual warehouse, the query performs slowly. Performance is acceptable on a size Large or bigger warehouse. However, there is no budget to increase costs. The Developerneeds a recommendation that does not increase compute costs to run this query. What should the Architect recommend?

• Create a task that will run the 10 different variations of the query corresponding to the 10 different parameters before the users come in to work. The query results will then be cached and ready to respond quickly when the users re-issue the query.
• Create a task that will run the 10 different variations of the query corresponding to the 10 different parameters before the users come in to work. The task will be scheduled to align with the users' working hours in order to allow the warehouse cache to be used.
• Enable the search optimization service on the table. When the users execute the query, the search optimization service will automatically adjust the query execution plan based on the frequently-used parameters.
• Create a dedicated size Large warehouse for this particular set of queries. Create a new role that has USAGE permission on this warehouse and has the appropriate read permissions over the fact and dimension tables. Have users switch to this role and use this warehouse when they want to access this data.

Which data models can be used when modeling tables in a Snowflake environment? (Select THREE).

• Graph model
• Dimensional/Kimball
• Data lake
• lnmon/3NF
• Bayesian hierarchical model
• Data vault