ARA-C01 practice questions 21–30

1. Question 21 · 193 in bank

   The following DDL command was used to create a task based on a stream:

   

   Assuming MY_WH is set to auto_suspend – 60 and used exclusively for this task, which statement is true?

   • AThe warehouse MY_WH will be made active every five minutes to check the stream.
   • BThe warehouse MY_WH will only be active when there are results in the stream.
   • CThe warehouse MY_WH will never suspend.
   • DThe warehouse MY_WH will automatically resize to accommodate the size of the stream.

   Show answer

   Answer: B

   Explanation

   Stream_has_data is a metadata operation, so you don't need a wh to call it. B is correct, the WH will start as soon as there are data in the STREAM

   Source: Adapted from community discussion — GLEM

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

2. Question 22 · 193 in bank

   Select 2

   When using the Snowflake Connector for Kafka, what data formats are supported for the messages? (Choose two.)

   • ACSV
   • BXML
   • CAvro
   • DJSON
   • EParquet

   Show answer

   Answer: CD

   Explanation

   Ans: C,D Explanation: Each Kafka message is passed to Snowflake in JSON format or Avro format. The Kafka connector stores that formatted information in a single column of type VARIANT. The data is not parsed, and the data is not split into multiple columns in the Snowflake table. Link: https://docs.snowflake.com/en/user-guide/kafka-connector-overview

   Source: Adapted from community discussion — krishnak2244

   References

   • Snowflake documentation

   Next question

3. Question 23 · 193 in bank

   What is a characteristic of loading data into Snowflake using the Snowflake Connector for Kafka?

   • AThe Connector only works in Snowflake regions that use AWS infrastructure.
   • BThe Connector works with all file formats, including text, JSON, Avro, Ore, Parquet, and XML.
   • CThe Connector creates and manages its own stage, file format, and pipe objects.
   • DLoads using the Connector will have lower latency than Snowpipe and will ingest data in real time.

   Show answer

   Answer: D

   Next question

4. Question 24 · 193 in bank

   A healthcare company wants to share data with a medical institute. The institute is running a Standard edition of Snowflake; the healthcare company is running a Business Critical edition. How can this data be shared?

   • AThe healthcare company will need to change the institute’s Snowflake edition in the accounts panel.
   • BBy default, sharing is supported from a Business Critical Snowflake edition to a Standard edition.
   • CContact Snowflake and they will execute the share request for the healthcare company.
   • DSet the share_restriction parameter on the shared object to false.

   Show answer

   Answer: D

   Explanation

   https://docs.snowflake.com/en/user-guide/override_share_restrictions For me it looks as D: -- grant the privilege to the SYSADMIN role use role accountadmin; grant override share restrictions on account to role sysadmin; -- SYSADMIN can now add a consumer account to a share with the SHARE_RESTRICTIONS parameter set to false use role sysadmin; alter share add accounts = SHARE_RESTRICTIONS=false;

   Source: Adapted from community discussion — serg_khar

   References

   • Snowflake documentation

   Next question

5. Question 25 · 193 in bank

   An Architect is designing a pipeline to stream event data into Snowflake using the Snowflake Kafka connector. The Architect’s highest priority is to configure the connector to stream data in the MOST cost-effective manner. Which of the following is recommended for optimizing the cost associated with the Snowflake Kafka connector?

   • AUtilize a higher Buffer.flush.time in the connector configuration.
   • BUtilize a higher Buffer.size.bytes in the connector configuration.
   • CUtilize a lower Buffer.size.bytes in the connector configuration.
   • DUtilize a lower Buffer.count.records in the connector configuration.

   Show answer

   Answer: A

   Explanation

   The minimum value supported for the buffer.flush.time property is 1 (in seconds). For higher average data flow rates, we suggest that you decrease the default value for improved latency. If cost is a greater concern than latency, you could increase the buffer flush time. Be careful to flush the Kafka memory buffer before it becomes full to avoid out of memory exceptions. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-streaming-kafka

   Source: Adapted from community discussion — victorleonis

   References

   • Snowflake documentation

   Next question

