Snowflake SnowPro Advanced Architect Certification - ARA-C01 Exam Practice Test

The following statements have been executed successfully:
USE ROLE SYSADMIN;
CREATE OR REPLACE DATABASE DEV_TEST_DB;
CREATE OR REPLACE SCHEMA DEV_TEST_DB.SCHTEST WITH MANAGED ACCESS;
GRANT USAGE ON DATABASE DEV_TEST_DB TO ROLE DEV_PROJ_OWN;
GRANT USAGE ON SCHEMA DEV_TEST_DB.SCHTEST TO ROLE DEV_PROJ_OWN;
GRANT USAGE ON DATABASE DEV_TEST_DB TO ROLE ANALYST_PROJ;
GRANT USAGE ON SCHEMA DEV_TEST_DB.SCHTEST TO ROLE ANALYST_PROJ;
GRANT CREATE TABLE ON SCHEMA DEV_TEST_DB.SCHTEST TO ROLE DEV_PROJ_OWN;
USE ROLE DEV_PROJ_OWN;
CREATE OR REPLACE TABLE DEV_TEST_DB.SCHTEST.CURRENCY (
COUNTRY VARCHAR(255),
CURRENCY_NAME VARCHAR(255),
ISO_CURRENCY_CODE VARCHAR(15),
CURRENCY_CD NUMBER(38,0),
MINOR_UNIT VARCHAR(255),
WITHDRAWAL_DATE VARCHAR(255)
);
The role hierarchy is as follows (simplified from the diagram):
* ACCOUNTADMIN## DEV_SYSADMIN## DEV_PROJ_OWN## ANALYST_PROJ
Separately:
* ACCOUNTADMIN## SYSADMIN## MAPPING_ROLE
Which statements will return the records from the table
DEV_TEST_DB.SCHTEST.CURRENCY? (Select TWO)

A group of marketing and advertising companies want to share data with one another for joint analysis while maintaining strict privacy controls.
How should an Architect design the data sharing solution?

User1 and User2 are new users that were granted different functional roles.
User1 was granted the IT_ANALYST_ROLE
User2 was granted the FIN_ANALYST_ROLE
Review the following security design (as shown in the diagram):

A database (DB) grants USAGE and SELECT on all tables to DB_IT_RO_ROLE
DB_IT_RO_ROLE is granted to IT_ANALYST_ROLE
IT_SCHEMA contains TABLE1
FINANCE_SCHEMA grants USAGE and SELECT to DB_FIN_ROLE
DB_FIN_ROLE is granted to FIN_ANALYST_ROLE
FINANCE_SCHEMA contains FIN_TABLE
Which tables can each user read?

A company is storing large numbers of small JSON files (ranging from 1-4 bytes) that are received from IoT devices and sent to a cloud provider. In any given hour, 100,000 files are added to the cloud provider.
What is the MOST cost-effective way to bring this data into a Snowflake table?

What are characteristics of Dynamic Data Masking? (Select TWO).

A company is designing its serving layer for data that is in cloud storage. Multiple terabytes of the data will be used for reporting. Some data does not have a clear use case but could be useful for experimental analysis.
This experimentation data changes frequently and is sometimes wiped out and replaced completely in a few days.
The company wants to centralize access control, provide a single point of connection for the end-users, and maintain data governance.
What solution meets these requirements while MINIMIZING costs, administrative effort, and development overhead?

Which requirements indicate that a multi-account Snowflake strategy should be used? (Select TWO).

When activating Tri-Secret Secure in a hierarchical encryption model in a Snowflake account, at what level is the customer-managed key used?

A company wants to Integrate its main enterprise identity provider with federated authentication with Snowflake.
The authentication integration has been configured and roles have been created in Snowflake. However, the users are not automatically appearing in Snowflake when created and their group membership is not reflected in their assigned rotes.
How can the missing functionality be enabled with the LEAST amount of operational overhead?

An Architect is troubleshooting a long-running statement and needs to identify blocked transactions and the queries blocking them.
Which views should be used? (Select TWO).

An Architect needs to design a solution for building environments for development, test, and pre-production, all located in a single Snowflake account. The environments should be based on production data.
Which solution would be MOST cost-effective and performant?

Which of the following are characteristics of Snowflake's parameter hierarchy?

How can the Snowpipe REST API be used to keep a log of data load history?