Snowflake SnowPro Advanced: Architect Recertification - ARA-R01 Exam Practice Test

A. select*fromDEMO_DB.DEMO_SCH.CUSTOMER_ADDRESSWhereCA_ADDRESS_IDLIKE
'%BAAASKD%';

B. select * from DEMO_DB.DEMO_SCH.CUSTOMER_ADDRESS Where CA_ADDRESS_ID= substring('AAAAAAAAPHPPLBAAASKDJHASLKDJHASKJD',1,16);

C. select * from DEMO_DB.DEMO_SCH.CUSTOMER_ADDRESS Where
substring(CA_ADDRESS_ID,1,8)=
substring('AAAAAAAAPHPPLBAAASKDJHASLKDJHASKJD',1,8);

D. select*fromDEMO_DB.DEMO_SCH.CUSTOMER_ADDRESSWhereCA_ADDRESS_IDNOT LIKE
'%AAAAAAAAPHPPL%';

E. select*fromDEMO_DB.DEMO_SCH.CUSTOMER_ADDRESSWhereCA_ADDRESS_IDLIKE
'%PHPP%';

A. Permanent table

B. Internal stages

C. Temporary table

D. External tables

E. Transient table

A. The query has overly complex logic.

B. The query is reading from remote storage.

C. The query is processing a very large dataset.

D. The query is queued for execution.

A. SYSTEM$CLUSTERING_DEPTH

B. SYSTEM$CLUSTERING_INFORMATION

C. SYSTEM$CLUSTERING_KEYS

D. SYSTEM$CLUSTERING_USAGE

E. SYSTEM$CLUSTERING_PERCENT

A. GRANT ROLE PUBLIC TO ROLE INTERN;

B. GRANT USAGE ON DATABASE SANDBOX TO ROLE INTERN;

C. GRANT OWNERSHIP ON DATABASE SANDBOX TO USER INTERN;

D. GRANT ALL PRIVILEGES ON DATABASE SANDBOX TO ROLE INTERN;

E. GRANT USAGE ON SCHEMA SANDBOX.PUBLIC TO ROLE INTERN;

A. Time Travel

B. Zero-copy cloning

C. Search optimization service

D. Secure views

E. Materialized view

A. Connect the applications using the <organization_name>-<connection_name> URL. Use the Business Critical Snowflake edition.

B. Connect the applications using the <organization_name>-<accountLocator> URL. Use the Business Critical Snowflake edition.

C. Connect the applications using the <organization_name>-<accountLocator> URL. Use the Enterprise Snowflake edition.

D. Connect the applications using the <organization_name>-<connection_name> URL. Use the Virtual Private Snowflake (VPS) edition.

A. Ensure that all views are persisted, as views cannot be shared across cloud platforms.

B. Create a pipeline to write shared data to a cloud storage location in the target cloud provider.

C. Company A and Company B must agree to use a single cloud platform: Data sharing is only possible if the companies share the same cloud provider.

D. Setup data replication to the region and cloud platform where the consumer resides.

A. Production and development run in different databases in the same account, and Developers need to see production-like data but with specific columns masked.

B. Data is in a production Snowflake account that needs to be provided to Developers in a separate development/testing Snowflake account in the same cloud region.

C. The release process requires pre-production testing of changes with data of production scale and complexity. For security reasons, pre-production also runs in the production account.

D. Developers create their own datasets to work against transformed versions of the live data.

E. Developers create their own copies of a standard test database previously created for them in the development account, for their initial development and unit testing.

A. The company wants to clone a production database that resides on AWS to a development database that resides on Azure.

B. The company needs to support different role-based access control features for the development, test, and production environments.

C. The company security policy mandates the use of different Active Directory instances 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. The command will return a warning stating that the file has unmatched columns.

B. It expects a header to be present in the CSV file, which is matched to a case-sensitive table column name.

C. The command will return an error.

D. The parameter will be ignored.

A. VALUE

B. METADATASROW_ID

C. METADATASISUPDATE

D. METADATAS FILE_ROW_NUMBER

E. METADATASEXTERNAL TABLE PARTITION

F. METADAT A$ FILENAME

A. The pipe will no longer be able to receive the messages and the user must wait for 24 hours from the time when the SNS topic subscription was deleted. Pipe recreation is not required as the pipe will reuse the same subscription to the existing SNS topic after 24 hours.

B. The pipe will continue to receive the messages as Snowflake will automatically restore the subscription to the same SNS topic and will recreate the pipe by specifying the same SNS topic name in the pipe definition.

C. The pipe will no longer be able to receive the messages. To restore the system immediately, the user needs to manually create a new SNS topic with a different name and then recreate the pipe by specifying the new SNS topic name in the pipe definition.

D. The pipe will continue to receive the messages as Snowflake will automatically restore the subscription by creating a new SNS topic. Snowflake will then recreate the pipe by specifying the new SNS topic name in the pipe definition.

A. Search optimization service works best with a column that has a minimum of 100 K distinct values.

B. Search optimization service can significantly improve query performance on partitioned external tables.

C. The table must be clustered with a key having multiple columns for effective search optimization.

D. Search optimization service can help to optimize storage usage by compressing the data into a GZIP format.