Winter Special Sale - Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 575363r9

Welcome To DumpsPedia

ADA-C01 Sample Questions Answers

Questions 4

What are characteristics of Dynamic Data Masking? (Select TWO).

Options:

A.

A masking policy that is currently set on a table can be dropped.

B.

A single masking policy can be applied to columns in different tables.

C.

A masking policy can be applied to the VALUE column of an external table.

D.

The role that creates the masking policy will always see unmasked data in query results.

E.

A single masking policy can be applied to columns with different data types.

Buy Now
Questions 5

In general, the monthly billing for database replication is proportional to which variables? (Select TWO).

Options:

A.

The frequency of changes to the primary database as a result of data loading or DML operations

B.

The amount of table data in the primary database that changes as a result of data loading or DML operations

C.

The frequency of the secondary database refreshes from the primary database

D.

The number of times data moves across regions and/or cloud service providers between the primary and secondary database accounts

E.

The number and size of warehouses defined in the primary account

Buy Now
Questions 6

A data provider wants to share data from multiple databases with a data consumer account.

How can this be accomplished?

Options:

A.

The data provider needs to create a secure view and grant the USAGE privilege on each database referenced by the secure view.

B.

The data provider needs to create a secure view and grant the REFERENCE_USAGE privilege on each database referenced by the secure view.

C.

The data provider needs to create a secure view and grant the REFERENCE_USAGE privilege to a database role to include objects from multiple databases in a share

D.

The data provider needs to create a secure view and must grant the REFERENCE_USAGE privilege on the database where the secure view is created.

Buy Now
Questions 7

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

Options:

A.

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

B.

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

C.

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

D.

User administration is simplified across all accounts within the organization.

E.

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

Buy Now
Questions 8

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?

Options:

A.

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.

B.

Create a separate table for all the non-Pll columns and grant the role DEVELOPER access to the new table.

C.

Use the CURRENT_ROLE and CURRENT_USER context functions to integrate with a secure view and filter the sensitive data.

D.

Use the CURRENT_ROLE context function to integrate with a masking policy on the fields that contain sensitive data.

Buy Now
Questions 9

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?

Options:

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');

ALTER ROLE ACCOUNTADMIN SET NETWORK_POLICY = 'ADMIN_POLICY';

C.

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';

D.

CREATE OR REPLACE NETWORK POLICY ADMIN_POLICY

ALLOWED_IP_LIST = ('192.168. 1. 100/0') ;

ALTER USER ABC SET NETWORK_POLICY = 'ADMIN_POLICY';

Buy Now
Questions 10

The following commands were executed:

Grant usage on database PROD to role PROD_ANALYST;

Grant usage on database PROD to role PROD_SUPERVISOR;

Grant ALL PRIVILEGES on schema PROD. WORKING to role PROD_ANALYST;

Grant ALL PRIVILEGES on schema PROD. WORKING to role PROD_SUPERVISOR;

Grant role PROD ANALYST to user A;

Grant role PROD SUPERVISOR to user B;

What authority does each user have on the WORKING schema?

Options:

A.

Only user B can create tables, because all privileges were transferred to PROD_SUPERVISOR.

B.

Tables created by either user A or user B will be visible to both users.

C.

All existing tables in schema PROD. WORKING will be visible to both users.

D.

Both user A and user B can create tables in the PROD. WORKING schema.

Buy Now
Questions 11

What is a characteristic of Snowflake's transaction locking and concurrency modeling?

Options:

A.

A deadlock cannot occur in Snowflake, since concurrently executed queries and DML statements do not block one another.

B.

If two queries are concurrently executed against the same table, one of the two queries will be blocked until the other query completes.

C.

Transaction locking in Snowflake is enforced exclusively at the row and table levels.

D.

Queries executed within a given transaction see that transaction's uncommitted changes.

Buy Now
Questions 12

A user with the proper role issues the following commands when setting up and activating network policies:

CREATE OR REPLACE NETWORK POLICY foo_policy

ALLOWED_IP_LIST = ( '1.1.1.0/24', '2.2.2.0/24' , '3.3. 3. 0/24' )

BLOCKED IP LIST = ( '1.1.1.1')

COMMENT = 'Account level policy';

ALTER ACCOUNT SET NETWORK_POLICY=FOO_POLICY;

CREATE OR REPLACE NETWORK POLICY bar_policy

ALLOWED_IP_LIST = ('3.3.3.0/24')

BLOCKED IP LIST = ('3.3.3.10')

COMMENT = 'user level policy';

ALTER USER userl SET NETWORK_POLICY=BAR_POLICY;

Afterwards, user1 attempts to log in to Snowflake from IP address 3.3.3.10.

Will the login be successful?

Options:

A.

Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of bar_policy.

B.

No, because 3.3.3.10 is found in the BLOCKED_IP_LIST of bar_policy.

C.

Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of foo_policy.

D.

No, because 3.3.3.10 is not found in the ALLOWED_IP_LIST of foo_policy.

Buy Now
Questions 13

What are the requirements when creating a new account within an organization in Snowflake? (Select TWO).

Options:

A.

The account requires at least one ORGADMIN role within one of the organization's accounts.

B.

The account name is immutable and cannot be changed.

C.

The account name must be specified when the account is created.

D.

The account name must be unique among all Snowflake customers.

E.

The account name must be unique within the organization.

Buy Now
Questions 14

Which Snowflake objects can be managed using SCIM integration? (Select TWO).

Options:

A.

Stages

B.

Users

C.

Warehouses

D.

Roles

E.

Shares

Buy Now
Questions 15

Which commands can be performed by a user with the ORGADMIN role but not the ACCOUNTADMIN role? (Select TWO).

Options:

A.

SHOW REGIONS;

B.

SHOW USERS;

C.

