(Snowflake) Authentic ARA-C01 Dumps - Reduce Your Chances of Failure

(Snowflake) Authentic ARA-C01 Dumps – Reduce Your Chances of Failure

Jonnie Karnath2023-03-31T11:20:24+00:00

Certspots is a leading provider of ARA-C01 dumps designed to help candidates prepare for the exam and increase their chances of success. We offer authentic and up-to-date ARA-C01 dumps that are designed to simulate the actual exam environment, so candidates can get a feel for the types of questions they will encounter on the day of the exam. By practicing with Certspots authentic ARA-C01 dumps, candidates can evaluate their knowledge and skills, identify areas where they need to improve, and develop strategies for answering exam questions quickly and accurately. This will not only reduce their chances of failure but will also help them perform better on the actual exam.

Page 1 of 12

1. Databases created from shares cannot be replicated

TRUE

FALSE

2. You set up a Snowflake account, choosing AWS as your cloud platform provider.

What stages can you use to load data files? (Check all that apply)

NAMED EXTERNAL - using Azure BLOB storage

NAMED EXTERNAL - using GCS/GCP Buckets

NAMED EXTERNAL - using S3 Buckets

TABLE

NAMED INTERNAL

USER

3. Objects that are dropped from a shared database and then recreated with the same name are not immediately available in the share; you must execute grant usage on the objects to make them available

FALSE

TRUE

4. Materialized views doesn't incur any costs. (TRUE / FALSE)

TRUE

FALSE

5. What is the recommended strategy to choose the right sized warehouse to achieve best performance based on query processing?

Run homogenous queries on the same warehouse

Run heterogenous queries on the same warehouse

6. Below are the rest APIs provided by Snowpipe

insertFiles

insertReport

loadData

7. Scaling up is intended for handling concurrency issues dure to more users or more queries

TRUE

FASE

8. Stages which do not support File Formats are:

Internal User Stage

Internal Table Stage

Internal named Stage

External Named Stage

9. 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

10. Snowflake includes administration settings for resource consumption in order to

Help control costs associated with unexpected credit usage of data

Manage access to data warehouses for specific users

Maintain data availability

Page 2 of 12

11. To connect with Snowflake, Kafka Snowflake connector supports:

User Name and Password Authentication

Both

Key Pair Authentication

12. Mike had a table EMPLOYEE_RECORDS. Accidently, he dropped the table. He create the table EMPLOYEE_RECORDS using CREATE TABLE command. Someone adviced him to use Time Travel feature.

What command he should run to get the EMPLOYEE_RECORDS from time-travel?

COPY INTO TABLE EMPLOYEE_RECORDS(-1) FROM EMPLOYEE_RECORDS(0);

Run DROP TABLE EMPLOYEE_RECORDS; UNDROP EMPLOYEE_RECORDS;

Run - UNDROP TABLE EMPLOEE_RECORDS;

Run - ALTER TABLE EMPLOYEE_RECORDS RENAME TO EMPLOYEE_RECORDS_OTHER; UNDROP TABLE EMPLOYEE_RECORDS;

13. 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.

14. 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

15. You ran a query and the query

SELECT * FROM inventory WHERE BIBNUMBER = 2805127;

The query profile looks as below. If you would like to further tune the query, what is the best thing to do?

Execute the below query to enable auto clustering

alter table inventory cluster by (BIBNUMBER);

Create an index on column BIBNUMBER

Divide the table into multiple smaller tables

16. Which type of view has an extra layer of protection to hide the SQL code from unauthorized viewing?

Standard

Materialized

Secure

Permanent

17. Files arrive in an external stage every 10 seconds from a proprietary system. The files range in size from 500 K to 3 MB. The data must be accessible by dashboards as soon as it arrives.

How can a Snowflake Architect meet this requirement with the LEAST amount of coding? (Choose two.)

Use Snowpipe with auto-ingest.

Use a COPY command with a task.

Use a materialized view on an external table.

Use the COPY INTO command.

Use a combination of a task and a stream.

18. Which metrics below will help you take a decision if you need to resize your warehouse?

QUERY_HISTOR

BYTES_SCANNED

QUERY_HISTOR

REMOTE_SPILLAGE_BYTES

QUERY_HISTOR

SCANNED_ROWS

19. When a cloned table is replicated to a secondary database, the physical data is also replicated. (TRUE / FALES)

FALSE

TRUE

20. Which stage is allocated to a user?

