Free ARA-C01 Practice Exam

Get Ready Smarter for the ARA-C01 Exam with Our Free and Accurate ARA-C01 Exam Questions – Updated for 2025.

At Cert Empire, we are dedicated to offering the most up-to-date and reliable exam questions for students preparing for the Snowflake ARA-C01 Exam. To make preparation easier, we’ve made sections of our ARA-C01 exam resources free for everyone. You can practice as much as you like with Free ARA-C01 Practice Test.

Get ARA-C01 Exam Dumps

Snowflake SnowPro Advanced Architect Free Exam Questions

Disclaimer

Please keep a note that the demo questions are not frequently updated. You may as well find them in open communities around the web. However, this demo is only to depict what sort of questions you may find in our original files.

Nonetheless, the premium exam dumps files are frequently updated and are based on the latest exam syllabus and real exam questions.

1 / 60

What is the MOST efficient way to design an environment where data retention is not considered
critical, and customization needs are to be kept to a minimum?

Use a transient schema

Use a transient table

Use a temporary table

Use a transient database

2 / 60

A new user user_01 is created within Snowflake. The following two commands are executed:
Command 1-> show grants to user user_01;
Command 2 ~> show grants on user user 01;
What inferences can be made about these commands?

Command 1 defines all the grants which are given to user_01 Command 2 defines which user owns user_01

Command 1 defines all the grants which are given to user_01 Command 2 defines which role owns user 01

Command 1 defines which role owns user_01 Command 2 defines all the grants which have been given to user_01

Command 1 defines which user owns user_01 Command 2 defines all the grants which have been given to user_01

3 / 60

An Architect is implementing a CI/CD process. When attempting to clone a table from a
production to a development environment, the cloning operation fails.
What could be causing this to happen?

The table is transient

The table has a masking policy

The retention time for the table is set to zero

Tables cannot be cloned from a higher environment to a lower environment

4 / 60

A group of Data Analysts have been granted the role ANALYST_ROLE. They need a Snowflake database where they can create and modify tables, views, and other objects to load with their own data. The Analysts should not have the ability to give other Snowflake users outside of their role access to this data.

How should these requirements be met?

Grant SYSADMIN OWNERSHIP of the database, but grant the create schema privilege on the database to the ANALYST_ROLE

Grant ANALYST_ROLE OWNERSHIP on the database, but grant the OWNERSHIP ON FUTURE [object type]s in database privilege to SYSADMIN

Grant ANALYST_ROLE OWNERSHIP on the database, but make sure that ANALYST_ROLE does not have the MANAGE GRANTS privilege on the account

Make every schema in the database a MANAGED ACCESS schema, owned by SYSADMIN, and grant create privileges on each schema to the ANALYST_ROLE for each type of object that needs to be created

5 / 60

A company’s client application supports multiple authentication methods, and is using Okta.
What is the best practice recommendation for the order of priority when applications authenticate to Snowflake?

1. OAuth (either Snowflake OAuth or External OAuth)2. External browser3. Okta native authentication4. Key Pair Authentication, mostly used for service account users5. Password

1. External browser, SSO2. Key Pair Authentication, mostly used for development environment users3. Okta native authentication4. OAuth (ether Snowflake OAuth or External OAuth)5. Password

1. Okta native authentication2. Key Pair Authentication, mostly used for production environment users3. Password4. OAuth (either Snowflake OAuth or External OAuth)5. External browser, SSO

1. Password2. Key Pair Authentication, mostly used for production environment users3. Okta native authentication4. OAuth (either Snowflake OAuth or External OAuth)5. External browser, SSO

6 / 60

A company is designing high availability and disaster recovery plans and needs to maximize redundancy and minimize recovery time objectives for their critical application processes.

Cost is not a concern as long as the solution is the best available.

The plan so far consists of the following steps:

1. Deployment of Snowflake accounts on two different cloud providers.
2. Selection of cloud provider regions that are geographically far apart.
3. The Snowflake deployment will replicate the databases and account data between both cloud provider accounts.
4. Implementation of Snowflake client redirect.

