Snowflake ADA-C01 Free Sample Exam Questions 2026

Here you can get the actual Snowflake ADA-C01 exam questions and answers in PDF for free and for all questions premium file. These best SnowPro Advanced: Administrator Certification ADA-C01 PDF questions are for every Snowflake users. Real ADA-C01 exam dumps that will assist you to crack the %certification% certification exam in the PDF format. For Advance preparation premium PDF files available for perfect exam preparation on reilable price option.

UNLOCK FULL
ADA-C01 Exam Features

In Just $35 You can Access

• All Official Question Types
• Interactive Web-Based Practice Test Software
• No Installation or 3rd Party Software Required
• Customize your practice sessions (Free Demo)
• 24/7 Customer Support

Get Full Access

Page: 1 / 15
Total Questions: 71

Questions & Answers PDF

• Question 1

  

  A company enabled replication between accounts and is ready to replicate data across regions in the same cloud service provider.The primary database object is : PROD_AWS_EAST. Location : AWS_EAST The secondary database object is : PROD_AWS_WEST. Location : AWS_WESTWhat command and account location is needed to refresh the data?

  • Location : AWS_WESTCommand : REFRESH DATABASE PROD_AWS WEST REFRESH;
  • Location : AWS_WESTCommand : ALTER DATABASE PROD AWS WEST REFRESH;
  • Location : AWS_EASTCommand : REFRESH DATABASE PROD_AWS_WEST REFRESH;
  • Location : AWS EAST
  • Command: ALTER DATABASE PROD_AWS_WEST REFRESH;

  Reveal Answer Answer: A Next Question

• Question 2

  

  An Administrator is evaluating a complex query using the EXPLAIN command. The Globalstats operation indicates 500 partitionsAssigned.The Administrator then runs the query to completion and opens the Query Profile. They notice that the partitions scanned value is 429.Why might the actual partitions scanned be lower than the estimate from the EXPLAIN output?

  • The EXPLAIN results always include a 10-15% safety factor in order to provide conservative estimates.
  • The GlobalStats partition assignment includes the micro-partitions that will be assigned for preservation of the query results.
  • Runtime optimizations such as join pruning can reduce the number of partitions and bytes scanned during query execution.
  • In-flight data compression will result in fewer micro-partitions being scanned at the virtual warehouse layer than were identified at the storage layer.

  Reveal Answer Answer: C Next Question

• Question 3

  

  A Snowflake Administrator has a multi-cluster virtual warehouse and is using the Snowflake Business Critical edition. The minimum number of clusters is set to 2 and themaximum number of clusters is set to 10. This configuration works well for the standard workload, rarely exceeding 5 running clusters. However, once a month theAdministrator notes that there are a few complex long-running queries that are causing increased queue time and the warehouse reaches its maximum limit at 10 clusters.Which solutions will address the issues happening once a month? (Select TWO).

  • Use a task to increase the cluster size for the time period that the more complex queries are running and another task to reduce the size of the cluster once the complex queries complete.
  • Have the group running the complex monthly queries use a separate appropriately-sized warehouse to support their workload.
  • Increase the multi-cluster maximum to 20 or more clusters.
  • Examine the complex queries and determine if they can be made more efficient using clustering keys or materialized views.
  • Increase the minimum number of clusters started in the multi-cluster configuration to 5.

  Reveal Answer Answer: A,B Next Question

• Question 4

  

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

  • A masking policy that is currently set on a table can be dropped.
  • A single masking policy can be applied to columns in different tables.
  • A masking policy can be applied to the VALUE column of an external table.
  • The role that creates the masking policy will always see unmasked data in query results.
  • A single masking policy can be applied to columns with different data types.

  Reveal Answer Answer: B,E Next Question

• Question 5

  

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

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

  Reveal Answer Answer: A Next Question

• Question 6

  

  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

  Reveal Answer Answer: A,D Next Question

• Question 7

  

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

  • Create a view on the customer_data table to eliminate the email column by omitting it from the SELECT clause. Grant the role DEVELOPER access to the view.
  • Create a separate table for all the non-Pll columns and grant the role DEVELOPER access to the new table.
  • Use the CURRENT_ROLE and CURRENT_USER context functions to integrate with a secure view and filter the sensitive data.
  • Use the CURRENT_ROLE context function to integrate with a masking policy on the fields that contain sensitive data.

  Reveal Answer Answer: D Next Question

• Question 8

  

  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 tomake 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 therequirements? (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.

  Reveal Answer Answer: B,D Next Question

• Question 9

  

  A company has many users in the role ANALYST who routinely query Snowflake through a reporting tool. The Administrator has noticed that the ANALYST users keep twosmall clusters busy all of the time, and occasionally they need three or four clusters of that size.Based on this scenario, how should the Administrator set up a virtual warehouse to MOST efficiently support this group of users?

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

  Reveal Answer Answer: B Next Question

• Question 10

  

  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?

  • The second query includes a CURRENT_TIMESTAMP () function.
  • The second query includes a CURRENT_DATE () function.
  • The queries are executed with two different virtual warehouses.
  • The queries are executed with two different roles.

  Reveal Answer Answer: A Next Question

Page: 1 / 15
Total Questions: 71

Previous Page Next Page