Internal named stage

Internal table stage

External names stage

Internal user stage

Page 3 of 12

21. A media company needs a data pipeline that will ingest customer review data into a Snowflake table, and apply some transformations. The company also needs to use Amazon Comprehend to do sentiment analysis and make the de-identified final data set available publicly for advertising companies who use different cloud providers in different regions.

The data pipeline needs to run continuously ang efficiently as new records arrive in the object storage leveraging event notifications. Also, the operational complexity, maintenance of the infrastructure, including platform upgrades and security, and the development effort should be minimal.

Which design will meet these requirements?

Ingest the data using COPY INTO and use streams and tasks to orchestrate transformations. Export the data into Amazon S3 to do model inference with Amazon Comprehend and ingest the data back into a Snowflake table. Then create a listing in the Snowflake Marketplace to make the data available to other companies.

Ingest the data using Snowpipe and use streams and tasks to orchestrate transformations. Create an external function to do model inference with Amazon Comprehend and write the final records to a Snowflake table. Then create a listing in the Snowflake Marketplace to make the data available to other companies.

Ingest the data into Snowflake using Amazon EMR and PySpark using the Snowflake Spark connector. Apply transformations using another Spark job. Develop a python program to do model inference by leveraging the Amazon Comprehend text analysis AP

Then write the results to a Snowflake table and create a listing in the Snowflake Marketplace to make the data available to other companies.

Ingest the data using Snowpipe and use streams and tasks to orchestrate transformations. Export the data into Amazon S3 to do model inference with Amazon Comprehend and ingest the data back into a Snowflake table. Then create a listing in the Snowflake Marketplace to make the data available to other companies.

22. Validation mode can take the below options

RETURN_<n>_ROWS

RETURN_ERRORS

RETURN_ALL_ERRORS

RETURN_SEVERE_EERORS_ONLY

23. All multi cluster warehouses that were using the Legacy policy now use the default Standard policy

TRUE

FALSE

24. Schema owner can grant object privileges in a regular schema

TRUE

FALSE

25. Who can provide permission to EXECUTE TASK?

ACCOUNTADMIN

THE TASK OWNER

SYSADMIN

26. In the default access control hierarchy, both securityadmin and sysadmin are owned by accountadmin

TRUE

FALSE

27. STRIP_NULL_VALUE converts a JSON “null” value to a SQL NULL value. (TRUE / FALSE)

TRUE

FALSE

28. You have a table named customer_table. You want to create another table as customer_table_other which will be same as customer_table with respect to schema and data.

What is the best option?

CREATE TABLE customer_table_other CLONE customer_table

CREATE TABLE customer_table_other AS SELECT * FROM customer_table

ALTER TABLE customer_table_other SWAP WITH customer_table

29. 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?

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

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

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

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.

30. How can you remove the outer array structure of JSON data?

Set STRIP_OUTER_BRACKET = TRUE

Set STRIP_OUTER_ARRAY = 1

Set STRIP_OUTER_ARRAY = TRUE

Set STRIP_INNER_ARRAY = TRUE

Page 4 of 12

31. Remote service in external function can be an AWS Lambda function

TRUE

FALSE

32. 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

33. 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

34. Which command can give the list of all consumer accounts who have created database from share?

SHOW GRANTS OF DATABASE(*)

SHOW DATABASE OF SHARE <share_name>

SHOW GRANTS OF SHARE <share_name>

SELECT * FROM SHARE <share_name>

35. Which type of view is most like a table?

External

Materialized

Standard

Secure

36. Out of the three query optimization techniques(search optimization, clustering and materialized view) which one does not have storage cost

Search Optimization Service

Materialized View

Clustering the Table

37. 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 supports COPY statements that load data from external stages only.

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

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

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

38. What type of Privilege Data Consumer should have to administer shares

SHOW SHARE

EXPORT SHARE

IMPORT SHARES

LIST SHARE

39. You have a medium warehouse with auto suspend of 5 minutes. You ran a query on table#1. After 10 minutes, you ran a query that joins table#1 and table#2, but you see that the query did not use data

cache.

Why?

When a warehouse is suspended, it may lose its data cache

The query that ran the second time is completely different from query that ran on table#1, hence it will not be able to use data cache

Joins cannot use any type of cache

40. 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 OWNERSHIP on future tables and ADD SEARCH OPTIMIZATION on the SECURITY_LOGS schema.

