ARA-C01 Exam Question 71

To increase performance, materialized views can be created on external table without any additional cost
  • ARA-C01 Exam Question 72

    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?
  • ARA-C01 Exam Question 73

    Arrange in order of performance(least to high)
    1. External Table
    2. External Table with partitioning
    3. Materialized View Vs External table
    4. Directly querying a file from the stage
  • ARA-C01 Exam Question 74

    An Architect has a VPN_ACCESS_LOGS table in the SECURITY_LOGS schema containing timestamps of the connection and disconnection, username of the user, and summary statistics.
    What should the Architect do to enable the Snowflake search optimization service on this table?
  • ARA-C01 Exam Question 75

    Consider the following scenario where a masking policy is applied on the CREDICARDND column of the CREDITCARDINFO table. The masking policy definition Is as follows:

    Sample data for the CREDITCARDINFO table is as follows:
    NAME EXPIRYDATE CREDITCARDNO
    JOHN DOE 2022-07-23 4321 5678 9012 1234
    if the Snowflake system rotes have not been granted any additional roles, what will be the result?