Snowflake ARA-R01 actual dump : SnowPro Advanced: Architect Recertification Exam

Based on the Snowflake object hierarchy, what securable objects belong directly to a Snowflake account?
(Select THREE).

• A. Table
• B. Database
• C. Stage
• D. Role
• E. Schema
• F. Warehouse

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

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

A Snowflake Architect Is working with Data Modelers and Table Designers to draft an ELT framework specifically for data loading using Snowpipe. The Table Designers will add a timestamp column that Inserts the current tlmestamp as the default value as records are loaded into a table. The Intent is to capture the time when each record gets loaded into the table; however, when tested the timestamps are earlier than the loae_take column values returned by the copy_history function or the Copy_HISTORY view (Account Usage).
Why Is this occurring?

• A. The timestamps are different because there are parameter setup mismatches. The parameters need to be realigned
• B. The Table Designer team has not used the localtimestamp or systimestamp functions in the Snowflake copy statement.
• C. The CURRENT_TIMEis evaluated when the load operation is compiled in cloud services rather than when the record is inserted into the table.
• D. The Snowflake timezone parameter Is different from the cloud provider's parameters causing the mismatch.

An Architect needs to allow a user to create a database from an inbound share.
To meet this requirement, the user's role must have which privileges? (Choose two.)

• A. IMPORT DATABASE;
• B. IMPORT PRIVILEGES;
• C. CREATE DATABASE;
• D. IMPORT SHARE;
• E. CREATE SHARE;

Two queries are run on the customer_address table:
create or replace TABLE CUSTOMER_ADDRESS ( CA_ADDRESS_SK NUMBER(38,0),
CA_ADDRESS_ID VARCHAR(16), CA_STREET_NUMBER VARCHAR(IO) CA_STREET_NAME
VARCHAR(60), CA_STREET_TYPE VARCHAR(15), CA_SUITE_NUMBER VARCHAR(10), CA_CITY VARCHAR(60), CA_COUNTY VARCHAR(30), CA_STATE VARCHAR(2), CA_ZIP VARCHAR(10), CA_COUNTRY VARCHAR(20), CA_GMT_OFFSET NUMBER(5,2), CA_LOCATION_TYPE VARCHAR(20) ); ALTER TABLE DEMO_DB.DEMO_SCH.CUSTOMER_ADDRESS ADD SEARCH OPTIMIZATION ON SUBSTRING(CA_ADDRESS_ID); Which queries will benefit from the use of the search optimization service? (Select TWO).

• A. select * from DEMO_DB.DEMO_SCH.CUSTOMER_ADDRESS Where CA_ADDRESS_ID= substring('AAAAAAAAPHPPLBAAASKDJHASLKDJHASKJD',1,16);
• B. select * from DEMO_DB.DEMO_SCH.CUSTOMER_ADDRESS Where
  substring(CA_ADDRESS_ID,1,8)=
  substring('AAAAAAAAPHPPLBAAASKDJHASLKDJHASKJD',1,8);
• C. select*fromDEMO_DB.DEMO_SCH.CUSTOMER_ADDRESSWhereCA_ADDRESS_IDLIKE
  '%BAAASKD%';
• D. select*fromDEMO_DB.DEMO_SCH.CUSTOMER_ADDRESSWhereCA_ADDRESS_IDNOT LIKE
  '%AAAAAAAAPHPPL%';
• E. select*fromDEMO_DB.DEMO_SCH.CUSTOMER_ADDRESSWhereCA_ADDRESS_IDLIKE
  '%PHPP%';