Assume role with ALL PRIVILEGES including ADD SEARCH OPTIMIZATION in 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.

Page 5 of 12

41. Mike is having SECURITYADMIN role. He created a custom DBA_ROLE. He Granted SYSADMIN role to DBA_ROLE. He created a user 'Jessica'. Mike granted DBA_ROLE to Jessica. Jessica creates a Database Jessica_DB. Jessica then created a Table T1 in Jessica_DB under PUBLIC schema.

What should Mike do to access Table T1 created by Jessica?

GRANT ROLE DBA_ROLE TO Mike; USE DATABASE Jessica_db; Select * from t1;

USE ROLE SECURITYADMIN; USE DATABASE Jessica_db; Select * from t1;

USE ROLE dba_role; USE DATABASE Jessica_db; Select * from t1;

GRANT TOLE DBA_ROLE TO Mike; USE ROLE DBA_ROLE; USE DATABASE Jessica_db; Select * from t1;

42. Bytes spilled to remote storage in query profile indicates volume of data spilled to remote disk

TRUE

FALSE

43. Following objects can be cloned in snowflake

Permanent table

Transient table

Temporary table

External tables

Internal stages

44. What is the best recommended size of data file in case of SNOWPIPE continuous loading?

1 GB Compressed

if file taking more than a minute, then split the files into more files

Same as of Bulk Loading (10 MB - 100 MB compressed)

Same as of Bulk Loading (10 MB - 100 MB uncompressed)

45. Which of the following are characteristics of how row access policies can be applied to external tables? (Choose three.)

An external table can be created with a row access policy, and the policy can be applied to the VALUE column.

A row access policy can be applied to the VALUE column of an existing external table.

A row access policy cannot be directly added to a virtual column of an external table.

External tables are supported as mapping tables in a row access policy.

While cloning a database, both the row access policy and the external table will be cloned.

A row access policy cannot be applied to a view created on top of an external table.

46. A DevOps team has a requirement for recovery of staging tables used in a complex set of data pipelines. The staging tables are all located in the same staging schema. One of the requirements is to have online recovery of data on a rolling 7-day basis.

After setting up the DATA_RETENTION_TIME_IN_DAYS at the database level, certain tables remain unrecoverable past 1 day.

What would cause this to occur? (Choose two.)

The staging schema has not been setup for MANAGED ACCES

The DATA_RETENTION_TIME_IN_DAYS for the staging schema has been set to 1 day.

The tables exceed the 1 TB limit for data recovery.

The staging tables are of the TRANSIENT type.

The DevOps role should be granted ALLOW_RECOVERY privilege on the staging schema.

47. 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

48. Materialized views are recommended for all of the scenarios except

Query results contain a small number of rows and/or columns relative to the base table

Query results contain results that require significant processing

The query is on an external table

The view’s base table changes frequently

49. If an account has federated authentication enabled. Can Snowflake admins still maintain user id and passwords in Snowflake?

Yes

50. Which DML operations will result in re-clustering?

INSERT

COPY

DELETE

MERGE

UPDATE

Page 6 of 12

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

TRUE

FALSE

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

ACCOUNTADMIN, SECURITYADMIN

SYSADMIN, SECURITYADMIN

ACCOUNTADMIN, USER with PRIVILEGE

SECURITYADMIN, USER with PRIVILEGE

53. How many tables can be written for one Kafka Topic?

54. 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

55. Privileges granted on database objects are not replicated to a secondary database.

TRUE

FALSE

56. Mike has a same query which runs for around 40 minutes every hour. Most of the time the data in the table remain same.

What could be best option for Mike to keep warehouse running or AUTO_SUSPEND?

Mike should not set AUTO_SUSPEND

Mike should set AUTO_SUSPEND to 10 minutes

Mike doesn't have to set AUTO_SUSPEN

Snowflake will take care of suspension as needed.

Mike should set AUTO_SUSPEND to 40 minutes

57. Which parameter does help in loading files whose metadata has expired?

set LAST_MODIFIED_DATE to within 64 days

Set LAST_MODIFIED_DATE to more than 64 days

set LOAD_EXPIRED_FILES to TRUE

set LOAD_UNCERTAIN_FILES to TRUE

58. You have created a reader account for sharing data. who will pay for the compute usage of the account

Provider

Consumer

59. How much is the Time-Travel retention period of Temporary Table?

7 days

90 days

0 days

1 day

60. At what places can you specify File Format?