What is the MOST cost-effective way to provide the HIGHEST uptime and LEAST application disruption if there is a service event?

Connect the applications using the - URL.Use the Enterprise Snowflake edition

Connect the applications using the - URL.Use the Standard Snowflake edition

Connect the applications using the - URL.Use the Business Critical Snowflake edition

Connect the applications using the - URL.Use the Virtual Private Snowflake (VPS) edition

7 / 60

A company has an external vendor who puts data into Google Cloud Storage. The company's Snowflake account is set up in Azure.

What would be the MOST efficient way to load data from the vendor into Snowflake?

Ask the vendor to create a Snowflake account, load the data into Snowflake and create a data share

Create an external stage on Google Cloud Storage and use the external table to load the data into Snowflake

Copy the data from Google Cloud Storage to Azure Blob storage using external tools and load data from Blob storage to Snowflake

Create a Snowflake Account in the Google Cloud Platform (GCP), ingest data into this account and use data replication to move the data from GCP to Azure

8 / 60

What is a characteristic of Role-Based Access Control (RBAC) as used in Snowflake?

Privileges can be granted at the database level and can be inherited by all underlying objects

A user can create managed access schemas to support future grants and ensure only schema owners can grant privileges to other roles

A user can create managed access schemas to support current and future grants and ensure only object owners can grant privileges to other roles

A user can use a "super-user" access along with SECURITYADMIN to bypass authorization checks and access all databases, schemas, and underlying objects

9 / 60

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?

The order of the keys in the JSON was changed

There were JSON nulls in the recent data imports

The recent data imports contained fewer fields than usual

There were variations in string lengths for the JSON values in the recent data imports

10 / 60

A company's Architect needs to find an efficient way to get data from an external partner, who is also a Snowflake user. The current solution is based on daily JSON extracts that are placed on an FTP server and uploaded to Snowflake manually. The files are changed several times each month, and the ingestion process needs to be adapted to accommodate these changes.

What would be the MOST efficient solution?

Ask the partner to create a share and add the company's account

Ask the partner to set up a Snowflake reader account and use that account to get the data for ingestion

Keep the current structure but request that the partner stop changing files, instead only appending new files

Ask the partner to use the data lake export feature and place the data into cloud storage where Snowflake can natively ingest it (schema-on-read)

11 / 60

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

A Business Critical account cannot be a data sharing provider to an Enterprise consumer. Any consumer accounts must also be Business Critical

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

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

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

12 / 60

An Architect is troubleshooting a query with poor performance using the QUERY function. The Architect observes that the COMPILATION_TIME Is greater than the EXECUTION_TIME.

What is the reason for this?

The query Is queued for execution

The query has overly complex logic

The query Is reading from remote storage

The query is processing a very large dataset

13 / 60

A user is executing the following command sequentially within a timeframe of 10 minutes from start to finish:

What would be the output of this query?

Table T_SALES_CLONE successfully created

Syntax error line 1 at position 58 unexpected 'at'

Time Travel data is not available for table T_SALES

The offset -> is not a valid clause in the clone operation

14 / 60

A company is following the Data Mesh principles, including domain separation, and chose one Snowflake account for its data platform.

An Architect created two data domains to produce two data products. The Architect needs a third data domain that will use both of the data products to create an aggregate data product. The read access to the data products will be granted through a separate role.

Based on the Data Mesh principles, how should the third domain be configured to create the aggregate product if it has been granted the two read roles?

Use secondary roles for all users

Create a hierarchy between the two read roles

Request a technical ETL user with the sysadmin role

Request that the two data domains share data using the Data Exchange

15 / 60

An Architect needs to improve the performance of reports that pull data from multiple Snowflake tables, join, and then aggregate the data. Users access the reports using several dashboards. There are performance issues on Monday mornings between 9:00am-11:00am when many users check the sales reports.

