← Back to exam page

ARA-C01 – SnowPro Advanced: Architect Certification Exam

Loading demo links...

Showing 4–6 of 10 questions

Question 4

What are some of the characteristics of result set caches? (Choose three.)

Select all that apply, then click Submit answer.

  • ○

    Time Travel queries can be executed against the result set cache.
  • ○

    Snowflake persists the data results for 24 hours.
  • ○

    Each time persisted results for a query are used, a 24-hour retention period is reset.
  • ○

    The data stored in the result cache will contribute to storage costs.
  • ○

    The retention period can be reset for a maximum of 31 days.
  • ○

    The result set cache is not shared between warehouses.
Question 5

An Architect entered the following commands in sequence:

USER1 cannot find the table.

Which of the following commands does the Architect need to run for USER1 to find the tables using the Principle of Least Privilege? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    GRANT ROLE PUBLIC TO ROLE INTERN;
  • ○

    GRANT USAGE ON DATABASE SANDBOX TO ROLE INTERN;
  • ○

    GRANT USAGE ON SCHEMA SANDBOX.PUBLIC TO ROLE INTERN;
  • ○

    GRANT OWNERSHIP ON DATABASE SANDBOX TO USER INTERN;
  • ○

    GRANT ALL PRIVILEGES ON DATABASE SANDBOX TO ROLE INTERN;
Question 6

A company has a Snowflake account named ACCOUNTA in AWS us-east-1 region. The company stores its marketing data in a Snowflake database named MARKET_DB. One of the company’s business partners has an account named PARTNERB in Azure East US 2 region. For marketing purposes the company has agreed to share the database MARKET_DB with the partner account.

Which of the following steps MUST be performed for the account PARTNERB to consume data from the MARKET_DB database?

Select an option, then click Submit answer.

  • ○

    Create a new account (called AZABC123) in Azure East US 2 region. From account ACCOUNTA create a share of database MARKET_DB, create a new database out of this share locally in AWS us-east-1 region, and replicate this new database to AZABC123 account. Then set up data sharing to the PARTNERB account.
  • ○

    From account ACCOUNTA create a share of database MARKET_DB, and create a new database out of this share locally in AWS us-east-1 region. Then make this database the provider and share it with the PARTNERB account.
  • ○

    Create a new account (called AZABC123) in Azure East US 2 region. From account ACCOUNTA replicate the database MARKET_DB to AZABC123 and from this account set up the data sharing to the PARTNERB account.
  • ○

    Create a share of database MARKET_DB, and create a new database out of this share locally in AWS us-east-1 region. Then replicate this database to the partner’s account PARTNERB.