As part of a table definition

In the COPY INTO command

All of these

As part of Internal Table stage

As part of a named stage or pipe definition

Page 7 of 12

61. You will be using a multi cluster warehouse. You will statically control the available resources (i.e. servers) and you have large numbers of concurrent user sessions and/or queries and the numbers do not fluctuate significantly.

Which mode will you use for the warehouse?

Maximized

Auto-Scale

Minimized

62. An Architect entered the following commands in sequence:

USER1 cannot find the table.

Which of the following commands does the Architect need to run for USER1 to find the tables using the Principle of Least Privilege? (Choose two.)

GRANT ROLE PUBLIC TO ROLE INTERN;

GRANT USAGE ON DATABASE SANDBOX TO ROLE INTERN;

GRANT USAGE ON SCHEMA SANDBO

PUBLIC TO ROLE INTERN;

GRANT OWNERSHIP ON DATABASE SANDBOX TO USER INTERN;

GRANT ALL PRIVILEGES ON DATABASE SANDBOX TO ROLE INTERN;

63. You have created a table as below

CREATE TABLE EMPLOYEE(EMPLOYEE_ID NUMBER, EMPLOYEE_NAME VARCHAR);

What datatype Snowflake will use for EMPLOYEE_ID?

FIXED

INTEGER

NUMBER

64. The endpoint insertFiles of SnowPipe rest API is used to inform Snowflake about the files to be ingested into a table. Select the two statements for this end point.

The post can contain at most 5000 files.

Each file path given must be <= 1024 bytes long when serialized as UTF-8

The post can contain unlimited number of files.

65. 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

66. How is the most effective way to test if clustering a table helped performance?

Use SYSTEM$CLUSTERING_INFORMATIO

Check the average_depth

Use SYSTEM$CLUSTERING_INFORMATIO

Check the total_constant_partition_count

Use the SYSTEM$CLUSTERING_DEPTH and check the depth of each column

Run a sample query before clustering and after to compare the results

Use SYSTEM$CLUSTERING_INFORMATIO

Check the average_overlaps

67. As an ACCOUNTADMIN, how can you find the credit usage of a warehouse?

Run SQL query on WAREHOUSE_METERING_HISTORY view under ACCOUNT_USAGE Schema

Run SQL query on ACCOUNT_USAGE table under Snowflake Database

Using Web interface > Account > Usage

Run SQL query on METERING_HISTORY view under ACCOUNT_USAGE Schema

68. You have a view.

How will you list all the object references of the view?

GET_OBJECT_REFERENCES

GET_VIEW_REFERENCES

GET_VIEW_METADATA

69. You have table created as: CREATE TABLE T1 (Name string (50), Salary number (11,2));

If you run DESC TABLE T1; what would be the data type of NAME column?

varchar (50)

varchar

string

string (50)

70. Which Snowflake data modeling approach is designed for BI queries?

3 NF

Star schema

Data Vault

Snowflake schema

Page 8 of 12

71. How can you store Result Scan into a table?

CREATE OR REPLACE TABLE MY_RESULT AS (RESULT_SCAN(last_query_id()));

CREATE OR REPLACE TABLE MY_RESULT RESULT_SCAN(last_query_id()));

CREATE OR REPLACE TABLE MY_RESULT FROM table (RESULT_SCAN(last_query_id(-1)));

CREATE OR REPLACE TABLE MY_RESULT FROM table (RESULT_SCAN(last_query_id()));

CREATE OR REPLACE TABLE MY_RESULT AS SELECT * FROM table (RESULT_SCAN(last_query_id()));

72. What actions can be performed when an error is encountered while loading data from a file?

skip file when the number of errors in the file is equal to 10

Skip file

Abort the load operation

Continue loading the file.

73. Which actions are not supported with shared data?

Creating a clone of a shared database or any schemas/tables in the database

Can be re-shared by data consumer

Time Travel for a shared database or any schemas/tables in the database

Editing the comments for a shared database

74. You have create a table in snowflake as below

CREATE TABLE EMPLOYEE(EMPLOYEE_NAME STRING, SALARY NUMBER); When you do a DESCRIBE TABLE EMPLOYEE, what will you see as the data type of EMPLOYEE_NAME?

VARCHAR(10)

VARCHAR

VARCHAR(16777216)

STRING

75. A multi-cluster virtual warehouse is Maximized when

Minimum number of clusters and Maximum number of clusters are same and must be specified with a value of more than 1.

