Snowflake Exam SnowPro-Core Topic 1 Question 73 Discussion

Actual exam question for Snowflake's SnowPro-Core exam

Question #: 73
Topic #: 1

Which system_defined Snowflake role has permission to rename an account and specify whether the original URL can be used to access the renamed account?

AACCOUNTADMIN

BSECURITYADMIN

CSYSADMIN

DORGADMIN

Show Suggested Answer

Suggested Answer: B

According to the Snowflake documentation1, a directory table stores a catalog of staged files in cloud storage and can be queried to retrieve theSnowflake-hosted file URLto each file in the stage. A file URL has the following format:

https:///api/files/<db_name>.<schema_name>.<stage_name>/<relative_path>

Based on this information, I think the query that contains a Snowflake hosted file URL in a directory table for a stage named bronzestage isB. select * from directory(@bronzestage);

by Delisa at Aug 08, 2023, 04:31 AM

Limited Time Offer

25%

Off

Get Premium SnowPro-Core Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!