Free ADA-C01 Questions for Snowflake ADA-C01 Exam

Question #1

Which tasks can be performed by the ORGADMIN role? (Select THREE).

A. Create one or more accounts in the organization.

B. View a list of all regions enabled for the organization.

C. Create secure views on application tables within the organization.

D. Create a reader account to share data with another organization.

E. View usage information for all accounts in the organization.

F. Perform zero-copy cloning on account data.

Discussion 0

Correct Answer: A,B,E Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #2

Which statement allows this user to access this Snowflake account from a specific IP address (192.168.1.100) while blocking their access from anywhere else?

A. CREATE NETWORK POLICY ADMIN_POLICY
ALLOWED_IP_LIST = ('192.168.1.100');
ALTER USER ABC SET NETWORK_POLICY = 'ADMIN_POLICY';
User ABC is the only user with an ACCOUNTADMIN role.

B. CREATE NETWORK POLICY ADMIN_POLICY
ALLOWED IP LIST = ('192.168.1.100')
BLOCKED_IP_LIST = ('0.0.0.0/0');
ALTER USER ABC SET NETWORK_POLICY = 'ADMIN_POLICY';

C. CREATE OR REPLACE NETWORK POLICY ADMIN_POLICY
ALLOWED_IP_LIST = ('192.168. 1. 100/0') ;
ALTER USER ABC SET NETWORK_POLICY = 'ADMIN_POLICY';

D. CREATE NETWORK POLICY ADMIN POLICY
ALLOWED_IP_LIST = ('192.168.1.100');
ALTER ROLE ACCOUNTADMIN SET NETWORK_POLICY = 'ADMIN_POLICY';

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #3

An Administrator needs to create a sample of the table LINEITEM. The sample should not be repeatable and the sampling function should take the data by blocks of rows.
What select command will generate a sample of 20% of the table?

A. select * from LINEITEM tablesample system (20) seed (1);

B. select * from LINEITEM tablesample block (20 rows);

C. select * from LINEITEM sample system (20);

D. select * from LINEITEM sample bernoulli (20);

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #4

The ACCOUNTADMIN of Account 123 works with Snowflake Support to set up a Data Exchange. After the exchange is populated with listings from other Snowflake accounts, what roles in Account 123 are allowed to request and get data?

A. Any role with USAGE privilege on the Data Exchange

B. Any role with IMPORT SHARE and CREATE DATABASE privileges

C. Only the ACCOUNTADMIN role, and no other roles

D. Any role that the listing provider has designated as authorized

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #5

A Snowflake user runs a complex SQL query on a dedicated virtual warehouse that reads a large amount of data from micro-partitions. The same user wants to run another query that uses the same data set.
Which action would provide optimal performance for the second SQL query?

A. Prevent the virtual warehouse from suspending between the running of the first and second queries.

B. Increase the STATEMENT_TIMEOUT_IN_SECONDS parameter in the session.

C. Assign additional clusters to the virtual warehouse.

D. Use the RESULT_SCAN function to post-process the output of the first query.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #6

What are benefits of using Snowflake organizations? (Select TWO).

A. Administrators can simplify data movement across all accounts within the organization.

B. Administrators can monitor and understand usage across all accounts in the organization.

C. Administrators have the ability to create accounts in any available cloud provider or region.

D. Administrators can change Snowflake account editions on-demand based on need.

E. User administration is simplified across all accounts within the organization.

Discussion 0

Correct Answer: B,C Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #7

What are benefits of creating and maintaining resource monitors in Snowflake? (Select THREE).

A. The cost of running a resource monitor is only 10% of a credit, per day of operation.

B. Resource monitor governance is tightly controlled and monitors can only be created by the ACCOUNTADMIN role or users with the CREATE MONITOR privilege.

C. Resource monitors add no additional load to virtual warehouse compute.

D. Multiple triggers can be configured across various virtual warehouse thresholds.

E. Multiple resource monitors can be applied to a single virtual warehouse.

F. Resource monitors can be applied to more than one virtual warehouse.

Discussion 0

Correct Answer: C,D,F Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #8

A retailer uses a TRANSACTIONS table (100M rows, 1.2 TB) that has been clustered by the STORE_ID column (varchar(50)). The vast majority of analyses on this table are grouped by STORE_ID to look at store performance.
There are 1000 stores operated by the retailer but most sales come from only 20 stores. The Administrator notes that most queries are currently experiencing poor pruning, with large amounts of bytes processed by even simple queries.
Why is this occurring?

A. The table is not big enough to take advantage of the clustering key.

B. The STORE_ID should be numeric.

C. The cardinality of the stores to transaction count ratio is too low to use the STORE_ID as a clustering key.

D. Sales across stores are not uniformly distributed.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Free ADA-C01 Questions for Snowflake SnowPro Advanced Administrator ADA-C01 Exam as PDF & Practice Test Engine

Download Free Snowflake ADA-C01 Demo