The size of the group has increased from 4 to 8 users. Waiting times to refresh the dashboards has increased significantly. Currently this workload is being served by a virtual warehouse with the following parameters:

AUTO-RESUME = TRUE AUTO_SUSPEND = 60 SIZE = Medium

What is the MOST cost-effective way to increase the availability of the reports?

Use materialized views and pre-calculate the data

Increase the warehouse to size Large and set auto_suspend = 600

Use a multi-cluster warehouse in maximized mode with 2 size Medium clusters

Use a multi-cluster warehouse in auto-scale mode with 1 size Medium cluster, and set min_cluster_count = 1 and max_cluster_count = 4

16 / 60

An Architect is designing a solution that will be used to process changed records in an orders table. Newly-inserted orders must be loaded into the f_orders fact table, which will aggregate all the orders by multiple dimensions (time, region, channel, etc.). Existing orders can be updated by the sales department within 30 days after the order creation. In case of an order update, the solution must perform two actions:

1. Update the order in the f_0RDERS fact table.

2. Load the changed order data into the special table ORDER _REPAIRS.

This table is used by the Accounting department once a month. If the order has been changed, the Accounting team needs to know the latest details and perform the necessary actions based on the data in the order_repairs table.

What data processing logic design will be the MOST performant?

Use one stream and one task

Use one stream and two tasks

Use two streams and one task

Use two streams and two tasks

17 / 60

A user has activated primary and secondary roles for a session.

What operation is the user prohibited from using as part of SQL actions in Snowflake using the secondary role?

Insert

Create

Delete

Truncate

18 / 60

A company has a source system that provides JSON records for various loT operations. The JSON Is loading directly into a persistent table with a variant field. The data Is quickly growing to 100s of millions of records and performance to becoming an issue. There is a generic access pattern that Is used to filter on the create_date key within the variant field.

What can be done to improve performance?

Incorporate the use of multiple tables partitioned by date ranges. When a user or process needs to query a particular date range, ensure the appropriate base table Is used

Validate the size of the warehouse being used. If the record count is approaching 100s of millions, size XL will be the minimum size required to process this amount of data

Alter the target table to include additional fields pulled from the JSON records. This would include a create_date field with a datatype of varchar. When this field is used in the filter, partition pruning will occur

Alter the target table to Include additional fields pulled from the JSON records. This would Include a create_date field with a datatype of time stamp. When this field Is used in the filter, partition pruning will occur

19 / 60

A company has built a data pipeline using Snowpipe to ingest files from an Amazon S3 bucket. Snowpipe is configured to load data into staging database tables. Then a task runs to load the data from the staging database tables into the reporting database tables.

The company is satisfied with the availability of the data in the reporting database tables, but the reporting tables are not pruning effectively. Currently, a size 4X-Large virtual warehouse is being used to query all of the tables in the reporting database.

What step can be taken to improve the pruning of the reporting tables?

Increase the size of the virtual warehouse to a size 5X-Large

Use an ORDER BY <cluster_key (s) > command to load the reporting tables

Eliminate the use of Snowpipe and load the files into internal stages using PUT commands

Create larger files for Snowpipe to ingest and ensure the staging frequency does not exceed 1 minute

20 / 60

The data share exists between a data provider account and a data consumer account. Five tables from the provider account are being shared with the consumer account. The consumer role has been granted the imported privileges privilege. What will happen to the consumer account if a new table (table_6) is added to the provider schema?

The consumer role will automatically see the new table and no additional grants are needed

The consumer role will see the table only after this grant is given on the consumer side: grant imported privileges on database PSHARE_EDW_4TEST_DB to DEV_ROLE;

The consumer role will see the table only after this grant is given on the provider side: use role accountadmin; Grant select on table EDW.ACCOUNTING.Table_6 to share PSHARE_EDW_4TEST;

The consumer role will see the table only after this grant is given on the provider side: use role accountadmin; grant usage on database EDW to share PSHARE_EDW_4TEST ; grant usage on schema EDW.ACCOUNTING to share PSHARE_EDW_4TEST ; Grant select on table EDW.ACCOUNTING.Table_6 to database PSHARE_EDW_4TEST_DB ;

