Home

Home / Snowflake / ADA-C01

Question list

List of questions

Question 1

(0)

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

Question 2

(0)

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

Question 3

(0)

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

Question 4

(0)

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

Question 5

(0)

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

Question 6

(0)

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

Question 7

(0)

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

Question 8

(0)

The ACCOUNTADMIN of Account 123 works with Snowflake Support to set up a Data Exchange. After the exchange is populated with listings from other Snowflake accounts, hat roles in Account 123 are allo

Question 9

(0)

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 Snowflak

Question 10

(0)

Which type of listing in the Snowflake Marketplace can be added and queried immediately?

Open VPLUS File

Convert VPLUS to PDF

Related questions

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

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 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?

What roles can be used to create network policies within Snowflake accounts? (Select THREE).

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

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

A Snowflake Administrator needs to set up Time Travel for a presentation area that includes facts and dimensions tables, and receives a lot of meaningless and erroneous loT data. Time Travel is being used as a component of the company's data quality process in which the ingestion pipeline should revert to a known quality data state if any anomalies are detected in the latest load. Data from the past 30 days may have to be retrieved because of latencies in the data acquisition process. According to best practices, how should these requirements be met? (Select TWO).

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?

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

How should an Administrator configure a Snowflake account to use AWS PrivateLink?

Question 5 - ADA-C01 discussion

Report

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

A.

No, because joins are not supported by materialized views.

B.

No, because the optimizer might decide against it.

C.

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

D.

Yes, because materialized views are always faster.

Show Answer

asked 23/09/2024

Xiaoyi Wu

38 questions

User

Your answer: A B C D

0 comments

Sorted by

Leave a comment first