ExamGecko
Login
Home / Snowflake / ADA-C01 / List of questions
Ask Question

Snowflake ADA-C01 Practice Test - Questions Answers, Page 6

List of questions

Question 51

Report
Export
Collapse

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 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 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 30 days and the schemas to 60 days.
Set the data retention policy on the primary database to 60 days.
Set the data retention policy on the primary database to 60 days.
Suggested answer: A

Explanation:

According to the Replication considerations documentation, the Time Travel retention period for a secondary database can be different from the primary database. The retention period can be set at the database, schema, or table level using the DATA_RETENTION_TIME_IN_DAYS parameter. Therefore, to extend the Time Travel retention policy to 60 days on the secondary database only, the best option is to set the data retention policy on the secondary database to 60 days using the ALTER DATABASE command. The other options are incorrect because:

* B. Setting the data retention policy on the schemas in the secondary database to 60 days will not affect the database-level retention period, which will remain at 30 days. The most specific setting overrides the more general ones, so the schema-level setting will apply to the tables in the schema, but not to the database itself.

* C. Setting the data retention policy on the primary database to 30 days and the schemas to 60 days will not affect the secondary database, which will have its own retention period. The replication process does not copy the retention period settings from the primary to the secondary database, so they can be configured independently.

* D. Setting the data retention policy on the primary database to 60 days will not affect the secondary database, which will have its own retention period. The replication process does not copy the retention period settings from the primary to the secondary database, so they can be configured independently.

asked 23/09/2024
Ravi Bhatt
28 questions

Question 52

Report
Export
Collapse

When does auto-suspend occur for a multi-cluster virtual warehouse?

When there has been no activity on any cluster for the specified period of time.
When there has been no activity on any cluster for the specified period of time.
After a specified period of time when an additional cluster has started on the maximum number of clusters specified for a warehouse.
After a specified period of time when an additional cluster has started on the maximum number of clusters specified for a warehouse.
When the minimum number of clusters is running and there is no activity for the specified period of time.
When the minimum number of clusters is running and there is no activity for the specified period of time.
Auto-suspend does not apply for multi-cluster warehouses.
Auto-suspend does not apply for multi-cluster warehouses.
Suggested answer: C

Explanation:

According to the Multi-cluster Warehouses documentation, auto-suspend is a feature that allows a warehouse to automatically suspend itself after a specified period of inactivity. For a multi-cluster warehouse, auto-suspend applies to the entire warehouse, not to individual clusters. Therefore, auto-suspend occurs when the minimum number of clusters is running and there is no activity for the specified period of time. The other options are incorrect because:

* A. Auto-suspend does not occur when there has been no activity on any cluster for the specified period of time. This would imply that each cluster has its own auto-suspend timer, which is not the case. The warehouse has a single auto-suspend timer that is reset by any activity on any cluster.

* B. Auto-suspend does not occur after a specified period of time when an additional cluster has started on the maximum number of clusters specified for a warehouse. This would imply that the auto-suspend timer is affected by the number of clusters running, which is not the case. The auto-suspend timer is only affected by the activity on the warehouse, regardless of the number of clusters running.

* D. Auto-suspend does apply for multi-cluster warehouses, as explained above. It is a feature that can be enabled or disabled for any warehouse, regardless of the number of clusters.

asked 23/09/2024
Ragul Ponniah
41 questions

Question 53

Report
Export
Collapse

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 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 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 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.
The IdP Administrator must issue a REFRESH transaction at least once every six months to synchronize all users and roles.
Suggested answer: C

Explanation:

According to the Snowflake documentation1, the authentication process for SCIM provisioning uses an OAuth Bearer token and this token is valid for six months. Customers must keep track of their authentication token and can generate a new token on demand. If the token expires, the SCIM provisioning process will fail. Therefore, the token must be regenerated before it expires. The other options are not required for SCIM provisioning.

asked 23/09/2024
Karthika Aravinth
33 questions

Question 54

Report
Export
Collapse

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

Become a Premium Member for full access
  Unlock Premium Member

Question 55

Report
Export
Collapse

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 Database A. 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).

Become a Premium Member for full access
  Unlock Premium Member

Question 56

Report
Export
Collapse

An Administrator has a warehouse which is intended to have a credit quota set for 3000 for each calendar year. The Administrator needs to create a resource monitor that will perform the following tasks:

1. At 80% usage notify the account Administrators.

2. At 100% usage suspend the warehouse and notify the account Administrators.

3. At 120% stop all running executions, suspend the warehouse, and notify the account Administrators.

Which SQL command will meet these requirements?

Become a Premium Member for full access
  Unlock Premium Member

Question 57

Report
Export
Collapse

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

How can this be accomplished?

Become a Premium Member for full access
  Unlock Premium Member

Question 58

Report
Export
Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 59

Report
Export
Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 60

Report
Export
Collapse

An Administrator receives data from a Snowflake partner. The partner is sharing a dataset that contains multiple secure views. The Administrator would like to configure the data so that only certain roles can see certain secure views.

How can this be accomplished?

Become a Premium Member for full access
  Unlock Premium Member
Total 72 questions
Go to page: of 8
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

In general, the monthly billing for database replication is proportional to which variables? (Select TWO).
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 Snowflake Administrator is investigating why a query is not re-using the persisted result cache. The Administrator found the two relevant queries from the SNOWFLAKE. ACCOUNT_USAGE. QUERY_HISTORY view: Why is the second query re-scanning micro-partitions instead of using the first query's persisted result cache?
A Snowflake Administrator created a role ROLE_MANAGED_ACCESS and a schema SCHEMA_MANAGED_ACCESS as follows: USE ROLE SECURITYADMIN; CREATE ROLE ROLE_MANAGED_ACCESS; GRANT ROLE ROLE_MANAGED_ACCESS TO ROLE SYSADMIN; GRANT USAGE ON WAREHOUSE COMPUTE_WH TO ROLE ROLE_MANAGED_ACCESS; GRANT ALL privileges ON DATABASE WORK TO ROLE ROLE_MANAGED_ACCESS; USE ROLE ROLE_MANAGED_ACCESS; CREATE SCHEMA SCHEMA_MANAGED_ACCESS WITH MANAGED ACCESS; USE ROLE SECURITYADMIN; GRANT SELECT, INSERT ON FUTURE TABLES IN SCHEMA SCHEMA MANAGED ACCESS to ROLE_MANAGED_ACCESS; The Administrator now wants to disable the managed access on the schema. How can this be accomplished?
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?
In which scenario will use of an external table simplify a data pipeline?
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).
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?
Which commands can be performed by a user with the ORGADMIN role but not the ACCOUNTADMIN role? (Select TWO).
A data provider wants to share data from multiple databases with a data consumer account. How can this be accomplished?