Practice SnowPro-Advanced-Architect Exam Online

Question 1

An Architect needs to meet a company requirement to ingest files from the company's AWS storage accounts into the company's Snowflake Google Cloud Platform (GCP) account. How can the ingestion of these files into the company's Snowflake account be initiated? (Select TWO).

A :

Configure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.

B :

Configure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 Glacier storage.

C :

Create an AWS Lambda function to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.

D :

Configure AWS Simple Notification Service (SNS) to notify Snowpipe when new files have arrived in Amazon S3 storage.

E :

Configure the client application to issue a COPY INTO command to Snowflake when new files have arrived in Amazon S3 Glacier storage.

Answer: A,C

Question 2

An Architect is designing a data lake with Snowflake. The company has structured, semi-structured, and unstructured data. The company wants to save the data inside the data lake within the Snowflake system. The company is planning on sharing data among its corporate branches using Snowflake data sharing. What should be considered when sharing the unstructured data within Snowflake?

A :

A pre-signed URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with no time limit for the URL.

B :

A scoped URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with a 24-hour time limit for the URL.

C :

A file URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with a 7-day time limit for the URL.

D :

A file URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with the "expiration_time" argument defined for the URL time limit.

Answer: B

Question 3

Which statement is not true about shared database?

A : Shared databases are read only

B : Shared databases cannot be cloned

C : Time travel is not supported on a shared database

D : Shared databases can be re-shared with other accounts

Answer: D

Question 4

At which object type level can the APPLY MASKING POLICY, APPLY ROW ACCESS POLICY and APPLY SESSION POLICY privileges be granted?

Name:	SnowPro Advanced, Architect
Exam Code:	SnowPro-Advanced-Architect
Certification:	SnowPro Certification
Vendor:	Snowflake
Total Questions:	442
Last Updated:	Apr 23, 2024

Snowflake SnowPro-Advanced-Architect