ARA-C01 practice questions 91–100

1. Question 91 · 193 in bank

   An Architect is troubleshooting a query with poor performance using the QUERY_HISTORY function. The Architect observes that the COMPILATION_TIME is greater than the EXECUTION_TIME. What is the reason for this?

   • AThe query is processing a very large dataset.
   • BThe query has overly complex logic.
   • CThe query is queued for execution.
   • DThe query is reading from remote storage.

   Show answer

   Answer: B

   Next question

2. Question 92 · 193 in bank

   Select 2

   A Snowflake Architect is designing a multiple-account design strategy. This strategy will be MOST cost-effective with which scenarios? (Choose two.)

   • AThe company wants to clone a production database that resides on AWS to a development database that resides on Azure.
   • BThe 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.
   • CThe company needs to support different role-based access control features for the development, test, and production environments.
   • DThe company security policy mandates the use of different Active Directory instances for the development, test, and production environments.
   • EThe company must use a specific network policy for certain users to allow and block given IP addresses.

   Show answer

   Answer: BD

   Explanation

   C: Using separate Snowflake accounts for development, test, and production environments allows for tailored RBAC configurations without intermingling roles and permissions. This separation can simplify access management and enhance security, leading to cost-effective administration and compliance with organizational policies. D: If the security policy requires different AD instances for various environments, maintaining separate Snowflake accounts is essential. This segregation ensures that each environment adheres to its specific security requirements, reducing complexity and potential security risks, thus optimizing costs related to security management and compliance.

   Source: Adapted from community discussion — MSIDDIQUI18

   Next question

3. Question 93 · 193 in bank

   The following table exists in the production database:

   

   A regulatory requirement states that the company must mask the username for events that are older than six months based on the current date when the data is queried. How can the requirement be met without duplicating the event data and making sure it is applied when creating views using the table or cloning the table?

   • AUse a masking policy on the username column using an entitlement table with valid dates.
   • BUse a row level policy on the user_events table using an entitlement table with valid dates.
   • CUse a masking policy on the username column with event_timestamp as a conditional column.
   • DUse a secure view on the user_events table using a case statement on the username column.

   Show answer

   Answer: A

   Next question

4. Question 94 · 193 in bank

   Select 3

   Which data models can be used when modeling tables in a Snowflake environment? (Choose three.)

   • AGraph model
   • BDimensional/Kimball
   • CData lake
   • DInmon/3NF
   • EBayesian hierarchical model
   • FData vault

   Show answer

   Answer: BDF

   Next question

5. Question 95 · 193 in bank

   A Snowflake Architect is setting up database replication to support a disaster recovery plan. The primary database has external tables. How should the database be replicated?

   • ACreate a clone of the primary database then replicate the database.
   • BMove the external tables to a database that is not replicated, then replicate the primary database.
   • CReplicate the database ensuring the replicated database is in the same region as the external tables.
   • DShare the primary database with an account in the same region that the database will be replicated to.

   Show answer

   Answer: B

   Next question

6. Question 96 · 193 in bank

   Select 3

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

   • ATime Travel queries can be executed against the result set cache.
   • BSnowflake persists the data results for 24 hours.
   • CEach time persisted results for a query are used, a 24-hour retention period is reset.
   • DThe data stored in the result cache will contribute to storage costs.
   • EThe retention period can be reset for a maximum of 31 days.
   • FThe result set cache is not shared between warehouses.

   Show answer

   Answer: BCE

   Explanation

   How is F not a correct answer? It is more correct than B, since a result cache be kicked out of memory before 24 hours if there are newer results coming in.

   Source: Adapted from community discussion — 67422cb

   References

   • Snowflake documentation

   Next question

7. Question 97 · 193 in bank

   An Architect is integrating an application that needs to read and write data to Snowflake without installing any additional software on the application server. How can this requirement be met?

   • AUse SnowSQL.
   • BUse the Snowpipe REST API.
   • CUse the Snowflake SQL REST API.
   • DUse the Snowflake ODBC driver.

   Show answer

   Answer: C

   Next question

8. Question 98 · 193 in bank

   Select 3

   What transformations are supported in the below SQL statement? (Choose three.) CREATE PIPE ... AS COPY ... FROM (...)

   • AData can be filtered by an optional WHERE clause.
   • BColumns can be reordered.
   • CColumns can be omitted.
   • DType casts are supported.
   • EIncoming data can be joined with other tables.
   • FThe ON_ERROR - ABORT_STATEMENT command can be used.

   Show answer

   Answer: BCD

   Explanation

   Using a query as the source for the COPY statement for column reordering, column omission, and casts (i.e. transforming data during a load) is supported. https://docs.snowflake.com/en/sql-reference/sql/create-pipe#usage-notes

   Source: Adapted from community discussion — Acaer

   References

   • Snowflake documentation

   Next question

9. Question 99 · 193 in bank

   Data is being imported and stored as JSON in a VARIANT column. Query performance was fine, but most recently, poor query performance has been reported. What could be causing this?

   • AThere were JSON nulls in the recent data imports.
   • BThe order of the keys in the JSON was changed.
   • CThe recent data imports contained fewer fields than usual.
   • DThere were variations in string lengths for the JSON values in the recent data imports.

   Show answer

   Answer: A

   References

   • Snowflake documentation

   Next question

10. Question 100 · 193 in bank

    What step will improve the performance of queries executed against an external table?

    • APartition the external table.
    • BShorten the names of the source files.
    • CConvert the source files' character encoding to UTF-8.
    • DUse an internal stage instead of an external stage to store the source files.

    Show answer

    Answer: A

    References

    • Snowflake documentation

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

ARA-C01 practice, question 91. 193 questions available.