ARA-R01試験無料問題集「Snowflake SnowPro Advanced: Architect Recertification 認定」

A. A row access policy cannot be applied to a view created on top of an external table.

B. A row access policy can be applied to the VALUE column of an existing external table.

C. While cloning a database, both the row access policy and the external table will be cloned.

D. An external table can be created with a row access policy, and the policy can be applied to the VALUE column.

E. External tables are supported as mapping tables in a row access policy.

F. A row access policy cannot be directly added to a virtual column of an external table.

A. Assume role with ALL PRIVILEGES including ADD SEARCH OPTIMIZATION in the SECURITY LOGS schema.

B. Assume role with OWNERSHIP on future tables and ADD SEARCH OPTIMIZATION on the SECURITY_LOGS schema.

C. Assume role with OWNERSHIP on VPN_ACCESS_LOGS and ADD SEARCH OPTIMIZATION in the SECURITY_LOGS schema.

D. Assume role with ALL PRIVILEGES on VPN_ACCESS_LOGS and ADD SEARCH OPTIMIZATION in the SECURITY_LOGS schema.

A. create TRANSIENT schema EDW.ACCOUNTING WITH MANAGED ACCESS
DATA_RETENTION_TIME_IN_DAYS = 1;

B. create TRANSIENT schema EDW.ACCOUNTING WITH MANAGED ACCESS
DATA_RETENTION_TIME_IN_DAYS = 7;

C. create schema EDW.ACCOUNTING WITH MANAGED ACCESS;

D. create schema EDW.ACCOUNTING WITH MANAGED ACCESS
DATA_RETENTION_TIME_IN_DAYS - 7;

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

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

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

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

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

A. The VALIDATION_MODE parameter supports COPY statements that load data from external stages only.

B. The VALIDATION_MODE parameter does not support COPY statements that transform data during a load.

C. The value return_all_errors of the option VALIDATION_MODE is causing a compilation error.

D. The VALIDATION_MODE parameter does not support COPY statements with CSV file formats.

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

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

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

D. Create accounts for each tenant in the Snowflake organization.

A. CREATE SHARE;

B. IMPORT DATABASE;

C. IMPORT SHARE;

D. CREATE DATABASE;

E. IMPORT PRIVILEGES;

A. The MERGE command

B. The CHANGE_DATA_CAPTURE command

C. The CHANGES clause

D. A STREAM object

E. The UPSERT command

A. SCIM must be enabled between the identity provider and Snowflake. Once both are synchronized through SCIM. users will automatically get created and their group membership will be reflected as roles In Snowflake.

B. OAuth must be configured between the identity provider and Snowflake. Then the authorization server must be configured with the right mapping of users and roles.

C. OAuth must be configured between the identity provider and Snowflake. Then the authorization server must be configured with the right mapping of users, and the resource server must be configured with the right mapping of role assignment.

D. SCIM must be enabled between the identity provider and Snowflake. Once both are synchronized through SCIM, their groups will get created as group accounts in Snowflake and the proper roles can be granted.