ARA-R01 無料問題集「Snowflake SnowPro Advanced: Architect Recertification」

（A）Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were read from the source.

（B）Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were created in the source.

（C）All rows loaded using a specific COPY statement will have varying timestamps based on when the rows were inserted.

（D）All rows loaded using a specific COPY statement will have the same timestamp value.

（A）Stored procedure

（B）Stream

（C）Secure view

（D）Standard view

（E）External table

（A）create schema EDW.ACCOUNTING WITH MANAGED ACCESS;

（B）create TRANSIENT schema EDW.ACCOUNTING WITH MANAGED ACCESS
DATA_RETENTION_TIME_IN_DAYS = 7;

（C）create schema EDW.ACCOUNTING WITH MANAGED ACCESS
DATA_RETENTION_TIME_IN_DAYS - 7;

（D）create TRANSIENT schema EDW.ACCOUNTING WITH MANAGED ACCESS
DATA_RETENTION_TIME_IN_DAYS = 1;

（A）Use the get command in SnowSQL to retrieve the file.

（B）Use the Snowflake API endpoint and download the file.

（C）Use the get command in Snowsight to retrieve the file.

（D）Use the Snowflake Connector for Python, connect to remote storage and download the file.

（A）TEMPORARY

（B）PERMANENT

（C）TRANSIENT

（A）Use a Snowflake task to trigger a stored procedure to copy data.

（B）Use zero-copy cloning into permanent tables.

（C）Use zero-copy cloning into transient tables.

（D）Use CREATE TABLE ... AS SELECT (CTAS) statements.

（A）Build a custom data pipeline using Azure Data Factory or a similar tool to extract the sales data from company B's Snowflake account. Transform the data, then load it into company A's Snowflake account.

（B）Replicate the sales data from company B's Snowflake account into company A's Snowflake account using cross-region data replication within Snowflake. Configure a direct share from company B's account to company A's account.

（C）Migrate company B's Snowflake deployment to the same region as company A's Snowflake deployment, ensuring data locality. Then perform a direct database-to-database merge of the sales data.

（D）Export the sales data from company B's Snowflake account as CSV files, and transfer the files to company A's Snowflake account. Import the data using Snowflake's data loading capabilities.

（A）FILEROWS is a file. FILE_ROW_NUMBER is the file format location.

（B）FILEROWS is a stage. FILE_ROW_NUMBER is line number in file.

（C）FILERONS is the file format location. FILE_ROW_NUMBER is a stage.

（D）FILEROWS is the table. FILE_ROW_NUMBER is the line number in the table.

（A）1) In the Production account, create an external function that connects into the QA account and returns all the data for one specific table
2) 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 stage in the Production account
2) Create a stage in the QA account that points to the same external object-storage location
3) Create a task that runs nightly to unload each table in the Production account into the stage
4) Use Snowpipe to populate the QA account

（C）1) Enable replication for each database in the Production account
2) Create replica databases in the QA account
3) Create clones of the replica databases on a nightly basis
4) Run tests directly on those cloned databases

（D）1) Create a share in the Production account for each database
2) Share access to the QA account as a Consumer
3) The QA account creates a database directly from each share
4) Create clones of those databases on a nightly basis
5) Run tests directly on those cloned databases

（A）Standard

（B）Virtual Private Snowflake (VPS)

（C）Business Critical

（D）Enterprise

（A）SELECT MAX(FLAKE_ID) FROM SNOWFLAKE;

（B）SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY FLAKE_ID;

（C）SELECT COUNT(*) FROM SNOWFLAKE;

（D）SHOW TABLES LIKE 'SNOWFL%';

（A）Security and Role-Based Access Control (RBAC) policies must be simple to configure.

（B）There needs to be fewer objects per tenant.

（C）Tenant data shape may be unique per tenant.

（D）Compute costs must be optimized.

（E）Storage costs must be optimized.

（A）The retention period can be reset for a maximum of 31 days.

（B）Time Travel queries can be executed against the result set cache.

（C）Snowflake persists the data results for 24 hours.

（D）The result set cache is not shared between warehouses.

（E）The data stored in the result cache will contribute to storage costs.

（F）Each time persisted results for a query are used, a 24-hour retention period is reset.

（A）Change the file format from CSV to JSON.

（B）Create a multi-cluster warehouse and merge smaller files to create bigger files.

（C）Create a specific storage landing bucket to avoid file scanning.

（D）Increase the size of the virtual warehouse.