← Back to exam page

Free ARA-C01 – SnowPro Advanced: Architect Certification Exam Practice Test Question

Free demo downloads

Loading demo links...

Showing 1–3 of 10 questions

Question 1

Which of the following are characteristics of how row access policies can be applied to external tables? (Choose three.)

Select all that apply, then click Submit answer.

  • ○

    An external table can be created with a row access policy, and the policy can be applied to the VALUE column.
  • ○

    A row access policy can be applied to the VALUE column of an existing external table.
  • ○

    A row access policy cannot be directly added to a virtual column of an external table.
  • ○

    External tables are supported as mapping tables in a row access policy.
  • ○

    While cloning a database, both the row access policy and the external table will be cloned.
  • ○

    A row access policy cannot be applied to a view created on top of an external table.
Question 2

How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)

Select all that apply, then click Submit answer.

  • ○

    Shared databases are read-only.
  • ○

    Shared databases must be refreshed in order for new data to be visible.
  • ○

    Shared databases cannot be cloned.
  • ○

    Shared databases are not supported by Time Travel.
  • ○

    Shared databases will have the PUBLIC or INFORMATION_SCHEMA schemas without explicitly granting these schemas to the share.
  • ○

    Shared databases can also be created as transient databases.
Question 3

A company’s daily Snowflake workload consists of a huge number of concurrent queries triggered between 9pm and 11pm. At the individual level, these queries are smaller statements that get completed within a short time period.

What configuration can the company’s Architect implement to enhance the performance of this workload? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Enable a multi-clustered virtual warehouse in maximized mode during the workload duration.
  • ○

    Set the MAX_CONCURRENCY_LEVEL to a higher value than its default value of 8 at the virtual warehouse level.
  • ○

    Increase the size of the virtual warehouse to size X-Large.
  • ○

    Reduce the amount of data that is being processed through this workload.
  • ○

    Set the connection timeout to a higher value than its default.