Minimum and Maximum number of clusters are specified differently.

MIN_CLUSTER_COUNT = 3 MAX_CLUSTER_COUNT = 3

MIN_CLUSTER_COUNT = 1 MAX_CLUSTER_COUNT = 1

76. As of today snowflake supports replication for databases only

TRUE

FALSE

77. You ran the below query. I have a warehouse with auto suspend set at 5 seconds

SELECT * FROM INVENTORY;

The query profile looks like as below. Please see below 'Percentage scanned from cache' is 0%

You ran the query again before 5 seconds has elapsed and the query profile looks as below. Look at the 'Percentage scanned for cache', it is 75%

You ran the query again after 5 seconds. The query profile looks as below. Look at the 'Percentage scanned from cache', it is zero again.

Why is this happening?

The second run of the query used data cache to retrieve part of the result since it ran before the warehouse was suspended

The second run of the query used query result cache

The third run of the query used query result cache

78. An hour ago, you ran a complex query. You then ran several simple queries from the same worksheet. You want to export the results from the complex query but they are no longer loaded in the Results pane of the worksheet.

What is the least costly way to download the results?

Type the command SELECT RESULTS(-3) into the Worksheet and click "Run"

Click on History -> Locate the Query -> Click the QueryID -> Use the "Export Result" button

Click on History -> Locate the Query -> Click "Download Results" in column 3

Type the command Select RESULTS(<Account>,<User>,<QueryID>) in the Worksheet and click "Run"

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

Business continuity and disaster recovery

Secure data sharing across regions/cloud

Data portability and account migrations

All of these

80. Which command will help you the current permissions on a Schema?

SHOW GRANTS ON SCHEMA <database_name>.<schema_name>;

SHOW ROLES ON SCHEMA <database_name>.<schema_name>;

SHOW ALL PREIVILEGE ON SCHEMA <database_name>.<schema_name>;

SHOW GRANTS OF SCHEMA <database_name>.<schema_name>;

Page 9 of 12

81. Multi-cluster warehouses are best utilized for

Scaling resources to improve concurrency for users/queries

Improving the performance of slow-running queries

Improving the performance of data loading

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

STRIP_NULL_VALUE

IS_NULL_VALUE

NULL_IF

83. 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

84. While using joins, non-equality join predicates might result in significantly slower processing speeds and should be avoided if possible.

TRUE

FALSE

85. How many files each server in a cluster can process in parallel?

1 File

Depends on how large is the file. If file is 32 MB in size, the server can process 4 such files in parallel

16 Files

4 Files

8 Files

86. Cloud services can help in pruning even if the columns are variant columns.

TRUE

FALSE

87. Running query against INFORMATION_SCHEMA.QUERY_HISTORY can help in finding the time of queuing / time spent by an query in the warehouse queue. (TRUE/FALSE)

FALSE

TRUE

88. 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 works with all file formats, including text, JSON, Avro, Ore, Parquet, and XM

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

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

89. If a query is slow, how can the query be changed to improve the query?

Provide a hint to the optimizer

Change the order of the where clause to force the optimizer to consider the most effective filter first

Use an ORDER BY on the query to order the data before it’s searched

Reorder the list of tables in the query to change the order the tables are read in the query

If possible, use the table’s defined CLUSTER KEY in the query

90. New or modified data in tables in a share are immediately not available to all consumers who have created a database from a share

FALSE

TRUE

Page 10 of 12

91. Cross-Cloud and Cross-Region replication is type of:

Synchronous Replication

Asynchronous Replication

92. JSON and PARQUET files can be loaded to columns in the same table

TRUE

FALSE

93. Suppose you have two databases D1 and D2. Theses databases contain data required by business analysts in your organization. Based on their functional responsibilities, entry level analysts should have read only access to D1, but access to D2 should be given to advanced analysts only.

Which option will you choose to setup the access?

Option 1:

Option 2:

Option 3:

Option 1

Option 2

Option 3

94. Defining a clustering key directly on top of VARIANT columns is not supported. (TRUE / FALSE)

TRUE

FALSE

95. 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?

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

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.

96. You are running a large join on snowflake. You ran it on a medium warehouse and it took almost an hour to run. You then tried to run the join on a large warehouse but still the performance did not improve.

What may be the most possible cause of this.

There may be a symptom on skew in your data where one of the value of the column is significantly more than rest of the values in the column

