Black Friday Reward - Upto 75% off - Ends in 0d 00h 00m 00s - Coupon code: CFsave75

Pass the Snowflake SnowPro Advanced: Administrator ADA-C02 Questions and answers with CertsForce

Viewing page 2 out of 2 pages
Viewing questions 11-20 out of questions
Questions # 11:

Which SCIM integration types does Snowflake support?

Choose three

Options:

A.

Amazon Web Services (AWS)


B.

Google Cloud Platform (GCP)


C.

Okta


D.

Custom


E.

Azure Active Directory (Azure AD)


F.

Duo Security Provisioning Connector


Expert Solution
Questions # 12:

A sales team at an organization runs the following Snowflake query several times each day:

Question # 12

What can the Snowflake Administrator do to optimize use of persisted query results whenever possible?

Options:

A.

Wrap the query in a User-Defined Function (UDF) to match syntax execution.


B.

Assign everyone on the sales team to the same virtual warehouse.


C.

Assign everyone on the sales team to the same security role.


D.

Leverage the CURRENT_DATE function for date calculations.


Expert Solution
Questions # 13:

A company has many users assigned to the ANALYST role who regularly query Snowflake through a reporting tool. The Administrator observes that the ANALYST users continuously keep two small clusters busy and occasionally require three or four clusters of that same size.

B. ased on this scenario, how should the Administrator configure a virtual warehouse to MOST efficiently support this user group?

Options:

A.

Create a multi-cluster warehouse with MIN_CLUSTERS set to 1. Give MANAGE privileges to the ANALYST role so this group can start and stop the warehouse, and increase the number of clusters as needed.


B.

Create a multi-cluster warehouse with MIN_CLUSTERS set to 2. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role. Allow the warehouse to auto-scale.


C.

Create a standard X-Large warehouse, which is equivalent to four small clusters. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role.


D.

Create four virtual warehouses (sized Small through XL) and set them to auto-suspend and auto-resume. Have users in the ANALYST role select the appropriate warehouse based on how many queries are being run.


Expert Solution
Questions # 14:

What are the advantages of using Snowflake organizations?

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


Expert Solution
Questions # 15:

A user has enrolled in multi-factor authentication (MFA) to connect to Snowflake. The user tells the Snowflake Administrator that they lost their mobile phone the prior evening.

Which action should the Administrator take to enable the user to sign in to the system without revoking the user’s MFA enrollment?

Options:

A.

Alter the user and set MINS_TO_BYPASS_MFA to a value that will disable MFA long enough for the user to log in.


B.

Alter the user and set DISABLE_MFA to true, which will suspend the MFA requirement for 24 hours.


C.

Instruct the user to connect to Snowflake using SnowSQL, which does not support MFA authentication.


D.

Instruct the user to append the normal URL with /?mode=mfa_bypass & code= to log on.


Expert Solution
Questions # 16:

Which responsibility belongs to the SECURITYADMIN role but is not granted to the USERADMIN role?

Options:

A.

Reset a Snowflake user's password


B.

Manage system grants


C.

Create new users


D.

Create new roles


Expert Solution
Questions # 17:

In general, monthly database-replication billing is proportional to which variables?

Choose 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


Expert Solution
Questions # 18:

Which roles or security privileges allow a consumer account to request and receive data from the Data Exchange?

Choose two

Options:

A.

SYSADMIN


B.

SECURITYADMIN


C.

ACCOUNTADMIN


D.

IMPORT SHARE and CREATE DATABASE


E.

IMPORT PRIVILEGES and SHARED DATABASE


Expert Solution
Viewing page 2 out of 2 pages
Viewing questions 11-20 out of questions