SHOW ORGANIZATION ACCOUNTS;

D.

GRANT ROLE ORGADMIN TO USER ;

E.

SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER (

'ACCOUNT LOCATOR',

'ENABLE ACCOUNT DATABASE_REPLICATION',

'true'

);

Buy Now
Questions 16

A Snowflake organization MYORG consists of two Snowflake accounts:

The ACCOUNT1 has a database PROD_DB and the ORGADMIN role enabled.

Management wants to have the PROD_DB database replicated to ACCOUNT2.

Are there any necessary configuration steps in ACCOUNT1 before the database replication can be configured and initiated in ACCOUNT2?

Options:

A.

USE ROLE ORGADMIN;

SELECT SYSTEMSGLOBAL_ACCOUNT_SET_PARAMETER ('MYORG. ACCOUNT1', 'ENABLE_ACCOUNT_DATABASE_REPLICATION', 'TRUE');

SELECT SYSTEMSGLOBAL_ACCOUNT_SET_PARAMETER ('MYORG. ACCOUNT2', 'ENABLE_ACCOUNT_DATABASE_REPLICATION', 'TRUE');

USE ROLE ACCOUNTADMIN;

ALTER DATABASE PROD DB ENABLE REPLICATION TO ACCOUNTS MYORG. ACCOUNT2;

B.

USE ROLE ORGADMIN;

SELECT SYSTEMSGLOBAL ACCOUNT SET_PARAMETER ( 'MYORG. ACCOUNT1', 'ENABLE_ACCOUNT_DATABASE_REPLICATION', 'TRUE');

USE ROLE ACCOUNTADMIN;

ALTER DATABASE PROD_DB ENABLE REPLICATION TO ACCOUNTS MYORG. ACCOUNT2 IGNORE EDITION CHECK;

C.

No configuration steps are necessary in ACCOUNT1. Replicating databases across accounts within the same Snowflake organization is enabled by default.

D.

It is not possible to replicate a database from an Enterprise edition Snowflake account to a Standard edition Snowflake account.

Buy Now
Questions 17

DatabaseA has a single schema called Schema1. This schema contains many tables and views. The ANALYST role has privileges to select from all objects in

DatabaseA. Schema1. The SYSADMIN role clones DatabaseA to DatabaseA_clone.

What privileges does the ANALYST role have on tables and views in DatabaseA_clone? (Select TWO).

Options:

A.

USAGE on the schema DatabaseA clone

B.

USAGE on the database DatabaseA_clone. Schemal

C.

SELECT on all tables, and only non-secure views in DatabaseA_clone. Schemal

D.

SELECT on all tables, and only secure views in DatabaseA_clone. Schemal

E.

SELECT on all tables and views in DatabaseA_clone. Schema1

Buy Now
Questions 18

MY_TABLE is a table that has not been updated or modified for several days. On 01 January 2021 at 07:01, a user executed a query to update this table. The query ID is

'8e5d0ca9-005e-44e6-b858-a8f5b37c5726'. It is now 07:30 on the same day.

Which queries will allow the user to view the historical data that was in the table before this query was executed? (Select THREE).

Options:

A.

SELECT * FROM my table WITH TIME_TRAVEL (OFFSET => -60*30);

B.

SELECT * FROM my_table AT (TIMESTAMP => '2021-01-01 07:00:00' :: timestamp);

C.

SELECT * FROM TIME_TRAVEL ('MY_TABLE', 2021-01-01 07:00:00);

D.

SELECT * FROM my table PRIOR TO STATEMENT '8e5d0ca9-005e-44e6-b858-a8f5b37c5726';

E.

SELECT * FROM my_table AT (OFFSET => -60*30);

F.

SELECT * FROM my_table BEFORE (STATEMENT => '8e5d0ca9-005e-44e6-b858-a8f5b37c5726');

Buy Now
Questions 19

For Snowflake network policies, what will occur when the account_level and user_level network policies are both defined?

Options:

A.

The account_level policy will override the user_level policy.

B.

The user_level policy will override the account_level policy.

C.

The user_level network policies will not be supported.

D.

A network policy error will be generated with no definitions provided.

Buy Now
Questions 20

A Snowflake account is configured with SCIM provisioning for user accounts and has bi-directional synchronization for user identities. An Administrator with access to SECURITYADMIN uses the Snowflake UI to create a user by issuing the following commands:

use role USERADMIN;

create or replace role DEVELOPER_ROLE;

create user PTORRES PASSWORD = 'hello world!' MUST_CHANGE_PASSWORD = FALSE

default_role = DEVELOPER_ROLE;

The new user named PTORRES successfully logs in, but sees a default role of PUBLIC in the web UI. When attempted, the following command fails:

use DEVELOPER_ROLE;

Why does this command fail?

Options:

A.

The DEVELOPER_ROLE needs to be granted to SYSADMIN before user PTORRES will be able to use the role.

B.

The new role can only take effect after USERADMIN has logged out.

C.

USERADMIN needs to explicitly grant the DEVELOPER_ROLE to the new USER.

D.

The new role will only take effect once the identity provider has synchronized by way of SCIM with the Snowflake account.

Buy Now
Questions 21

What access control policy will be put into place when future grants are assigned to both database and schema objects?

Options:

A.

Database privileges will take precedence over schema privileges.

B.

Schema privileges will take precedence over database privileges.

C.

An access policy combining both the database object and the schema object will be used, with the most permissive policy taking precedence.

D.

An access policy combining both the database object and the schema object will be used, with the most restrictive policy taking precedence.

Buy Now
Exam Code: ADA-C01
Exam Name: SnowPro Advanced Administrator
Last Update: Feb 4, 2025
Questions: 72
$66  $164.99
$50  $124.99
$42  $104.99
buy now ADA-C01