[Q39-Q62] The Best Valid ADA-C01 Dumps for Helping Passing ADA-C01 Exam!

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

The ALTER DATABASE … ENABLE REPLICATION TO ACCOUNTS command must be issued from the primary account.

Users must be granted REPLICATIONADMIN privileges in order to enable replication.

To start replication run the ALTER DATABASE … REFRESH command on the account where the secondary database resides.

Replication can only occur within the same cloud provider.

Databases created from shares can be replicated.

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.

NEW QUESTION 40
What are the MINIMUM grants required on the database, schema, and table for a stream to be properly created and managed?

Database: Usage
Schema: Usage
Table: Select, Create Stream

Database: Usage
Schema: Usage
Table: Select

Database: Usage, Create Stream
Schema: Usage
Table: Select

Database: Usage
Schema: Usage, Create Stream
Table: Select

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

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

The account name is immutable and cannot be changed.

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

The account name must be unique among all Snowflake customers.

The account name must be unique within the organization.

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

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

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

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

User administration is simplified across all accounts within the organization.

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

NEW QUESTION 43
An Administrator wants to delegate the administration of a company’s data exchange to users who do not have access to the ACCOUNTADMIN role.
How can this requirement be met?

Grant imported privileges on data exchange EXCHANGE_NAME to ROLE_NAME;

Grant modify on data exchange EXCHANGE_NAME to ROLE_NAME;

Grant ownership on data exchange EXCHANGE_NAME to ROLE NAME;

Grant usage on data exchange EXCHANGE_NAME to ROLE_NAME;

NEW QUESTION 44
Which command can temporarily disable Multi-factor Authentication (MFA) for the Snowflake username user1 for 24 hours?

alter user userl set MINS_TO_BYPASS_MFA=1440;

alter user userl set DISABLE_MFA=1440;

alter user userl set TEMPORARY_MFA_BYPASS=1440;

alter user userl set HOURS_TO_BYPASS_MFA=24;

NEW QUESTION 45
.
Company A uses Snowflake to manage audio files of call recordings. Company A hired Company B, who also uses Snowflake, to transcribe the audio files for further analysis.
Company A’s Administrator created a share.
What object should be added to the share to allow Company B access to the files?

A secure view with a column for file URLs.

A secure view with a column for pre-signed URLs.

A secure view with a column for METADATA$FILENAME.

A secure view with a column for the stage name and a column for the file path.

NEW QUESTION 46
Which actions are considered breaking changes to data that is shared with consumers in the Snowflake Marketplace? (Select TWO).

Dropping a column from a table

Deleting data from a table

Unpublishing the data listing

Renaming a table

Adding region availability to the listing

NEW QUESTION 47
A user has enrolled in Multi-factor Authentication (MFA) for connecting to Snowflake. The user informs the Snowflake Administrator that they lost their mobile phone the previous evening.
Which step should the Administrator take to allow the user to log in to the system, without revoking their MFA enrollment?

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

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

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

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

NEW QUESTION 48
Which function is the role SECURITYADMIN responsible for that is not granted to role USERADMIN?

Reset a Snowflake user’s password

Manage system grants

Create new users

Create new roles

NEW QUESTION 49
What session parameter can be used to test the integrity of secure views based on the account that is accessing that view?

MIMIC_CONSUMER_ACCOUNT

TEST_ACCOUNT_ID

PRODUCER_TEST_ACCT

SIMULATED_DATA_SHARING_CONSUMER

NEW QUESTION 50
A requirement has been identified to allow members of a corporate Data Product team to bring in data sets from the Snowflake Marketplace. The members of this team use the role DP_TEAM.
What grant statements must the ACCOUNTADMIN execute in order for the DP TEAM role to import and work with data from the Marketplace?

grant marketplace in account to role dp_team;
grant create database from share to role dp_team;

grant usage on snowflake_marketplace to role dp_team;
grant create database on account to role dp_team;

grant imported privileges on account to role dp_team;
grant create database on account to role dp_team;

grant import share on account to role dp_team;
grant create database on account to role dp_team;

NEW QUESTION 51
An Administrator has a table named SALES_DATA which needs some edits, but the Administrator does not want to change the main table data. The Administrator decides to make a transient copy of this table and wants the transient table to have all the same permissions as the original table.
How can the Administrator create the transient table so it inherits the same permissions as the original table, and what considerations need to be made concerning the requirements? (Select TWO).

Use the following SQL command:
create transient table TRANSIENT_SALES_DATA as select * from SALES_DATA;

Use the following SQL command:
create transient table TRANSIENT SALES DATA as select * from SALES_DATA copy grants;

Use the following SQL commands:
create transient table TRANSIENT_SALES_DATA like SALES_DATA copy grants; insert into TRANSIENT_SALES_DATA select * from SALES_DATA;

Transient tables will persist until explicitly dropped and contribute to overall storage costs.

Transient tables will be purged at the end of the user session and do not have any Fail-safe period.

NEW QUESTION 52
A data provider wants to share data from multiple databases with a data consumer account.
How can this be accomplished?

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

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

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

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.

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

Stages

Users

Warehouses

Roles

Shares

NEW QUESTION 54
A company has implemented Snowflake replication between two Snowflake accounts, both of which are running on a Snowflake Enterprise edition. The replication is for the database APP_DB containing only one schema, APP_SCHEMA. The company’s Time Travel retention policy is currently set for 30 days for both accounts. An Administrator has been asked to extend the Time Travel retention policy to 60 days on the secondary database only.
How can this requirement be met?