21 / 60

Which of the below approach results in perfromance improvement through linear scaling of data ingestion workload?

Resize virtual warehouse

Organize data by granular path

Split large files into recommended range of 10 MB to 100 MB

All of the above

22 / 60

Which command will you run to list all privileges and roles granted to the role?

SHOW GRANTS OF ROLE <ROLE NAME>

SHOW GRANTS ON ROLE <ROLE NAME>

SHOW GRANTS FOR ROLE <ROLE NAME>

SHOW GRANTS TO ROLE <ROLE NAME>

23 / 60

When a database gets cloned, what accesses are replicated?

Only the child object access

Only the data base object access

All objects in the database and their child objects(schemas, tables etc)

No access gets replicated

24 / 60

What is the data size limit for loading into a variant column?

10 MB - 100 MB compressed

16 MB(Compressed)

1 GB(Compressed)

32 GB

25 / 60

One of your colleagues has submitted a long running query in Snowflake. how long the query can run till snowflake automatically cancels the query?

2 hours

14 hours

24 hours

2 days

26 / 60

For which use cases, will you use cross-cloud and cross-region replication?

Data portability and account migrations

Business continuity and disaster recovery

Secure data sharing across regions/cloud

All of these

27 / 60

A Snowflake Architect is designing an application and tenancy strategy for an organization where strong legal isolation rules as well as multi-tenancy are requirements. Which approach will meet these requirements if Role-Based Access Policies (RBAC) is a viable option for isolating tenants?

Create accounts for each tenant in the Snowflake organization

Create a multi-tenant table strategy if row level security is not viable for isolating tenants

Create an object for each tenant strategy if row level security is viable for isolating tenants

Create an object for each tenant strategy if row level security is not viable for isolating tenants

28 / 60

A table contains five columns and it has millions of records. The cardinality distribution of the columns is shown below:

Column C4 and C5 are mostly used by SELECT queries in the GROUP BY and ORDER BY clauses. Whereas columns C1, C2 and C3 are heavily used in filter and join conditions of SELECT queries. The Architect must design a clustering key for this table to improve the query performance.
Based on Snowflake recommendations, how should the clustering key columns be ordered while defining the multi-column clustering key?

C1, C3, C2

C2, C1, C3

C3, C4, C5

C5, C4, C2

29 / 60

When using the Snowflake Connector for Kafka, what data formats are supported for the messages? (Choose two.)

JSON, XML

CSV, Parquet

XML, Avro

Avro, JSON

Parquet, CSV

30 / 60

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?

A pipe

A stream

An external table

A copy command at regular intervals

31 / 60

Consider the following COPY command which is loading data with CSV format into a Snowflake table from an internal stage through a data transformation query.

This command results in the following error:
SQL compilation error: invalid parameter 'validation_mode'
Assuming the syntax is correct, what is the cause of this error?

The VALIDATION_MODE parameter does not support COPY statements with CSV file formats

The value return_all_errors of the option VALIDATION_MODE is causing a compilation error

The VALIDATION_MODE parameter supports COPY statements that load data from external stages only

The VALIDATION_MODE parameter does not support COPY statements that transform data during a load

32 / 60

An Architect runs the following SQL query:

How can this query be interpreted?

FILEROWS is a stage. FILE_ROW_NUMBER is line number in file

FILEROWS is a file. FILE_ROW_NUMBER is the file format location

FILERONS is the file format location. FILE_ROW_NUMBER is a stage

FILEROWS is the table. FILE_ROW_NUMBER is the line number in the table

33 / 60

There are two databases in an account, named fin_db and hr_db which contain payroll and employee data, respectively. Accountants and Analysts in the company require different permissions on the objects in these databases to perform their jobs. Accountants need read-write access to fin_db but only require read-only access to hr_db because the database is maintained by human resources personnel.
An Architect needs to create a read-only role for certain employees working in the human resources department.
Which permission sets must be granted to this role?

