最新なSnowflake ARA-C01問題集（162題）、真実試験の問題を全部にカバー！

質問 1：
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 all the grants which are given to user_01 Command 2 defines which role owns user 01
D. Command 1 defines which role owns user_01
Command 2 defines all the grants which have been given to user_01
正解：C
解説: (Pass4Test メンバーにのみ表示されます)

質問 2：
Which of the following ingestion methods can be used to load near real-time data by using the messaging services provided by a cloud provider?
A. Snowflake streams
B. Snowpipe
C. Snowflake Connector for Kafka
D. Spark
正解：C
解説: (Pass4Test メンバーにのみ表示されます)

質問 3：
A table, EMP_ TBL has three records as shown:

The following variables are set for the session:

Which SELECT statements will retrieve all three records? (Select TWO).
A. SELECT * FROM EMP_TBL WHERE identifier(Scol_ref) IN ('Namel','Name2', 'Name3');
B. SELECT * FROM identifier($tbl_ref) WHERE ID IN Cvarl','var2','var3');
C. Select * FROM Stbl_ref WHERE Scol_ref IN ('Name1','Nam2','Name3');
D. SELECT * FROM $tb1_ref WHERE $col_ref IN ($var1, Svar2, Svar3);
E. SELECT * FROM identifier<Stbl_ref> WHERE NAME IN ($var1, $var2, $var3);
正解：A,D
解説: (Pass4Test メンバーにのみ表示されます)

質問 4：
A global company needs to securely share its sales and Inventory data with a vendor using a Snowflake account.
The company has its Snowflake account In the AWS eu-west 2 Europe (London) region. The vendor's Snowflake account Is on the Azure platform in the West Europe region. How should the company's Architect configure the data share?
A. 1. Create a share.
2. Add objects to the share.
3. Add a consumer account to the share for the vendor to access.
B. 1. Create a share.
2. Create a reader account for the vendor to use.
3. Add the reader account to the share.
C. 1. Create a new role called db_share.
2. Grant the db_share role privileges to read data from the company database and schema.
3. Create a user for the vendor.
4. Grant the ds_share role to the vendor's users.
D. 1. Promote an existing database in the company's local account to primary.
2. Replicate the database to Snowflake on Azure in the West-Europe region.
3. Create a share and add objects to the share.
4. Add a consumer account to the share for the vendor to access.
正解：A
解説: (Pass4Test メンバーにのみ表示されます)

質問 5：
A company has a source system that provides JSON records for various loT operations. The JSON Is loading directly into a persistent table with a variant field. The data Is quickly growing to 100s of millions of records and performance to becoming an issue. There is a generic access pattern that Is used to filter on the create_date key within the variant field.
What can be done to improve performance?
A. Validate the size of the warehouse being used. If the record count is approaching 100s of millions, size XL will be the minimum size required to process this amount of data.
B. Alter the target table to include additional fields pulled from the JSON records. This would include a create_date field with a datatype of varchar. When this field is used in the filter, partition pruning will occur.
C. Incorporate the use of multiple tables partitioned by date ranges. When a user or process needs to query a particular date range, ensure the appropriate base table Is used.
D. Alter the target table to Include additional fields pulled from the JSON records. This would Include a create_date field with a datatype of time stamp. When this field Is used in the filter, partition pruning will occur.
正解：D
解説: (Pass4Test メンバーにのみ表示されます)

質問 6：
An Architect for a multi-national transportation company has a system that is used to check the weather conditions along vehicle routes. The data is provided to drivers.
The weather information is delivered regularly by a third-party company and this information is generated as JSON structure. Then the data is loaded into Snowflake in a column with a VARIANT data type. This table is directly queried to deliver the statistics to the drivers with minimum time lapse.
A single entry includes (but is not limited to):
- Weather condition; cloudy, sunny, rainy, etc.
- Degree
- Longitude and latitude
- Timeframe
- Location address
- Wind
The table holds more than 10 years' worth of data in order to deliver the statistics from different years and locations. The amount of data on the table increases every day.
The drivers report that they are not receiving the weather statistics for their locations in time.
What can the Architect do to deliver the statistics to the drivers faster?
A. Divide the table into several tables for each location by using the location address information from the JSON dataset in order to process the queries in parallel.
B. Create an additional table in the schema for longitude and latitude. Determine a regular task to fill this information by extracting it from the JSON dataset.
C. Divide the table into several tables for each year by using the timeframe information from the JSON dataset in order to process the queries in parallel.
D. Add search optimization service on the variant column for longitude and latitude in order to query the information by using specific metadata.
正解：D
解説: (Pass4Test メンバーにのみ表示されます)

質問 7：
A table contains five columns and it has millions of records. The cardinality distribution of the columns is shown below:

Column C4 and C5 are mostly used by SELECT queries in the GROUP BY and ORDER BY clauses. Whereas columns C1, C2 and C3 are heavily used in filter and join conditions of SELECT queries.
The Architect must design a clustering key for this table to improve the query performance.
Based on Snowflake recommendations, how should the clustering key columns be ordered while defining the multi-column clustering key?
A. C2, C1, C3
B. C3, C4, C5
C. C1, C3, C2
D. C5, C4, C2
正解：A
解説: (Pass4Test メンバーにのみ表示されます)

質問 8：
Which command will create a schema without Fail-safe and will restrict object owners from passing on access to other users?
A. create TRANSIENT schema EDW.ACCOUNTING WITH MANAGED ACCESS DATA_RETENTION_TIME_IN_DAYS = 7;
B. create TRANSIENT schema EDW.ACCOUNTING WITH MANAGED ACCESS DATA_RETENTION_TIME_IN_DAYS = 1;
C. create schema EDW.ACCOUNTING WITH MANAGED ACCESS;
D. create schema EDW.ACCOUNTING WITH MANAGED ACCESS DATA_RETENTION_TIME_IN_DAYS - 7;
正解：A
解説: (Pass4Test メンバーにのみ表示されます)