Free Online Snowflake SnowPro-Advanced-Architect Practice Test

Prepare Your Snowflake SnowPro-Advanced-Architect Exam Questions with Free online SnowPro-Advanced-Architect Practice Test. Get Brilliant SnowPro Advanced, Architect Exam Results with Valid SnowPro Advanced Architect Exam Dumps.

Page: 1 / 89

Total 442 Questions | Updated On: May 16, 2024

Add To Cart

Question 1

create or replace table result_scan_table_1 like result_scan_table;

Will the above query cost compute credits?

A : No, since it is a metadata operation only

B : Yes, it will need compute as the table structure is also getting created

C : It is hard to say without looking at query profile

Answer: A

Question 2

What type of authentication does the Kafka connector use?

A : Username/password requiring a password with numbers, letters, and symbols

B : Username/password requiring a password with numbers and letters

C : Key pair Authentication, which requires a 2048-bit (minimum) RSA key pair

D : Key pair Authentication, which requires a 1024-bit (minimum) RSA key pair

Answer: C

Question 3

Which ALTER commands will impact a column's availability in Time Travel?

A : ALTER TABLE … DROP COLUMN …

B : ALTER TABLE … SET NOT NULL …

C : ALTER TABLE … SET DATA TYPE …

D : ALTER TABLE … RENAME COLUMN …

Answer: C

Question 4

A table is loaded using Snowflake Connector for Kafka.

What will happen if the file cannot be loaded?

A : The Kafka Connector moves files it cannot load to the stage associated with the target table

B : The Kafka Connector moves files it cannot load to the stage associated with the user loading the target table

C : The Kafka Connector loads the files to an error table with the columns RECORD_CONTENT and RECORD_METADATA

D : The Kafka Connector deletes the files that cannot be loaded

Answer: A

Question 5

A Snowflake Architect is designing an application and tenancy strategy for an organization where strong legal isolation rules as well as multi-tenancy are requirements. Which approach will meet these requirements if Role-Based Access Policies (RBAC) is a viable option for isolating tenants?

A : Create accounts for each tenant in the Snowflake organization.

B : Create an object for each tenant strategy if row level security is viable for isolating tenants.

C : Create an object for each tenant strategy if row level security is not viable for isolating tenants.

D : Create a multi-tenant table strategy if row level security is not viable for isolating tenants.

Answer: B

Page: 1 / 89

Total 442 Questions | Updated On: May 16, 2024

Add To Cart