Achieve SnowPro Advanced: Architect Certification: Latest ARA-C01 Exam Dumps Are Online

Eleanor2024-10-14T15:13:51+00:00

By Eleanor Snowflake

To earn the SnowPro Advanced: Architect Certification, candidates need to pass the ARA-C01 exam. It will help you test advanced knowledge and skills used to apply comprehensive architect solutions using Snowflake. So if you are planning to take the Snowflake ARA-C01 exam and achieve success, you can choose the latest ARA-C01 exam dumps as the preparation materials. We created these latest ARA-C01 questions and answers based on the knowledge and skills, which are valid to ensure that you can pass the ARA-C01 SnowPro Advanced Architect exam on the first attempt.

You can read the free ARA-C01 demo questions below to test the latest ARA-C01 exam dumps:

Page 1 of 5

1. How do you refresh a materialized view?

ALTER VIEW <MV_NAME> REFRESH

REFRESH MATERIALIZED VIEW <MV_NAME>

Materialized views are automatically refreshed by snowflake and does not require manual intervention

2. Which copy options are not supported by CREATE PIPE...AS COPY FROM command?

FILES = ( 'file_name1' [ , 'file_name2', ... ] )

FORCE = TRUE | FALSE

ON_ERROR = ABORT_STATEMENT

VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS

MATCH_BY_COLUMN_NAME = CASE_SENSITIVE | CASE_INSENSITIVE | NONE

3. When a cloned table is replicated to a secondary database, the data also gets replicated in the secondary database

TRUE

FALSE

4. Removing files from a stage after you are done loading the files improves performance when subsequently loading data

TRUE

FALSE

5. Following objects can be cloned in snowflake

Permanent table

Transient table

Temporary table

External tables

Internal stages

6. Loading data using snowpipe REST API is supported for external stage only

TRUE

FALSE

7. Files stored in snowflake internal stage are automatically encrypted using either AES 128 or 256 strong encryption.

TRUE

FALSE

8. Which command below will load data from result_scan to a table?

CREATE OR REPLACE TABLE STORE_FROM_RESULT_SCAN AS select * from table(result_scan(last_query_id()));

CREATE OR REPLACE TABLE STORE_FROM_RESULT_SCAN AS select * from result_scan(last_query_id());

INSERT INTO STORE_FROM_RESULT_SCAN select * from result_scan(last_query_id());

9. What will happen if you try to ALTER a COLUMN(which has NULL values) to set it to NOT NULL

An error is returned and no changes are applied to the column

Snowflake automatically assigns a default value and let the change happen

Snowflake drops the row and let the change happen

10. To convert JSON null value to SQL null value, you will use

STRIP_NULL_VALUE

IS_NULL_VALUE

NULL_IF

Page 2 of 5

11. What will the below query return

SELECT TOP 10 GRADES FROM STUDENT;

The top 10 highest grades

The 10 lowest grades

Non-deterministic list of 10 grades

12. How do you validate the data that is unloaded using COPY INTO command

After unloading, load the data into a relational table and validate the rows

Load the data into a CSV file to validate the rows

Use validation_mode='RETURN_ROWS'; with COPY command

13. With default settings, how long will a query run on snowflake

Snowflake will cancel the query if it runs more than 48 hours

Snowflake will cancel the query if it runs more than 24 hours

Snowflake will cancel the query if the warehouse runs out of memory

Snowflake will cancel the query if the warehouse runs out of memory and hard disk storage

14. The kafka connector creates one pipe for each partition in a Kafka topic.

TRUE

FALSE

15. Which of the below commands will use warehouse credits?

SHOW TABLES LIKE 'SNOWFL%';

SELECT MAX(FLAKE_ID) FROM SNOWFLAKE;

SELECT COUNT(*) FROM SNOWFLAKE;

SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY FLAKE_ID;

16. When unloading from a snowflake table to an internal or external stage, the COPY INTO command supports which of the below ones?

String truncation

Reordering columns

Casts

Join

Omission of columns

17. When would you usually consider to add clustering key to a table

The performance of the query has deteriorated over a period of time.

The number of users querying the table has increased

it is a multi-terabyte size table

The table has more than 20 columns

18. Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns.

Which are those?

RECORD_CONTENT

RECORD_METADATA

RECORD_MESSAGE

19. A user needs access to create materialized view on a shema mydb.myschema.

What is the appropriate command to provide the access?

GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYD

MYSCHEMA TO MYROLE;

GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYD

MYSCHEMA TO USER USER1;

GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYD

MYSCHEMA TO USER1;

20. You want to automatically delete the files from stage after a successful load using the COPY INTO command.

What will be recommended approach for deletion?

Set PURGE=TRUE in the COPY INTO command

Set REMOVE=TRUE in the COPY INTO Command

No need to do anything, snowflake does it automatically

Page 3 of 5

21. When loading data from stage using COPY INTO, what options can you specify for the ON_ERROR clause?

CONTINUE

SKIP_FILE

ABORT_STATEMENT

FAIL

22. Snowflake has row level security

TRUE

FALSE

23. Dynamic data masking is supported in which editions of snowflake

Enterprise

VPS

Business Critical

Standard

24. Which command below will only copy the table structure from the existing table to the new table?

CREATE TABLE … AS SELECT

CREATE TABLE … LIKE

CREATE TABLE … CLONE

25. Who can provide permission to EXECUTE TASK?

