ARA-R01 試験問題を無料オンラインアクセス

A company is trying to Ingest 10 TB of CSV data into a Snowflake table using Snowpipe as part of Its migration from a legacy database platform. The records need to be ingested in the MOST performant and cost-effective way.
How can these requirements be met?

• A.Use ON_ERROR = continue in the copy into command.
• B.Use purge = TRUE in the copy into command.
• C.Use FURGE = FALSE in the copy into command.
• D.Use on error = SKIP_FILE in the copy into command.

An Architect would like to save quarter-end financial results for the previous six years.
Which Snowflake feature can the Architect use to accomplish this?

• A.Materialized view
• B.Secure views
• C.Zero-copy cloning
• D.Time Travel
• E.Search optimization service

A Snowflake Architect is designing a multi-tenant application strategy for an organization in the Snowflake Data Cloud and is considering using an Account Per Tenant strategy.
Which requirements will be addressed with this approach? (Choose two.)

• A.Security and Role-Based Access Control (RBAC) policies must be simple to configure.
• B.There needs to be fewer objects per tenant.
• C.Storage costs must be optimized.
• D.Tenant data shape may be unique per tenant.
• E.Compute costs must be optimized.

What considerations need to be taken when using database cloning as a tool for data lifecycle management in a development environment? (Select TWO).

• A.The clone inherits all granted privileges of all child objects in the source object, including the database.
• B.Any pipes in the source referring to external stages are not cloned.
• C.Any pipes in the source referring to internal stages are not cloned.
• D.Any pipes in the source are not cloned.
• E.The clone inherits all granted privileges of all child objects in the source object, excluding the database.

What built-in Snowflake features make use of the change tracking metadata for a table? (Choose two.)

• A.The MERGE command
• B.The CHANGE_DATA_CAPTURE command
• C.A STREAM object
• D.The UPSERT command
• E.The CHANGES clause