USAGE on database hr_db, SELECT on all schemas in database hr_db, SELECT on all tables in database hr_db

USAGE on database hr_db, USAGE on all schemas in database hr_db, SELECT on all tables in database hr_db

USAGE on database hr_db, USAGE on all schemas in database hr_db, REFERENCES on all tables in database hr_db

MODIFY on database hr_db, USAGE on all schemas in database hr_db, USAGE on all tables in database hr_db

34 / 60

An Architect has been asked to clone schema STAGING as it looked one week ago, Tuesday June 1st at 8:00 AM, to recover some objects.
The STAGING schema has 50 days of retention.
The Architect runs the following statement:
CREATE SCHEMA STAGING_CLONE CLONE STAGING at (timestamp => '2021-06-01 08:00:00');
The Architect receives the following error: Time travel data is not available for schema STAGING. The requested time is either beyond the allowed time travel period or before the object creation time.
The Architect then checks the schema history and sees the following:

Undrop the STAGING schema and then rerun the CLONE statement

Modify the statement: CREATE SCHEMA STAGING_CLONE CLONE STAGING at (timestamp => '2021-05-01 10:00:00');

Cloning cannot be accomplished because the STAGING schema version was not active during the proposed Time Travel time period

Rename the STAGING schema and perform an UNDROP to retrieve the previous STAGING schema version, then run the CLONE statement

35 / 60

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

Schema parameters override account parameters

Session parameters override virtual warehouse parameters

Virtual warehouse parameters override user parameters

Table parameters override virtual warehouse parameters

36 / 60

What is a valid object hierarchy when building a Snowflake environment?

Account --> Schema > Table --> Stage

Account --> Database --> Schema --> Warehouse

Organization --> Account --> Stage --> Table --> View

Organization --> Account --> Database --> Schema --> Stage

37 / 60

What Snowflake features should be leveraged when modeling using Data Vault?

Data needs to be pre-partitioned to obtain a superior data access performance

Scaling up the virtual warehouses will support parallel processing of new source loads

Snowflake’s support of multi-table inserts into the data model’s Data Vault tables

Snowflake’s ability to hash keys so that hash key joins can run faster than integer joins

38 / 60

A company has several sites in different regions from which the company wants to ingest data.
Which of the following will enable this type of data ingestion?

The company must replicate data between Snowflake accounts

The company should use a storage integration for the external stage

The company must have a Snowflake account in each cloud region to be able to ingest data to that account

The company should provision a reader account to each site and ingest the data through the reader accounts

39 / 60

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 TABLE Recover Data CLONE Data AT(TIME => -60*5);

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

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

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

40 / 60

An Architect needs to grant a group of ORDER_ADMIN users the ability to clean old data in an ORDERS table (deleting all records older than 5 years), without granting any privileges on the table. The group’s manager (ORDER_MANAGER) has full DELETE privileges on the table.
How can the ORDER_ADMIN role be enabled to perform this data cleanup, without needing the DELETE privilege held by the ORDER_MANAGER role?

This scenario would actually not be possible in Snowflake – any user performing a DELETE on a table requires the DELETE privilege to be granted to the role they are using

Create a stored procedure that runs with caller’s rights, including the appropriate "> 5 years" business logic, and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure

Create a stored procedure that runs with owner’s rights, including the appropriate "> 5 years" business logic, and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure

Create a stored procedure that can be run using both caller’s and owner’s rights (allowing the user to specify which rights are used during execution), and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure

41 / 60

Which Snowflake data modeling approach is designed for BI queries?

3 NF

Data Vault

Star schema

Snowflake schema

42 / 60

An Architect would like to save quarter-end financial results for the previous six years.
Which Snowflake feature can the Architect use to accomplish this?

Secure views

Time Travel

Materialized view

Search optimization service

Zero-copy cloning

43 / 60