Your warehouses do not have enough memory

Since you have configured an warehouse with a low auto-suspend value, your warehouse is going down frequently

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

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

Organize data by granular path

Resize virtual warehouse

All of the above

98. EXECUTE TASK privilege can be granted by whom

ACCOUNTADMIN

SECURITYADMIN

ROLE WHO OWNS THE TASK

99. Clustering keys are not intended for all tables. (TRUE / FALSE)

TRUE

FALSE

100. All data transparently & synchronously replicated across minimum 2 availability zones. (TRUE / FALSE)

FALSE

TRUE

Page 11 of 12

101. Mike has table T1 with Time-Travel retention time period set to 20 days. He increases the retention period by 10 days to make it 30 days.

What impacts will happen on Table data. Please select 2.

No impact on any data that is 20 days older and has already moved into Fail-safe

Data that have moved to Fail-safe after 20 days will now be available in Time-Travel for additional 10 days

No impact on existing data which moved from table to Time-Travel before the increase of Time-Travel retention period

Data that would have been removed after 20 days is now retained for an additional 10 days before moving into Fail-safe

Changes will be ONLY effective for new data coming to Time-Travel

102. What are the types of Caches? (Select 2)

Storage Cache

History Cache

Results Cache

Metadata Cache

103. A query you initiated is taking too long. You've gone into the History area to check whether this query (which usually runs every hour) is supposed to take a long time. Check all true statements.

Information in the History area can be filtered to show a single Session

Information in the History area can help you visually compare query times

Information in the History area can be filtered to show a single Warehouse

If you decide to end the query, you must return to the worksheet to Abort the query

Information in the History area can be filtered to show a single User

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

CSV

XML

Avro

JSON

Parquet

105. Which statement is not true about shared database?

Shared databases are read only

Shared databases cannot be cloned

Time travel is not supported on a shared database

Shared databases can be re-shared with other accounts

106. A CAST command (symbol) will force a value to be output as a certain datatype.

Which of the following code samples will result in the "employeename" being output using the VARCHAR datatype?

SELECT employeename||VARCHAR

SELECT VARCHAR(employeename)

SELECT employeename AS VARCHAR

SELECT employeename::VARCHAR

107. How will you drop a cluster key?

ALTER TABLE <name> DROP CLUSTERING KEY

ALTER TABLE <name> DELETE CLUSTERING KEY

ALTER TABLE <name> REMOVE CLUSTERING KEY

108. Snowflake provides standard and powerful features that ensure the highest levels of security for your account and users if used properly.

Which are the true statements about Snowflake Security?

Tri-secret requires that customers manage their own keys

Snowflake supports user-based access control

Federated authentication in Snowflake is compliant with SAML 2.0

109. Kafka Snowflake connector can read or subscribe one or more Kafka topics. (TRUE / FALSE)

FALSE

TRUE

110. 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?

Search optimization service

Materialized view

Time Travel

Zero-copy cloning

Secure views

Page 12 of 12

111. What are the three Snowflake Stage types? (Select 3)

Table

Secure

Materialized

Permanent

Named

User

112. What are the best practices for JOIN on unique keys?

Use distinct keys

Avoid unintentional cross join

Avoid MANY-TO-MANY Join

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

16 MB(Compressed)

1 GB(Compressed)

32 GB

10 MB - 100 MB compressed

114. Each time the persisted result for a query is reused, Snowflake resets the 24-hour retention period for the result, up to a maximum of 31 days from the date and time that the query was first executed.(TRUE / FALSE)

FALSE

TRUE

115. Which vendors do support Snowflake natively for federated authentication and SSO?

Okta

Google G Suite

Microsoft Azure Active Directory

Onelogin

Microsoft ADFS

116. What are the use cases for cross-cloud & cross-region replication?

All of these

Secure Data Sharing across regions/clouds

Data Portability for Account Migrations

Business Continuity & Disaster Recovery

117. One of your query is taking a long time to finish, when you open the query profiler you see that lot of data is spilling to the remote disk(Bytes spilled to remote storage).

What may be the cause of this?

The amount of memory available for the servers used to execute the operation might not be sufficient to hold intermediate results

The size of the AWS bucket used to hold the data is not sufficient for the query

Number of disks attached to the virtual warehouse is not enough for the processing

118. Snowflake can query the data from External Tables. (TRUE / FALSE)

FALSE

TRUE

Facebook Twitter LinkedIn Google + Email