6. Question 26 · 193 in bank

   An Architect has chosen to separate their Snowflake Production and QA environments using two separate Snowflake accounts. The QA account is intended to run and test changes on data and database objects before pushing those changes to the Production account. It is a requirement that all database objects and data in the QA account need to be an exact copy of the database objects, including privileges and data in the Production account on at least a nightly basis. Which is the LEAST complex approach to use to populate the QA account with the Production account’s data and database objects on a nightly basis?

   • A1. Create a share in the Production account for each database 2. Share access to the QA account as a Consumer 3. The QA account creates a database directly from each share 4. Create clones of those databases on a nightly basis 5. Run tests directly on those cloned databases
   • B1. Create a stage in the Production account 2. Create a stage in the QA account that points to the same external object-storage location 3. Create a task that runs nightly to unload each table in the Production account into the stage 4. Use Snowpipe to populate the QA account
   • C1. Enable replication for each database in the Production account 2. Create replica databases in the QA account 3. Create clones of the replica databases on a nightly basis 4. Run tests directly on those cloned databases
   • D1. In the Production account, create an external function that connects into the QA account and returns all the data for one specific table 2. Run the external function as part of a stored procedure that loops through each table in the Production account and populates each table in the QA account

   Show answer

   Answer: C

   Next question

7. Question 27 · 193 in bank

   A user can change object parameters using which of the following roles?

   • AACCOUNTADMIN, SECURITYADMIN
   • BSYSADMIN, SECURITYADMIN
   • CACCOUNTADMIN, USER with PRIVILEGE
   • DSECURITYADMIN, USER with PRIVILEGE

   Show answer

   Answer: C

   Explanation

   Object Parameters¶ Object parameters can be set at the following levels: Account Account administrators can use the ALTER ACCOUNT command to set object parameters for the account. The values set for the account default to the objects created in the account. Object Users with the appropriate privileges can use the corresponding CREATE or ALTER commands to override object parameters for an individual object.

   Source: Adapted from community discussion — callipso21

   References

   • Snowflake documentation

   Next question

8. Question 28 · 193 in bank

   A media company needs a data pipeline that will ingest customer review data into a Snowflake table, and apply some transformations. The company also needs to use Amazon Comprehend to do sentiment analysis and make the de-identified final data set available publicly for advertising companies who use different cloud providers in different regions. The data pipeline needs to run continuously ang efficiently as new records arrive in the object storage leveraging event notifications. Also, the operational complexity, maintenance of the infrastructure, including platform upgrades and security, and the development effort should be minimal. Which design will meet these requirements?

   • AIngest the data using COPY INTO and use streams and tasks to orchestrate transformations. Export the data into Amazon S3 to do model inference with Amazon Comprehend and ingest the data back into a Snowflake table. Then create a listing in the Snowflake Marketplace to make the data available to other companies.
   • BIngest the data using Snowpipe and use streams and tasks to orchestrate transformations. Create an external function to do model inference with Amazon Comprehend and write the final records to a Snowflake table. Then create a listing in the Snowflake Marketplace to make the data available to other companies.
   • CIngest the data into Snowflake using Amazon EMR and PySpark using the Snowflake Spark connector. Apply transformations using another Spark job. Develop a python program to do model inference by leveraging the Amazon Comprehend text analysis API. Then write the results to a Snowflake table and create a listing in the Snowflake Marketplace to make the data available to other companies.
   • DIngest the data using Snowpipe and use streams and tasks to orchestrate transformations. Export the data into Amazon S3 to do model inference with Amazon Comprehend and ingest the data back into a Snowflake table. Then create a listing in the Snowflake Marketplace to make the data available to other companies.

   Show answer

   Answer: B

   References

   • AWS documentation

   Next question

9. Question 29 · 193 in bank

   A Snowflake Architect is designing an application and tenancy strategy for an organization where strong legal isolation rules as well as multi-tenancy are requirements. Which approach will meet these requirements if Role-Based Access Policies (RBAC) is a viable option for isolating tenants?

   • ACreate accounts for each tenant in the Snowflake organization.
   • BCreate an object for each tenant strategy if row level security is viable for isolating tenants.
   • CCreate an object for each tenant strategy if row level security is not viable for isolating tenants.
   • DCreate a multi-tenant table strategy if row level security is not viable for isolating tenants.

   Show answer

   Answer: C

   Explanation

   Why not A? This approach utilizes separate Snowflake accounts for each tenant, ensuring the highest level of isolation as required by strong legal rules, while still allowing multi-tenancy within the broader organizational context. Each tenant's data and processes remain fully isolated in their dedicated account, aligned with stringent compliance needs.

   Source: Adapted from community discussion — SilversRayleigh

   Next question

10. Question 30 · 193 in bank

    Select 2

    Which statements describe characteristics of the use of materialized views in Snowflake? (Choose two.)

    • AThey can include ORDER BY clauses.
    • BThey cannot include nested subqueries.
    • CThey can include context functions, such as CURRENT_TIME().
    • DThey can support MIN and MAX aggregates.
    • EThey can support inner joins, but not outer joins.

    Show answer

    Answer: BD

    References

    • Snowflake documentation

    Next question

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

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