Which feature provides the capability to define an alternate cluster key for a table with an existing cluster key?

Result cache

External table

Materialized view

Search optimization

44 / 60

How does a standard virtual warehouse policy work in Snowflake?

It prevents or minimizes queuing by starting additional clusters instead of conserving credits

It conserves credits by keeping running clusters fully loaded rather than starting additional clusters

It starts only f the system estimates that there is a query load that will keep the cluster busy for at least 2 minutes

It starts only if the system estimates that there is a query load that will keep the cluster busy for at least 6 minutes

45 / 60

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 the same timestamp value

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

46 / 60

How can an Architect enable optimal clustering to enhance performance for different access paths on a given table?

Create multiple clustering keys for a table

Create multiple materialized views with different cluster keys

Create super projections that will automatically create clustering

Create a clustering key that contains all columns used in the access paths

47 / 60

A large manufacturing company runs a dozen individual Snowflake accounts across its business divisions. The company wants to increase the level of data sharing to support supply chain optimizations and increase its purchasing leverage with multiple vendors.
The company’s Snowflake Architects need to design a solution that would allow the business divisions to decide what to share, while minimizing the level of effort spent on configuration and management. Most of the company divisions use Snowflake accounts in the same cloud deployments with a few exceptions for European-based divisions.
According to Snowflake recommended best practice, how should these requirements be met?

Deploy a Private Data Exchange in combination with data shares for the European accounts

Deploy to the Snowflake Marketplace making sure that invoker_share() is used in all secure views

Deploy a Private Data Exchange and use replication to allow European data shares in the Exchange

Migrate the European accounts in the global region and manage shares in a connected graph architecture. Deploy a Data Exchange

48 / 60

A healthcare company wants to share data with a medical institute. The institute is running a Standard edition of Snowflake; the healthcare company is running a Business Critical edition.
How can this data be shared?

Set the share_restriction parameter on the shared object to false

Contact Snowflake and they will execute the share request for the healthcare company

By default, sharing is supported from a Business Critical Snowflake edition to a Standard edition

The healthcare company will need to change the institute’s Snowflake edition in the accounts panel

49 / 60

An Architect is designing a pipeline to stream event data into Snowflake using the Snowflake Kafka connector. The Architect’s highest priority is to configure the connector to stream data in the MOST cost-effective manner.
Which of the following is recommended for optimizing the cost associated with the Snowflake Kafka connector?

Utilize a lower Buffer.size.bytes in the connector configuration

Utilize a higher Buffer.size.bytes in the connector configuration

Utilize a higher Buffer.flush.time in the connector configuration

Utilize a lower Buffer.count.records in the connector configuration

50 / 60

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

SYSADMIN, SECURITYADMIN

ACCOUNTADMIN, USER with PRIVILEGE

ACCOUNTADMIN, SECURITYADMIN

SECURITYADMIN, USER with PRIVILEGE

51 / 60

What integration object should be used to place restrictions on where data may be exported?

API integration

Storage integration

Stage integration

Security integration

52 / 60

The following DDL command was used to create a task based on a stream:

Assuming MY_WH is set to auto_suspend – 60 and used exclusively for this task, which statement is true?

The warehouse MY_WH will never suspend

The warehouse MY_WH will only be active when there are results in the stream

The warehouse MY_WH will be made active every five minutes to check the stream

The warehouse MY_WH will automatically resize to accommodate the size of the stream

53 / 60

What is a characteristic of loading data into Snowflake using the Snowflake Connector for Kafka?

The Connector only works in Snowflake regions that use AWS infrastructure

The Connector creates and manages its own stage, file format, and pipe objects

The Connector works with all file formats, including text, JSON, Avro, Ore, Parquet, and XML

Loads using the Connector will have lower latency than Snowpipe and will ingest data in real time

54 / 60

The table contains five columns and it has millions of records. The cardinality distribution of the columns is shown below:

