Snowflake ARA-R01 問題集

質問 1：
A company needs to have the following features available in its Snowflake account:
1. Support for Multi-Factor Authentication (MFA)
2. A minimum of 2 months of Time Travel availability
3. Database replication in between different regions
4. Native support for JDBC and ODBC
5. Customer-managed encryption keys using Tri-Secret Secure
6. Support for Payment Card Industry Data Security Standards (PCI DSS)
In order to provide all the listed services, what is the MINIMUM Snowflake edition that should be selected during account creation?
A. Standard
B. Enterprise
C. Business Critical
D. Virtual Private Snowflake (VPS)
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
A company is designing its serving layer for data that is in cloud storage. Multiple terabytes of the data will be used for reporting. Some data does not have a clear use case but could be useful for experimental analysis.
This experimentation data changes frequently and is sometimes wiped out and replaced completely in a few days.
The company wants to centralize access control, provide a single point of connection for the end-users, and maintain data governance.
What solution meets these requirements while MINIMIZING costs, administrative effort, and development overhead?
A. Import all the data in cloud storage to be used for reporting into a Snowflake schema with native tables.
Then create two different roles with grants to the different datasets to match the different user personas, and grant these roles to the corresponding users.
B. Import the data used for reporting into a Snowflake schema with native tables. Then create external tables pointing to the cloud storage folders used for the experimentation data. Then create two different roles with grants to the different datasets to match the different user personas, and grant these roles to the corresponding users.
C. Import the data used for reporting into a Snowflake schema with native tables. Then create views that have SELECT commands pointing to the cloud storage files for the experimentation data. Then create two different roles to match the different user personas, and grant these roles to the corresponding users.
D. Import all the data in cloud storage to be used for reporting into a Snowflake schema with native tables.
Then create a role that has access to this schema and manage access to the data through that role.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 3：
A new user user_01 is created within Snowflake. The following two commands are executed:
Command 1-> show grants to user user_01;
Command 2 ~> show grants on user user 01;
What inferences can be made about these commands?
A. Command 1 defines which user owns user_01
Command 2 defines all the grants which have been given to user_01
B. Command 1 defines all the grants which are given to user_01 Command 2 defines which user owns user_01
C. Command 1 defines which role owns user_01
Command 2 defines all the grants which have been given to user_01
D. Command 1 defines all the grants which are given to user_01
Command 2 defines which role owns user 01
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
A Snowflake Architect is designing a multiple-account design strategy.
This strategy will be MOST cost-effective with which scenarios? (Select TWO).
A. The company security policy mandates the use of different Active Directory instances for the development, test, and production environments.
B. The company wants to clone a production database that resides on AWS to a development database that resides on Azure.
C. The company needs to support different role-based access control features for the development, test, and production environments.
D. The company needs to share data between two databases, where one must support Payment Card Industry Data Security Standard (PCI DSS) compliance but the other one does not.
E. The company must use a specific network policy for certain users to allow and block given IP addresses.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
An Architect runs the following SQL query:

How can this query be interpreted?
A. FILEROWS is the table. FILE_ROW_NUMBER is the line number in the table.
B. FILERONS is the file format location. FILE_ROW_NUMBER is a stage.
C. FILEROWS is a file. FILE_ROW_NUMBER is the file format location.
D. FILEROWS is a stage. FILE_ROW_NUMBER is line number in file.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
When using the copy into <table> command with the CSV file format, how does the match_by_column_name parameter behave?
A. The command will return a warning stating that the file has unmatched columns.
B. The parameter will be ignored.
C. It expects a header to be present in the CSV file, which is matched to a case-sensitive table column name.
D. The command will return an error.
正解：B
解説: (Topexam メンバーにのみ表示されます)