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

A Snowflake Architect is setting up database replication to support a disaster recovery plan. The primary database has external tables.
How should the database be replicated?

• A.Create a clone of the primary database then replicate the database.
• B.Share the primary database with an account in the same region that the database will be replicated to.
• C.Replicate the database ensuring the replicated database is in the same region as the external tables.
• D.Move the external tables to a database that is not replicated, then replicate the primary database.

Which steps are recommended best practices for prioritizing cluster keys in Snowflake? (Choose two.)

• A.Choose columns that are frequently used in join predicates.
• B.Choose cluster columns that are actively used in the GROUP BY clauses.
• C.Choose TIMESTAMP columns with nanoseconds for the highest number of unique rows.
• D.Choose cluster columns that are most actively used in selective filters.
• E.Choose lower cardinality columns to support clustering keys and cost effectiveness.

The IT Security team has identified that there is an ongoing credential stuffing attack on many of their organization's system.
What is the BEST way to find recent and ongoing login attempts to Snowflake?

• A.View the History tab in the Snowflake UI and set up a filter for SQL text that contains the text
  "LOGIN".
• B.Call the LOGIN_HISTORY Information Schema table function.
• C.View the Users section in the Account tab in the Snowflake UI and review the last login column.
• D.Query the LOGIN_HISTORY view in the ACCOUNT_USAGE schema in the SNOWFLAKE database.

A company has an inbound share set up with eight tables and five secure views. The company plans to make the share part of its production data pipelines.
Which actions can the company take with the inbound share? (Choose two.)

• A.Grant modify permissions on the share.
• B.Create additional views inside the shared database.
• C.Clone a table from a share.
• D.Create a table stream on the shared table.
• E.Create a table from the shared database.

An Architect is troubleshooting a query with poor performance using the QUERY_HIST0RY function. The Architect observes that the COMPILATIONJHME is greater than the EXECUTIONJTIME.
What is the reason for this?

• A.The query is queued for execution.
• B.The query has overly complex logic.
• C.The query is processing a very large dataset.
• D.The query is reading from remote storage.