Column C4 and C5 are mostly used by SELECT queries in the GROUP BY and ORDER BY clauses. Whereas columns C1, C2 and C3 are heavily used in filter and join conditions of SELECT queries.
The Architect must design a clustering key for this table to improve the query performance.
Based on Snowflake recommendations, how should the clustering key columns be ordered while defining the multi-column clustering key?

C1, C3, C2

C2, C1, C3

C3, C4, C5

C5, C4, C2

55 / 60

An Architect has a VPN_ACCESS_LOGS table in the SECURITY_LOGS schema containing timestamps of the connection and disconnection, username of the user, and summary statistics.
What should the Architect do to enable the Snowflake search optimization service on this table?

Assume role with ALL PRIVILEGES including ADD SEARCH OPTIMIZATION in the SECURITY LOGS schema

Assume role with OWNERSHIP on future tables and ADD SEARCH OPTIMIZATION on the SECURITY_LOGS schema

Assume role with OWNERSHIP on VPN_ACCESS_LOGS and ADD SEARCH OPTIMIZATION in the SECURITY_LOGS schema

Assume role with ALL PRIVILEGES on VPN_ACCESS_LOGS and ADD SEARCH OPTIMIZATION in the SECURITY_LOGS schema

56 / 60

A Data Engineer is designing a near real-time ingestion pipeline for a retail company to ingest event logs into Snowflake to derive insights. A Snowflake Architect is asked to define security best practices to configure access control privileges for the data load for auto-ingest to Snowpipe.
What are the MINIMUM object privileges required for the Snowpipe user to execute Snowpipe?

USAGE on the named pipe, named stage, target database, and schema, and INSERT and SELECT on the target table

OWNERSHIP on the named pipe, USAGE on the named stage, target database, and schema, and INSERT and SELECT on the target table

CREATE on the named pipe, USAGE and READ on the named stage, USAGE on the target database and schema, and INSERT end SELECT on the target table

OWNERSHIP on the named pipe, USAGE and READ on the named stage, USAGE on the target database and schema, and INSERT end SELECT on the target table

57 / 60

The IT Security team has identified that there is an ongoing credential stuffing attack on many of their organization’s system.
What is the BEST way to find recent and ongoing login attempts to Snowflake?

Call the LOGIN_HISTORY Information Schema table function

View the Users section in the Account tab in the Snowflake UI and review the last login column

Query the LOGIN_HISTORY view in the ACCOUNT_USAGE schema in the SNOWFLAKE database

View the History tab in the Snowflake UI and set up a filter for SQL text that contains the text "LOGIN"

58 / 60

A user has the appropriate privilege to see unmasked data in a column.
If the user loads this column data into another column that does not have a masking policy, what will occur?

Masked data will be loaded into the new column

Unmasked data will be loaded in the new column

Unmasked data will be loaded into the new column and no users will be able to see the unmasked data

Unmasked data will be loaded into the new column but only users with the appropriate privileges will be able to see the unmasked data

59 / 60

Company A would like to share data in Snowflake with Company B. Company B is not on the same cloud platform as Company A.
What is required to allow data sharing between these two companies?

Setup data replication to the region and cloud platform where the consumer resides

Ensure that all views are persisted, as views cannot be shared across cloud platforms

Create a pipeline to write shared data to a cloud storage location in the target cloud provider

Company A and Company B must agree to use a single cloud platform: Data sharing is only possible if the companies share the same cloud provider

60 / 60

At which object type level can the APPLY MASKING POLICY, APPLY ROW ACCESS POLICY and APPLY SESSION POLICY privileges be granted?

Table

Global

Schema

Database

Your score is

The average score is 0%

By Wordpress Quiz plugin

Free ARA-C01 Practice Exam – 2025 Updated

Get Ready Smarter for the ARA-C01 Exam with Our Free and Accurate ARA-C01 Exam Questions – Updated for 2025.

Disclaimer

[email protected]

Helpful links

top Vendors

Contact Us

[email protected]

FLASH OFFER

avail $6 DISCOUNT on YOUR PURCHASE