ARA-C01 無料問題集「Snowflake SnowPro Advanced Architect Certification」

（A）SECURITYADMIN, USER with PRIVILEGE

（B）ACCOUNTADMIN, USER with PRIVILEGE

（C）SYSADMIN, SECURITYADMIN

（D）ACCOUNTADMIN, SECURITYADMIN

（A）Syntax error line 1 at position 58 unexpected 'at'.

（B）The offset -> is not a valid clause in the clone operation.

（C）Table T_SALES_CLONE successfully created.

（D）Time Travel data is not available for table T_SALES.

（A）Create a stored procedure that runs with owner's rights and grant usage to order_admin.

（B）This is not possible without DELETE privileges.

（C）Create a stored procedure with caller's rights.

（D）Create a stored procedure with selectable caller/owner rights.

（A）1) In the Production account, create an external function that connects into the QA account and returns all the data for one specific table2) Run the external function as part of a stored procedure that loops through each table in the Production account and populates each table in the QA account

（B）1) Create a share in the Production account for each database2) Share access to the QA account as a Consumer3) The QA account creates a database directly from each share4) Create clones of those databases on a nightly basis5) Run tests directly on those cloned databases

（C）1) Create a stage in the Production account2) Create a stage in the QA account that points to the same external object-storage location3) Create a task that runs nightly to unload each table in the Production account into the stage4) Use Snowpipe to populate the QA account

（D）1) Enable replication for each database in the Production account2) Create replica databases in the QA account3) Create clones of the replica databases on a nightly basis4) Run tests directly on those cloned databases

（A）The new column is automatically included in the search access path, but there is a time delay before it takes effect.

（B）The search optimization property needs to be dropped and then added back for the changes to take effect.

（C）The new column has a data type that is not supported by the search optimization service.

（D）The ON clause was used when enabling the search optimization service, which does not automatically include new columns.

（A）Choose cluster columns that are actively used in the GROUP BY clauses.

（B）Choose columns that are frequently used in join predicates.

（C）Choose TIMESTAMP columns with nanoseconds for the highest number of unique rows.

（D）Choose lower cardinality columns to support clustering keys and cost effectiveness.

（E）Choose cluster columns that are most actively used in selective filters.

（A）Temporary table

（B）Transient table

（C）External tables

（D）Permanent table

（E）Internal stages

（A）A file URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with the "expiration_time" argument defined for the URL time limit.

（B）A scoped URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with a 24-hour time limit for the URL.

（C）A pre-signed URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with no time limit for the URL.

（D）A file URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with a 7-day time limit for the URL.