Snowflake ARA-R01 問題集

質問 1：
How can the Snowflake context functions be used to help determine whether a user is authorized to see data that has column-level security enforced? (Select TWO).
A. Set masking policy conditions using is_role_in_session targeting the role in use for the current account.
B. Set masking policy conditions using invoker_role targeting the executing role in a SQL statement.
C. Determine if there are ownership privileges on the masking policy that would allow the use of any function.
D. Set masking policy conditions using current_role targeting the role in use for the current session.
E. Assign the accountadmin role to the user who is executing the object.
正解：B,D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
How can the Snowpipe REST API be used to keep a log of data load history?
A. Call loadHistoryScan every 10 minutes for a 15-minute time range.
B. Call insertReport every 8 minutes for a 10-minute time range.
C. Call loadHistoryScan every minute for the maximum time range.
D. Call insertReport every 20 minutes, fetching the last 10,000 entries.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
An Architect needs to design a Snowflake account and database strategy to store and analyze large amounts of structured and semi-structured data. There are many business units and departments within the company. The requirements are scalability, security, and cost efficiency.
What design should be used?
A. Set up separate Snowflake accounts and databases for each department or business unit, to ensure data isolation and security.
B. Use a centralized Snowflake database for core business data, and use separate databases for departmental or project-specific data.
C. Create a single Snowflake account and database for all data storage and analysis needs, regardless of data volume or complexity.
D. Use Snowflake's data lake functionality to store and analyze all data in a central location, without the need for structured schemas or indexes
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 4：
What is a key consideration when setting up search optimization service for a table?
A. The table must be clustered with a key having multiple columns for effective search optimization.
B. Search optimization service can help to optimize storage usage by compressing the data into a GZIP format.
C. Search optimization service works best with a column that has a minimum of 100 K distinct values.
D. Search optimization service can significantly improve query performance on partitioned external tables.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
What actions are permitted when using the Snowflake SQL REST API? (Select TWO).
A. The use of a PUT command
B. Submitting multiple SQL statements in a single call
C. The use of a GET command
D. The use of a CALL command to a stored procedure which returns a table
E. The use of a ROLLBACK command
正解：C,D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
The following DDL command was used to create a task based on a stream:

Assuming MY_WH is set to auto_suspend - 60 and used exclusively for this task, which statement is true?
A. The warehouse MY_WH will be made active every five minutes to check the stream.
B. The warehouse MY_WH will never suspend.
C. The warehouse MY_WH will only be active when there are results in the stream.
D. The warehouse MY_WH will automatically resize to accommodate the size of the stream.
正解：C
解説: (Topexam メンバーにのみ表示されます)