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

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

Add to Whishlist

List of questions

Question 41

Report Export Collapse

A Snowflake user runs a complex SQL query on a dedicated virtual warehouse that reads a large amount of data from micro-partitions. The same user wants to run another query that uses the same data set.

Which action would provide optimal performance for the second SQL query?

Assign additional clusters to the virtual warehouse.
Assign additional clusters to the virtual warehouse.
Increase the STATEMENT_TIMEOUT_IN_SECONDS parameter in the session.
Increase the STATEMENT_TIMEOUT_IN_SECONDS parameter in the session.
Prevent the virtual warehouse from suspending between the running of the first and second queries.
Prevent the virtual warehouse from suspending between the running of the first and second queries.
Use the RESULT_SCAN function to post-process the output of the first query.
Use the RESULT_SCAN function to post-process the output of the first query.
Suggested answer: D
Explanation:

According to the Using Persisted Query Results documentation, the RESULT_SCAN function allows you to query the result set of a previous command as if it were a table. This can improve the performance of the second query by avoiding reading the same data from micro-partitions again. The other actions do not provide optimal performance for the second query because:

* Assigning additional clusters to the virtual warehouse does not affect the data access speed, but only the query execution speed. It also increases the cost of the warehouse.

* Increasing the STATEMENT_TIMEOUT_IN_SECONDS parameter in the session does not improve the performance of the query, but only allows it to run longer before timing out. It also increases the risk of resource contention and deadlock.

* Preventing the virtual warehouse from suspending between the running of the first and second queries does not guarantee that the data will be cached in memory, as Snowflake uses a least recently used (LRU) cache eviction policy. It also increases the cost of the warehouse.

https://docs.snowflake.com/en/user-guide/querying-persisted-results

asked 23/09/2024
Mohamed Hany
46 questions

Question 42

Report Export Collapse

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

The account_level policy will override the user_level policy.
The account_level policy will override the user_level policy.
The user_level policy will override the account_level policy.
The user_level policy will override the account_level policy.
The user_level network policies will not be supported.
The user_level network policies will not be supported.
A network policy error will be generated with no definitions provided.
A network policy error will be generated with no definitions provided.
Suggested answer: B
Explanation:

According to the Network Policies documentation, a network policy can be applied to an account, a security integration, or a user. If there are network policies applied to more than one of these, the most specific network policy overrides more general network policies. The following summarizes the order of precedence:

* Account: Network policies applied to an account are the most general network policies. They are overridden by network policies applied to a security integration or user.

* Security Integration: Network policies applied to a security integration override network policies applied to the account, but are overridden by a network policy applied to a user.

* User: Network policies applied to a user are the most specific network policies. They override both accounts and security integrations.

Therefore, if both the account_level and user_level network policies are defined, the user_level policy will take effect and the account_level policy will be ignored. The other options are incorrect because:

* The account_level policy will not override the user_level policy, as explained above.

* The user_level network policies will be supported, as they are part of the network policy feature.

* A network policy error will not be generated, as there is no conflict between the account_level and user_level network policies.

asked 23/09/2024
shafinaaz hossenny
41 questions

Question 43

Report Export Collapse

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

Become a Premium Member for full access
  Unlock Premium Member

Question 44

Report Export Collapse

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

Become a Premium Member for full access
  Unlock Premium Member

Question 45

Report Export Collapse

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

Become a Premium Member for full access
  Unlock Premium Member

Question 46

Report Export Collapse

A Snowflake Administrator needs to persist all virtual warehouse configurations for auditing and backups. Given a table already exists with the following schema:

Table Name : VWH_META

Column 1 : SNAPSHOT_TIME TIMESTAMP_NTZ

Column 2 : CONFIG VARIANT

Which commands should be executed to persist the warehouse data at the time of execution in JSON format in the table VWH META?

Become a Premium Member for full access
  Unlock Premium Member

Question 47

Report Export Collapse

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

Become a Premium Member for full access
  Unlock Premium Member

Question 48

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 49

Report Export Collapse

What roles or security privileges will allow a consumer account to request and get data from the Data Exchange? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 50

Report Export Collapse

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?

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?