Set the data retention policy on the secondary database to 60 days.

Set the data retention policy on the schemas in the secondary database to 60 days.

Set the data retention policy on the primary database to 30 days and the schemas to 60 days.

Set the data retention policy on the primary database to 60 days.

NEW QUESTION 55
A company has set up a new Snowflake account. An Identity Provider (IdP) has been configured for both Single Sign-On (SSO) and SCIM provisioning.
What maintenance is required to ensure that the SCIM provisioning process continues to operate without errors?

The IdP service account requires a new RSA key pair to be generated every six months.

The Administrator must issue a POST RENEW call to the REST API at least once every six months.

The OAuth Bearer Tokens have a lifespan of six months and must be regenerated prior to expiration.

The IdP Administrator must issue a REFRESH transaction at least once every six months to synchronize all users and roles.

NEW QUESTION 56
What is required for stages, without credentials, to limit data exfiltration after a storage integration and associated stages are created?

ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = true;
ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = true;
ALTER ACCOUNT my_account SET
PREVENT_UNLOAD_TO_INLINE_URL = false;

ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = false;
ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = false;
ALTER ACCOUNT my_account SET
PREVENT_UNLOAD_TO_INLINE_URL = true;

ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = false;
ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = false;
ALTER ACCOUNT my_account SET
PREVENT_UNLOAD_TO_INLINE_URL = false;

ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = true;
ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION FOR STAGE_OPERATION = true;
ALTER ACCOUNT my_account SET
PREVENT_UNLOAD_TO_INLINE_URL = true;

NEW QUESTION 57
The following SQL command was executed:
Use role SECURITYADMIN;
Grant ownership
On future tables
In schema PROD. WORKING
To role PROD_WORKING_OWNER;
Grant role PROD_WORKING_OWNER to role SYSADMIN;
Use role ACCOUNTADMIN;
Create table PROD.WORKING.XYZ (value number) ;
Which role(s) can alter or drop table XYZ?

Because ACCOUNTADMIN created the table, only the ACCOUNTADMIN role can alter or drop table XYZ.

SECURITYADMIN, SYSADMIN, and ACCOUNTADMIN can alter or drop table XYZ.

PROD_WORKING_OWNER, ACCOUNTADMIN, and SYSADMIN can alter or drop table XYZ.

Only the PROD_WORKING_OWNER role can alter or drop table XYZ.

NEW QUESTION 58
Which masking policy will mask a column whenever it is queried through a view owned by a role named MASKED_VIEW_ROLE?

create or replace masking policy maskstring as (val string) returns string -> case when is_role_in_session (‘MASKED_VIEW_ROLE’) then ‘ ** else val end;
*,

create or replace masking policy maskString as (val string) returns string -> case when array_contains (‘MASKED_VIEW_ROLE’ :: variant, parse_json (current_available_roles ())) then
‘*
else val
end;
** ‘

create or replace masking policy maskstring as (val string) returns string -> case when invoker_role() in (‘MASKED_VIEW_ROLE’) then else val end;
‘ **

create or replace masking policy maskString as (val string) returns string -> case when current_role() in (‘MASKED_VIEW_ROLE’) then ‘ ********* ‘ else val end;

NEW QUESTION 59
An Administrator has a user who needs to be able to suspend and resume a task based on the current virtual warehouse load, but this user should not be able to modify the task or start a new run.
What privileges should be granted to the user to meet these requirements? (Select TWO).

EXECUTE TASK on the task

OWNERSHIP on the task

OPERATE on the task

USAGE on the database and schema containing the task

OWNERSHIP on the database and schema containing the task

NEW QUESTION 60
An organization’s sales team leverages this Snowflake query a few times a day:
SELECT CUSTOMER ID, CUSTOMER_NAME, ADDRESS, PHONE NO
FROM CUSTOMERS
WHERE LAST UPDATED BETWEEN TO_DATE (CURRENT_TIMESTAMP) AND (TO_DATE
(CURRENT_TIMESTAMP) -7);
What can the Snowflake Administrator do to optimize the use of persisted query results whenever possible?

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

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

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

Leverage the CURRENT_DATE function for date calculations.

NEW QUESTION 61
A Snowflake customer is experiencing higher costs than anticipated while migrating their data warehouse workloads from on-premises to Snowflake. The migration workloads have been deployed on a single warehouse and are characterized by a large number of small INSERTs rather than bulk loading of large extracts. That single warehouse has been configured as a single cluster, 2XL because there are many parallel INSERTs that are scheduled during nightly loads.
How can the Administrator reduce the costs, while minimizing the overall load times, for migrating data warehouse history?

There should be another 2XL warehouse deployed to handle a portion of the load queries.

The 2XL warehouse should be changed to 4XL to increase the number of threads available for parallel load queries.

The warehouse should be kept as a SMALL or XSMALL and configured as a multi-cluster warehouse to handle the parallel load queries.

The INSERTS should be converted to several tables to avoid contention on large tables that slows down query processing.

NEW QUESTION 62
If the query matches the definition, will Snowflake always dynamically rewrite the query to use a materialized view?

No, because joins are not supported by materialized views.

No, because the optimizer might decide against it.

No, because the materialized view may not be up-to-date.

Yes, because materialized views are always faster.

Premium VCE Dumps

Premium VCE Dumps

[Q39-Q62] The Best Valid ADA-C01 Dumps for Helping Passing ADA-C01 Exam!

Leave a Reply Cancel reply