nerdexam
Snowflake

ADA-C01 · Question #67

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…

The correct answer is B. A secure view with a column for pre-signed URLs. 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.

Data Sharing and Collaboration

Question

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?

Options

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

How the community answered

(34 responses)
  • A
    3% (1)
  • B
    71% (24)
  • C
    18% (6)
  • D
    9% (3)

Explanation

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.

Topics

#pre-signed URLs#secure views#file sharing#unstructured data

Community Discussion

No community discussion yet for this question.

Full ADA-C01 Practice