Practice SnowPro-Advanced-Architect Exam Online

Question 1

Removing files from a stage after you are done loading the files improves performance when subsequently loading data

A : TRUE

B : FALSE

Answer: A

Question 2

COMPRESSION = AUTO can automatically detect below compression techniques when FORMAT TYPE is CSV

A : GZIP

B : BZ2

C : BROTLI

D : ZSTD

E : DEFLATE

F : RAW_DEFLATE

Answer: A,B,D

Question 3

What is the best option to clone a table called MYTABLE?

A : CREATE TABLE MYTABLE_2 AS SELECT * FROM MYTABLE;

B : CREATE TABLE MYTABLE_2 CLONE MYTABLE;

C : CREATE TABLE MYTABLE_2 AS INSERT INTO MYTABLE VALUES (SELECT * FROM MYTABLE);

Answer: B

Question 4

A group of Data Analysts have been granted the role analyst role. They need a Snowflake database where they can create and modify tables, views, and other objects to load with their own data. The Analysts should not have the ability to give other Snowflake users outside of their role access to this data. How should these requirements be met?

A :

Grant ANALYST_R0LE OWNERSHIP on the database, but make sure that ANALYST_ROLE does not have the MANAGE GRANTS privilege on the account.

B :

Grant SYSADMIN ownership of the database, but grant the create schema privilege on the database to the ANALYST_ROLE.

C :

Make every schema in the database a managed access schema, owned by SYSADMIN, and grant create privileges on each schema to the ANALYST_ROLE for each type of object that needs to be created.

D :

Grant ANALYST_ROLE ownership on the database, but grant the ownership on future [object type] s in database privilege to SYSADMIN.

Answer: A

Question 5

When is the parameter INTEGRATION from Snowpipe required?

A : Only when configuring AUTO_INGEST for Google Cloud Storage or Microsoft Azure stages.

B : Only when configuring AUTO_INGEST for Amazon S3 stages using SNS.

C : Only when configuring ERROR_INTEGRATION for Amazon S3 stages using SNS.

D : Only when configuring ERROR_INTEGRATION for Google Cloud Storage or Microsoft Azure stages.

Answer: A

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