support@Free-Braindumps.com
Register Login
Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  1. Home
  2. Exams
  3. Snowflake
  4. SnowPro Advanced Administrator

Snowflake SnowPro Advanced Administrator Exam Actual Questions
SnowPro Advanced Administrator ADA-C01 (Page 2 )

Updated On: 19-Jul-2026
Page 2 of 17
PDF with 65 Questions

When a role is dropped, which role inherits ownership of objects owned by the dropped role?

  1. The SYSADMIN role
  2. The role above the dropped role in the RBAC hierarchy
  3. The role executing the command
  4. The SECURITYADMIN role

Answer(s): B

Explanation:

According to the Snowflake documentation1, when a role is dropped, ownership of all objects owned by the dropped role is transferred to the role that is directly above the dropped role in the role hierarchy. This is to ensure that there is always a single owner for each object in the system.
1: Drop Role | Snowflake Documentation



.

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?

  1. A secure view with a column for file URLs.
  2. A secure view with a column for pre-signed URLs.
  3. A secure view with a column for METADATA$FILENAME.
  4. A secure view with a column for the stage name and a column for the file path.

Answer(s): B

Explanation:

According to the Snowflake documentation1, pre-signed URLs are required to access external files in a share. A secure view can be used to generate pre-signed URLs for the audio files stored in an external stage and expose them to the consumer account. Option A is incorrect because file URLs alone are not sufficient to access external files in a share. Option C is incorrect because METADATA$FILENAME only returns the file name, not the full path or URL. Option D is incorrect because the stage name and file path are not enough to generate pre-signed URLs.



A retailer uses a TRANSACTIONS table (100M rows, 1.2 TB) that has been clustered by the STORE_ID column (varchar(50)). The vast majority of analyses on this table are grouped by STORE_ID to look at store performance.

There are 1000 stores operated by the retailer but most sales come from only 20 stores. The Administrator notes that most queries are currently experiencing poor pruning, with large amounts of bytes processed by even simple queries.

Why is this occurring?

  1. The STORE_ID should be numeric.
  2. The table is not big enough to take advantage of the clustering key.
  3. Sales across stores are not uniformly distributed.
  4. The cardinality of the stores to transaction count ratio is too low to use the STORE_ID as a clustering key.

Answer(s): C

Explanation:

According to the Snowflake documentation1, clustering keys are most effective when the data is evenly distributed across the key values. If the data is skewed, such as in this case where most sales come from only 20 stores out of 1000, then the micro-partitions will not be well-clustered and the pruning will be poor. This means that more bytes will be scanned by queries, even if they filter by STORE_ID. Option A is incorrect because the data type of the clustering key does not affect the pruning. Option B is incorrect because the table is large enough to benefit from clustering, if the data was more balanced. Option D is incorrect because the cardinality of the clustering key is not relevant for pruning, as long as the key values are distinct.
1: Considerations for Choosing Clustering for a Table | Snowflake Documentation



A team is provisioning new lower environments from the production database using cloning. All production objects and references reside in the database, and do not have external references.

What set of object references needs to be re-pointed before granting access for usage?

  1. Sequences, views, and secure views
  2. Sequences, views, secure views, and materialized views
  3. Sequences, storage integrations, views, secure views, and materialized views
  4. There are no object references that need to be re-pointed

Answer(s): C

Explanation:

According to the Snowflake documentation1, when an object in a schema is cloned, any future grants defined for this object type in the schema are applied to the cloned object unless the COPY GRANTS option is specified in the CREATE statement for the clone operation. However, some objects may still reference the source object or external objects after cloning, which may cause issues with access or functionality. These objects include:
· Sequences: If a table column references a sequence that generates default values, the cloned table may reference the source or cloned sequence, depending on where the sequence is defined. To avoid conflicts, the sequence reference should be re-pointed to the desired sequence using the ALTER TABLE command2.
· Storage integrations: If a stage or a table references a storage integration, the cloned object may still reference the source storage integration, which may not be accessible or valid in the new environment. To avoid errors, the storage integration reference should be re-pointed to the desired storage integration using the ALTER STAGE or ALTER TABLE command34. · Views, secure views, and materialized views: If a view references another view or table, the cloned view may still reference the source object, which may not be accessible or valid in the new environment. To avoid errors, the view reference should be re-pointed to the desired object using the CREATE OR REPLACE VIEW command5.
1: Cloning Considerations | Snowflake Documentation 2: [ALTER TABLE | Snowflake Documentation]
3: [ALTER STAGE | Snowflake Documentation] 4: [ALTER TABLE | Snowflake Documentation] 5:
[CREATE VIEW | Snowflake Documentation]



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

  1. Reset a Snowflake user's password
  2. Manage system grants
  3. Create new users
  4. Create new roles

Answer(s): B

Explanation:

According to the Snowflake documentation1, the SECURITYADMIN role is responsible for managing all grants on objects in the account, including system grants. The USERADMIN role can only create and manage users and roles, but not grant privileges on other objects. Therefore, the function that is unique to the SECURITYADMIN role is to manage system grants. Option A is incorrect because both roles can reset a user's password. Option C is incorrect because both roles can create new users. Option D is incorrect because both roles can create new roles.



  PDF
Viewing page 2 of 17
Viewing questions 6 - 10 out of 65 questions


Post your Comments and Discuss Snowflake SnowPro Advanced Administrator exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!