ACCOUNTADMIN

THE TASK OWNER

SYSADMIN

26. You have created a table as below

CREATE TABLE SNOWFLAKE (FLAKE_ID INTEGER, UDEMY_COURSE VARCHAR);

Which of the below select query will fail for this table?

SELECT * from snowflake;

SELECT * from Snowflake;

SELECT * from "snowflake";

SELECT * FROM "SNOWFLAKE";

27. Which command can be run to list all shares that have been created in your account or are available to consume by your account

SHOW SHARES

LIST SHARES

DESCRIBE SHARES

28. Which of the below objects cannot be replicated from one region to the other?

File Formats

Sequences

Pipes

Views

Materialized views

Streams

29. Where can you define the file format settings?

While creating named file formats

In the table definition

In the named stage definition

Directly in the COPY INTO TABLE statement when loading data

30. Which of the below operations are allowed on an inbound share data?

MERGE

CREATE/DROP/ALTER TABLE

ALTER SCHEMA

SELECT WITH JOIN

SELECT WITH GROUP BY

INSERT INTO

Page 4 of 5

31. You are a snowflake architect in an organization. The business team came to to deploy an use case which requires you to load some data which they can visualize through tableau. Everyday new data comes in and the old data is no longer required.

What type of table you will use in this case to optimize cost

TRANSIENT

TEMPORARY

PERMANENT

32. Which of the below commands lists all the pipes for which you have access?

Display Pipes()

SHOW PIPES()

LIST PIPES()

LIST @PIPES

33. This privilege applies to only shared databases. It grants ability to enable roles other than the owning role to access a shared database.

Which is that role?

IMPORTED PRIVILEGES

SHARED PRIVILEGES

IMPORT SHARE

34. Which alter command below may affect the availability of column with respect to time travel?

ALTER TABL

..DROP COLUMN

ALTER TABL

..SET DATA TYPE

ALTER TABL

..SET DEFAULT

35. What is the best practice to follow when calling the SNOWPIPE REST API loadHistoryScan

Reading the last 10 minutes of history every 8 minutes

Read the last 24 hours of history every minute

Read the last 7 days of history every hour

36. Refreshing a secondary database is not allowed in the following circumstances

Materialized views

Primary database contains transient tables

Databases created from shares

Primary database has external table

37. SNOWPIPE_AUTO_INGEST is supported for external stages only

TRUE

FALSE

38. You have created a TASK in snowflake.

How will you resume it?

No need to resume, the creation operation automatically enables the task

ALTER TASK mytask1 RESUME;

ALTER TASK mytask1 START;

39. While choosing a cluster key, what is recommended by snowflake?

Cluster columns that are most actively used in selective filters

If there is room for additional cluster keys, then consider columns frequently used in join predicates

Choose a key with high cardinality

40. Secure views cannot take advantage of the internal optimizations which require access to the underlying data in the base tables for the view.

TRUE

FALSE

Page 5 of 5

41. Below are the rest APIs provided by Snowpipe

insertFiles

insertReport

loadData

42. With default settings for multi cluster warehouse, how does snowflake determines when to start a new cluster?

Immediately when either a query is queued or the system detects that there’s one more query than the currently-running clusters can execute

Only if the system estimates there’s enough query load to keep the cluster busy for at least 6 minutes.

Only if the system estimates there’s enough query load to keep the cluster busy for at least 4 minutes.

43. A user who has SELECT privilege on a view does not also need SELECT privilege on the tables that the view uses

TRUE

FALSE

44. Data sharing is supported only between provider and consumer accounts in same region

TRUE

FALSE

45. You have create a task as below

CREATE TASK mytask1

WAREHOUSE = mywh

SCHEDULE = '5 minute'

WHEN

SYSTEM$STREAM_HAS_DATA('MYSTREAM')

AS

INSERT INTO mytable1(id,name) SELECT id, name FROM mystream WHERE METADATA$ACTION = 'INSERT';

Which statement is true below?

If SYSTEM$STREAM_HAS_DATA returns false, the task will be skipped

If SYSTEM$STREAM_HAS_DATA returns false, the task will still run

If SYSTEM$STREAM_HAS_DATA returns false, the task will go to suspended mode

46. You have created a table as below

CREATE TABLE TEST_01 (NAME STRING(10));

What data type SNOWFLAKE will assign to column NAME?

LONGCHAR

STRING

VARCHAR

47. You have a very large table which is already clustered on columns that are used to retrieve data from the table by a business group. The base table data does not change much. Another business group came to you and requested for a relatively small subset of data from the table which they will query using complex aggregation logic. You know that querying with those columns will take a lot of time because the table is not clustered on those columns.

What is the most optimal solution that you will suggest to the business team?

CREATE A MATERIALIZED VIEW AND CLUSTER THE VIEW ON THOSE COLUMNS

CREATE A SECURE VIEW

CREATE A REGULAR VIEW

48. Materialized views based on external tables can improve query performance

TRUE

FALSE

49. You need to choose a high cardinality column for the clustering key

TRUE

FALSE

50. Please select the correct hierarchy from below

Achieve SnowPro Advanced: Architect Certification: Latest ARA-C01 Exam Dumps Are Online

Achieve SnowPro Advanced: Architect Certification: Latest ARA-C01 Exam Dumps Are Online

You can read the free ARA-C01 demo questions below to test the latest ARA-C01 exam dumps:

Share this post

Author

Related Posts