ARA-C01 practice questions 161–170

1. Question 161 · 193 in bank

   An Architect plans to stream data using the Snowflake Connector for Kafka in Snowpipe. What setting will optimize costs?

   • ASet a value of 1 to buffer.flush.time.
   • BSet a value of 1 to buffer.count.records.
   • CSet a value of 10 MB to buffer.size.bytes.
   • DMaximize the number of micro-partitions.

   Show answer

   Answer: C

   Next question

2. Question 162 · 193 in bank

   Select 3

   An Architect wants to create an externally managed Iceberg table in Snowflake. What parameters are required? (Choose three.)

   • AExternal volume
   • BStorage integration
   • CExternal stage
   • DData file path
   • ECatalog integration
   • FMetadata file path

   Show answer

   Answer: AEF

   Next question

3. Question 163 · 193 in bank

   Select 3

   An Architect needs to ensure that users are able to upload data from Snowsight into an existing table. What privileges need to be granted to the users to accomplish this? (Choose three.)

   • ADatabase: USAGE
   • BDatabase: OWNERSHIP
   • CSchema: CREATE TABLE
   • DSchema: USAGE
   • ETable: SELECT
   • FTable: OWNERSHIP

   Show answer

   Answer: ADE

   Next question

4. Question 164 · 193 in bank

   Select 2

   A global retail company must ensure comprehensive data governance, security, and compliance with various international regulations while using Snowflake for its data warehousing and analytics. What should an Architect do to meet these requirements? (Choose two.)

   • ACreate a network policy at the column level to secure the data.
   • BUse column-level security to restrict access to specific columns.
   • CStore encryption keys on an external server to manage encryption manually.
   • DImplement Role-Based Access Control (RBAC) to assign roles and permissions.
   • EEnable Secure Data Sharing with external partners for collaborative purposes.

   Show answer

   Answer: BD

   Next question

5. Question 165 · 193 in bank

   Select 3

   An Architect is appraising the compute and storage costs of a storage strategy to augment performance techniques. What performance optimization techniques in Snowflake have storage costs associated with them? (Choose three.)

   • ARekeying
   • BMaterialized view
   • CClustering a table
   • DQuery acceleration service
   • ESearch optimization service
   • FMulti-cluster virtual warehouse

   Show answer

   Answer: BCE

   Next question

6. Question 166 · 193 in bank

   Select 2

   An Architect executes the following query:

   

   What information does this query provide? (Choose two.)

   • AIt shows the total execution time and credit estimates for the 10 most expensive queries executed on the 'WH_L' virtual warehouse over the last 3 days.
   • BIt shows the total execution time and credit estimates for the 10 most expensive query groups (identical or similar queries) executed on the 'WH_L' virtual warehouse over the last 3 days.
   • CIt shows the total execution time and credit estimates for the 10 most frequently run query groups (identical or similar queries) executed on the 'WH_L' virtual warehouse over the last 3 days.
   • DIt calculates the relative cost for each group by converting the execution time to minutes and multiplying by the credits used by the virtual warehouse.
   • EIt calculates the relative cost for each group by converting the execution time to hours and multiplying by the credits used by the virtual warehouse.

   Show answer

   Answer: BE

   Next question

7. Question 167 · 193 in bank

   Why does a conditional multi-table INSERT option support the Data Vault data model?

   • AData can be inserted in parallel to hubs and satellites using surrogate keys.
   • BData can be inserted in parallel to dimensions and facts using surrogate keys.
   • CData can be inserted in sequence to hubs and satellites using surrogate keys.
   • DData can be inserted in sequence to dimensions and facts using surrogate keys.

   Show answer

   Answer: A

   Next question

8. Question 168 · 193 in bank

   An Architect needs to define a table structure for an unfamiliar semi-structured data set. The Architect wants to identify a list of distinct key names present in the semi-structured objects. What function should be used?

   • AFLATTEN with RECURSIVE argument
   • BINFER_SCHEMA
   • CPARSE_JSON
   • DRESULT SCAN

   Show answer

   Answer: A

   Next question

9. Question 169 · 193 in bank

   User1 and User2 are new users that were each granted different functional roles. User1 was granted the IT_ANALYST_ROLE and User2 was granted the FIN_ANALYST_ROLE. Review the following security design:

   

   What tables can each role read?

   • AUser1 will be the only user to read the tables from both schemas, since the DB_IT_RO_ROLE role has SELECT privileges on all the database tables.
   • BUser1 will be able to read the tables from both schemas, while User2 will be able to read only the FINANCE_SCHEMA tables.
   • CUser2 will be able to read the tables from the FINANCE_SCHEMA, while User1 will be unable to read any table.
   • DUser2 will be able to read the tables from both schemas, while User1 will be able to read the tables only in IT_SCHEMA.

   Show answer

   Answer: C

   Next question

10. Question 170 · 193 in bank

    Select 2

    An Architect wants to stream website logs near real-time to Snowflake and has decided to use Snowflake Connector for Kafka. What characteristics should the Architect consider regarding the different ingestion methods? (Choose two.)

    • ASnowpipe Streaming is the default ingestion method.
    • BSnowpipe Streaming supports schema detection.
    • CSnowpipe has a lower latency than Snowpipe Streaming.
    • DSnowpipe Streaming automatically flushes data every one second.
    • ESnowpipe can handle jumps or resetting offsets by default.

    Show answer

    Answer: AE

    Next question

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

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