ADA-C01 by Snowflake Actual Free Exam Q&As

Question 1

When adding secure views to a share in Snowflake, which function is needed to authorize users from another account to access rows in a base table?

A. CURRENT_ROLE B. CURRENT_CLIENT C. CURRENT ACCOUNT D. CURRENT_USER

Discussion 0

Correct Answer: D Vote an answer

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

Question 2

A company enabled replication between accounts and is ready to replicate data across regions in the same cloud service provider.
The primary database object is : PROD_AWS_EAST. Location : AWS_EAST
The secondary database object is : PROD_AWS_WEST. Location : AWS_WEST
What command and account location is needed to refresh the data?

A. Location : AWS_WEST
Command : REFRESH DATABASE PROD_AWS WEST REFRESH; B. Location : AWS EAST
Command: ALTER DATABASE PROD_AWS_WEST REFRESH; C. Location : AWS_WEST
Command : ALTER DATABASE PROD AWS WEST REFRESH; D. Location : AWS_EAST
Command : REFRESH DATABASE PROD_AWS_WEST REFRESH;

Discussion 0

Correct Answer: A Vote an answer

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

Question 3

An Administrator has been asked to support the company's application team need to build a loyalty program for its customers. The customer table contains Personal Identifiable Information (PII), and the application team's role is DEVELOPER.
CREATE TABLE customer_data (
customer_first_name string,
customer_last_name string,
customer_address string,
customer_email string,
... some other columns,
);
The application team would like to access the customer data, but the email field must be obfuscated.
How can the Administrator protect the sensitive information, while maintaining the usability of the data?

A. Use the CURRENT_ROLE context function to integrate with a masking policy on the fields that contain sensitive data. B. Create a view on the customer_data table to eliminate the email column by omitting it from the SELECT clause. Grant the role DEVELOPER access to the view. C. Create a separate table for all the non-Pll columns and grant the role DEVELOPER access to the new table. D. Use the CURRENT_ROLE and CURRENT_USER context functions to integrate with a secure view and filter the sensitive data.

Discussion 0

Correct Answer: A Vote an answer

Question 4

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. Assign additional clusters to the virtual warehouse. B. Prevent the virtual warehouse from suspending between the running of the first and second queries. C. Increase the STATEMENT_TIMEOUT_IN_SECONDS parameter in the session. 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 PassTestking members. You can sign-up / login (it's free).

Question 5

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. User administration is simplified across all accounts within the organization. E. Administrators can change Snowflake account editions on-demand based on need.

Discussion 0

Correct Answer: B,C Vote an answer

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

Question 6

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 OR REPLACE NETWORK POLICY ADMIN_POLICY
ALLOWED_IP_LIST = ('192.168. 1. 100/0') ;
ALTER USER ABC SET NETWORK_POLICY = 'ADMIN_POLICY'; C. CREATE NETWORK POLICY ADMIN POLICY
ALLOWED_IP_LIST = ('192.168.1.100');
ALTER ROLE ACCOUNTADMIN SET NETWORK_POLICY = 'ADMIN_POLICY'; D. 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';

Discussion 0

Correct Answer: D Vote an answer

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

Question 7

What are characteristics of data replication in Snowflake? (Select THREE).

A. Users must be granted REPLICATIONADMIN privileges in order to enable replication. B. Users can have unlimited primary databases and they can be replicated to an unlimited number of accounts if all accounts are within the same organization. C. Databases created from shares can be replicated. D. The ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command must be issued from the primary account. E. To start replication run the ALTER DATABASE ... REFRESH command on the account where the secondary database resides. F. Replication can only occur within the same cloud provider.

Discussion 0

Correct Answer: B,C,D Vote an answer

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

Question 8

What role or roles should be used to properly create the object required to setup OAuth 2.0 integration?

A. Any role with GRANT USAGE on SECURITY INTEGRATION B. ACCOUNTADMIN and SECURITYADMIN C. ACCOUNTADMIN only D. ACCOUNTADMIN and SYSADMIN

Discussion 0

Correct Answer: C Vote an answer

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

Snowflake SnowPro Advanced Administrator - ADA-C01 Exam Practice Test