Snowflake ADA-C01 Exam Dumps

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

• The SYSADMIN role
• The role above the dropped role in the RBAC hierarchy
• The role executing the command
• The SECURITYADMIN role

.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 furtheranalysis.Company A's Administrator created a share.What object should be added to the share to allow Company B access to the files?

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

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

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

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 haveexternal references.What set of object references needs to be re-pointed before granting access for usage?

• Sequences, views, and secure views
• Sequences, views, secure views, and materialized views
• Sequences, storage integrations, views, secure views, and materialized views
• There are no object references that need to be re-pointed

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

• Reset a Snowflake user's password
• Manage system grants
• Create new users
• Create new roles