ARA-C01 practice questions 71–80

1. Question 71 · 193 in bank

   Select 2

   What considerations need to be taken when using database cloning as a tool for data lifecycle management in a development environment? (Choose two.)

   • AAny pipes in the source are not cloned.
   • BAny pipes in the source referring to internal stages are not cloned.
   • CAny pipes in the source referring to external stages are not cloned.
   • DThe clone inherits all granted privileges of all child objects in the source object, including the database.
   • EThe clone inherits all granted privileges of all child objects in the source object, excluding the database.

   Show answer

   Answer: BE

   Explanation

   Answer should be B & E. https://docs.snowflake.com/en/user-guide/object-clone When a database or schema is cloned, any pipes in the source container that reference an internal (i.e. Snowflake) stage are not cloned. However, any pipes that reference an external stage are cloned. If the source object is a database or schema, the clone inherits all granted privileges on the clones of all child objects contained in the source object: Note that the clone of the container itself (database or schema) does not inherit the privileges granted on the source container.

   Source: Adapted from community discussion — cui_li

   References

   • Snowflake documentation

   Next question

2. Question 72 · 193 in bank

   Select 3

   Which columns can be included in an external table schema? (Choose three.)

   • AVALUE
   • BMETADATA$ROW_ID
   • CMETADATA$ISUPDATE
   • DMETADATA$FILENAME
   • EMETADATA$FILE_ROW_NUMBER
   • FMETADATA$EXTERNAL_TABLE_PARTITION

   Show answer

   Answer: ADE

   References

   • Snowflake documentation

   Next question

3. Question 73 · 193 in bank

   Which SQL ALTER command will MAXIMIZE memory and compute resources for a Snowpark stored procedure when executed on the snowpark_opt_wh warehouse?

   • Aalter warehouse snowpark_opt_wh set max_concurrency_level = 1;
   • Balter warehouse snowpark_opt_wh set max_concurrency_level = 2;
   • Calter warehouse snowpark_opt_wh set max_concurrency_level = 8;
   • Dalter warehouse snowpark_opt_wh set max_concurrency_level = 16;

   Show answer

   Answer: A

   Explanation

   A is right Set the warehouse MAX_CONCURRENCY_LEVEL parameter to 1 to maximize memory and compute resources for a given Snowpark stored procedure. https://docs.snowflake.com/en/developer-guide/snowpark/python/python-snowpark-training-ml

   Source: Adapted from community discussion — swe12

   References

   • Snowflake documentation

   Next question

4. Question 74 · 193 in bank

   An Architect clones a database and all of its objects, including tasks. After the cloning, the tasks stop running. Why is this occurring?

   • ATasks cannot be cloned.
   • BThe objects that the tasks reference are not fully qualified.
   • CCloned tasks are suspended by default and must be manually resumed.
   • DThe Architect has insufficient privileges to alter tasks on the cloned database.

   Show answer

   Answer: C

   Explanation

   C is right. When a database or schema that contains tasks is cloned, the tasks in the clone are suspended by default. https://docs.snowflake.com/en/user-guide/object-clone

   Source: Adapted from community discussion — swe12

   References

   • Snowflake documentation

   Next question

5. Question 75 · 193 in bank

   Which technique will efficiently ingest and consume semi-structured data for Snowflake data lake workloads?

   • AIDEF1X
   • BSchema-on-write
   • CSchema-on-read
   • DInformation schema

   Show answer

   Answer: C

   Next question

6. Question 76 · 193 in bank

   Is it possible for a data provider account with a Snowflake Business Critical edition to share data with an Enterprise edition data consumer account?

   • AA Business Critical account cannot be a data sharing provider to an Enterprise consumer. Any consumer accounts must also be Business Critical.
   • BIf a user in the provider account with role authority to CREATE or ALTER SHARE adds an Enterprise account as a consumer, it can import the share.
   • CIf a user in the provider account with a share owning role sets SHARE_RESTRICTIONS to False when adding an Enterprise consumer account, it can import the share.
   • DIf a user in the provider account with a share owning role which also has OVERRIDE SHARE RESTRICTIONS privilege SHARE_RESTRICTIONS set to False when adding an Enterprise consumer account, it can import the share.

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

7. Question 77 · 193 in bank

   How can an Architect enable optimal clustering to enhance performance for different access paths on a given table?

   • ACreate multiple clustering keys for a table.
   • BCreate multiple materialized views with different cluster keys.
   • CCreate super projections that will automatically create clustering.
   • DCreate a clustering key that contains all columns used in the access paths.

   Show answer

   Answer: B

   Explanation

   Creating multiple materialized views with different cluster keys allows you to optimize for various access paths by distributing the data in ways that best suit each specific query pattern. This approach can significantly improve query performance as each materialized view can be tailored to different use cases, providing efficient access and faster retrieval times for specific queries.

   Source: Adapted from community discussion — Yogendra_examtopic

   Next question

8. Question 78 · 193 in bank

   Which of the following ingestion methods can be used to load near real-time data by using the messaging services provided by a cloud provider?

   • ASnowflake Connector for Kafka
   • BSnowflake streams
   • CSnowpipe
   • DSpark

   Show answer

   Answer: C

   Explanation

   I would go C. Automating Snowpipe using cloud messaging Automated data loads leverage event notifications for cloud storage to inform Snowpipe of the arrival of new data files to load. Snowpipe polls the event notifications from a queue. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro

   Source: Adapted from community discussion — ukpino

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

9. Question 79 · 193 in bank

   An Architect is designing a file ingestion recovery solution. The project will use an internal named stage for file storage. Currently, in the case of an ingestion failure, the Operations team must manually download the failed file and check for errors. Which downloading method should the Architect recommend that requires the LEAST amount of operational overhead?

   • AUse the Snowflake Connector for Python, connect to remote storage and download the file.
   • BUse the GET command in SnowSQL to retrieve the file.
   • CUse the GET command in Snowsight to retrieve the file.
   • DUse the Snowflake API endpoint and download the file.

   Show answer

   Answer: B

   Next question

10. Question 80 · 193 in bank

    A table for IOT devices that measures water usage is created. The table quickly becomes large and contains more than 2 billion rows.

    

    The general query patterns for the table are: 1. DeviceId, IOT_timestamp and CustomerId are frequently used in the filter predicate for the select statement 2. The columns City and DeviceManufacturer are often retrieved 3. There is often a count on UniqueId Which field(s) should be used for the clustering key?

    • AIOT_timestamp
    • BCity and DeviceManufacturer
    • CDeviceId and CustomerId
    • DUniqueId

    Show answer

    Answer: C

    References

    • Snowflake documentation

    Next question

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

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