SnowPro Advanced: Architect practice questions

1. Question 1 of 25

   A new user user_01 is created within Snowflake. The following two commands are executed: Command 1 --> show grants to user user_01; Command 2 --> show grants on user user_01; What inferences can be made about these commands?

   • ACommand 1 defines which user owns user_01 Command 2 defines all the grants which have been given to user_01
   • BCommand 1 defines all the grants which are given to user_01 Command 2 defines which user owns user_01
   • CCommand 1 defines which role owns user_0l Command 2 defines all the grants which have been given to user_01
   • DCommand 1 defines all the grants which are given to user_01 Command 2 defines which role owns user_01

   Show answer

   Correct answer: C

   How others answered

   • C100%

   Explanation

   SHOW GRANTS TO USER user_01: Lists all the roles granted to the user_01. SHOW GRANTS ON USER user_01: Lists all privileges granted to the user user_01.

   Adapted from community discussion by KindleAce · 2024-11-13 · 3 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Snowflake documentation

   View community discussion2

   Candidate context

   Question 1 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by ARA-C01 or CertExamHQ.

   1. N

      NachoPrendes

      2024-07-19

      Selected C3 upvotes

      Checked on Snowflake https://docs.snowflake.com/en/sql-reference/sql/show-grants#:~:text=the%20demo%20user%3A-,SHOW%20GRANTS%20TO%20USER,-demo%3B%0A%0A%2B

   2. K

      KindleAce

      2024-11-13

      3 upvotes

      SHOW GRANTS TO USER user_01: Lists all the roles granted to the user_01. SHOW GRANTS ON USER user_01: Lists all privileges granted to the user user_01.

2. Question 2 of 25

   A Data Engineer is designing a near real-time ingestion pipeline for a retail company to ingest event logs into Snowflake to derive insights. A Snowflake Architect is asked to define security best practices to configure access control privileges for the data load for auto-ingest to Snowpipe. What are the MINIMUM object privileges required for the Snowpipe user to execute Snowpipe?

   • AOWNERSHIP on the named pipe, USAGE on the named stage, target database, and schema, and INSERT and SELECT on the target table
   • BOWNERSHIP on the named pipe, USAGE and READ on the named stage, USAGE on the target database and schema, and INSERT end SELECT on the target table
   • CCREATE on the named pipe, USAGE and READ on the named stage, USAGE on the target database and schema, and INSERT end SELECT on the target table
   • DUSAGE on the named pipe, named stage, target database, and schema, and INSERT and SELECT on the target table

   Show answer

   Correct answer: A

   How others answered

   • A56%
   • B33%

   Only 56% agreed on this answer — treat it as contested rather than settled.

   Explanation

   Ans is A: -- Create a role to contain the Snowpipe privileges use role securityadmin; create or replace role snowpipe1; -- Grant the required privileges on the database objects grant usage on database snowpipe_db to role snowpipe1; grant usage on schema snowpipe_db.public to role snowpipe1; grant insert, select on snowpipe_db.public.mytable to role snowpipe1; grant usage on stage snowpipe_db.public.mystage to role snowpipe1; -- Grant the OWNERSHIP privilege on the pipe object grant ownership on pipe snowpipe_db.public.mypipe to role snowpipe1; -- Grant the role to a user grant role snowpipe1 to user jsmith; -- Set the role as the default role for the user alter user jsmith set default_role = snowpipe1;

   Adapted from community discussion by Vishal27dec · 2023-09-29 · 4 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   View community discussion4

   Candidate context

   Question 2 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by ARA-C01 or CertExamHQ.

   1. V

      Vishal27dec

      2023-09-29

      4 upvotes

      Ans is A: -- Create a role to contain the Snowpipe privileges use role securityadmin; create or replace role snowpipe1; -- Grant the required privileges on the database objects grant usage on database snowpipe_db to role snowpipe1; grant usage on schema snowpipe_db.public to role snowpipe1; grant insert, select on snowpipe_db.public.mytable to role snowpipe1; grant usage on stage snowpipe_db.public.mystage to role snowpipe1; -- Grant the OWNERSHIP privilege on the pipe object grant ownership on pipe snowpipe_db.public.mypipe to role snowpipe1; -- Grant the role to a user grant role snowpipe1 to user jsmith; -- Set the role as the default role for the user alter user jsmith set default_role = snowpipe1;

   2. J

      jlad26

      2024-02-18

      Selected A5 upvotes

      Pipe does not have USAGE privilege and internal stage does not have READ privilege so has to be A

   3. A

      Akhil_8121

      2024-09-21

      2 upvotes

      option B https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro#creating-pipes Creating pipes Creating and managing pipes requires a role with a minimum of the following privileges: Object Privilege Notes Database USAGE Schema USAGE, CREATE PIPE Stage in the pipe definition USAGE External stages only. Stage in the pipe definition READ Internal stages only. Table in the pipe definition SELECT, INSERT

   4. S

      Saai123

      2023-08-01

      3 upvotes

      Answer is A. OWNERSHIP on the named pipe, USAGE on the named stage, target database, and schema, and INSERT and SELECT on the target table

3. Question 3 of 25

   The IT Security team has identified that there is an ongoing credential stuffing attack on many of their organization’s system. What is the BEST way to find recent and ongoing login attempts to Snowflake?

   • ACall the LOGIN_HISTORY Information Schema table function.
   • BQuery the LOGIN_HISTORY view in the ACCOUNT_USAGE schema in the SNOWFLAKE database.
   • CView the History tab in the Snowflake UI and set up a filter for SQL text that contains the text "LOGIN".
   • DView the Users section in the Account tab in the Snowflake UI and review the last login column.

   Show answer

   Correct answer: A

   How others answered

   • A60%
   • B40%

   Only 60% agreed on this answer — treat it as contested rather than settled.

   Explanation

   Key word here : way to find recent and ongoing login attempts . So can't be the B answer, as there is lag (2 or 3 hours) in the account_usage view. Answer is A.

   Adapted from community discussion by GLEM · 2023-07-12 · 6 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Snowflake documentation

   View community discussion3

   Candidate context

   Question 3 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by ARA-C01 or CertExamHQ.

   1. G

      GLEM

      2023-07-12

      Selected A6 upvotes

      Key word here : way to find recent and ongoing login attempts . So can't be the B answer, as there is lag (2 or 3 hours) in the account_usage view. Answer is A.

   2. M

      MSIDDIQUI18

      2024-10-24

      Selected A1 upvote

      If TIME_RANGE_END is not specified, the function returns the most recent login events. If the time range does not fall within the last 7 days, an error is returned. select * from table(information_schema.login_history_by_user()) order by event_timestamp; select * from table(information_schema.login_history(TIME_RANGE_START => dateadd('hours',-1,current_timestamp()),current_timestamp())) order by event_timestamp;

   3. Q

      qqcvd

      2023-06-19

      2 upvotes

      the most up to date data is here : https://docs.snowflake.com/en/sql-reference/functions/login_history so it is response A

4. Question 4 of 25

   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?

   • AAssume role with OWNERSHIP on future tables and ADD SEARCH OPTIMIZATION on the SECURITY_LOGS schema.
   • BAssume role with ALL PRIVILEGES including ADD SEARCH OPTIMIZATION in the SECURITY LOGS schema.
   • CAssume role with OWNERSHIP on VPN_ACCESS_LOGS and ADD SEARCH OPTIMIZATION in the SECURITY_LOGS schema.
   • DAssume role with ALL PRIVILEGES on VPN_ACCESS_LOGS and ADD SEARCH OPTIMIZATION in the SECURITY_LOGS schema.

   Show answer

   Correct answer: C

   How others answered

   • C100%

   Explanation

   https://docs.snowflake.com/en/user-guide/search-optimization-service To add, configure, or remove search optimization for a table, you must have the following privileges: You must have OWNERSHIP privilege on the table. You must have ADD SEARCH OPTIMIZATION privilege on the schema that contains the table.

   Adapted from community discussion by HighBMI · 2024-05-21 · 6 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Snowflake documentation

   View community discussion2

   Candidate context

   Question 4 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by ARA-C01 or CertExamHQ.

   1. H

      HighBMI

      2024-05-21

      6 upvotes

      https://docs.snowflake.com/en/user-guide/search-optimization-service To add, configure, or remove search optimization for a table, you must have the following privileges: You must have OWNERSHIP privilege on the table. You must have ADD SEARCH OPTIMIZATION privilege on the schema that contains the table.

   2. D

      DhirajG

      2025-03-20

      Selected C1 upvote

      Ownership is required on table on which SOS needs to be added.

5. Question 5 of 25

   Select 3

   How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)

   • AShared databases are read-only.
   • BShared databases must be refreshed in order for new data to be visible.
   • CShared databases cannot be cloned.
   • DShared databases are not supported by Time Travel.
   • EShared databases will have the PUBLIC or INFORMATION_SCHEMA schemas without explicitly granting these schemas to the share.
   • FShared databases can also be created as transient databases.

   Show answer

   Correct answer: A, C, D

   How others answered

   • ACD80%
   • ACE20%

   Explanation

   Answer is A,D,E and is validated Explanation Shared databases are read-only. Users in a consumer account can view/query data, but cannot insert or update data, or create any objects in the database. The following actions are not supported: Creating a clone of a shared database or any schemas/tables in the database. Time Travel for a shared database or any schemas/tables in the database. Editing the comments for a shared database. Databases created from shares differ from standard databases in the following ways: They do not have the PUBLIC or INFORMATION_SCHEMA schemas unless these schemas were explicitly granted to the share. They cannot be cloned. Properties, such as TRANSIENT and DATA_RETENTION_TIME_IN_DAYS, do not apply.

   Adapted from community discussion by hillcat111 · 2024-01-05 · 2 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Snowflake documentation
   • Snowflake documentation

   View community discussion3

   Candidate context

   Question 5 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by ARA-C01 or CertExamHQ.

   1. H

      hillcat111

      2024-01-05

      2 upvotes

      Answer is A,D,E and is validated Explanation Shared databases are read-only. Users in a consumer account can view/query data, but cannot insert or update data, or create any objects in the database. The following actions are not supported: Creating a clone of a shared database or any schemas/tables in the database. Time Travel for a shared database or any schemas/tables in the database. Editing the comments for a shared database. Databases created from shares differ from standard databases in the following ways: They do not have the PUBLIC or INFORMATION_SCHEMA schemas unless these schemas were explicitly granted to the share. They cannot be cloned. Properties, such as TRANSIENT and DATA_RETENTION_TIME_IN_DAYS, do not apply.

   2. H

      hawkhunt

      2025-02-02

      Selected A, C, D1 upvote

      https://docs.snowflake.com/en/sql-reference/sql/create-database#general-usage-notes ACD * Databases created from shares differ from standard databases in the following ways: * They do not have the PUBLIC or INFORMATION_SCHEMA schemas unless these schemas were explicitly granted to the share. * They cannot be cloned. * Properties, such as TRANSIENT and DATA_RETENTION_TIME_IN_DAYS, do not apply. In question, the statement says: E. Shared databases will have the PUBLIC or INFORMATION_SCHEMA schemas without explicitly granting these schemas to the share. However, the fact mentioned is: They do not have the PUBLIC or INFORMATION_SCHEMA schemas unless these schemas were explicitly granted to the share. E is not correct.

   3. Q

      qqcvd

      2023-09-29

      1 upvote

      The following actions are not supported: Time Travel for a shared database or any schemas/tables in the database. -> https://docs.snowflake.com/en/user-guide/data-share-consumers Databases created from shares differ from standard databases in the following ways: They do not have the PUBLIC or INFORMATION_SCHEMA schemas unless these schemas were explicitly granted to the share. -> https://docs.snowflake.com/en/sql-reference/sql/create-database

6. Question 6 of 25

   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

   Correct answer: B

   How others answered

   • B100%

   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

   Adapted from community discussion by GLEM · 2024-07-12 · 4 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Snowflake documentation
   • Snowflake documentation

   View community discussion3

   Candidate context

   Question 6 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by ARA-C01 or CertExamHQ.

   1. G

      GLEM

      2024-07-12

      Selected B4 upvotes

      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

   2. V

      victorleonis

      2024-05-28

      Selected B3 upvotes

      the warehouse will be triggered if condition STREAM_HAS_DATA meet

   3. T

      taod

      2024-04-23

      3 upvotes

      Not true, B would be correct. Warehouse is only started if condition is met: https://docs.snowflake.com/en/sql-reference/sql/create-task https://docs.snowflake.com/en/sql-reference/functions/system_stream_has_data

7. Question 7 of 25

   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

   Correct answer: C, D

   How others answered

   • CD100%

   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

   Adapted from community discussion by krishnak2244 · 2023-07-03 · 2 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Snowflake documentation

   View community discussion3

   Candidate context

   Question 7 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by ARA-C01 or CertExamHQ.

   1. J

      JRayan

      2023-04-04

      4 upvotes

      The Snowflake Connector for Kafka supports the JSON and Avro data formats for the messages. Therefore, options (C) and (D) are the correct answers. Snowflake does not support CSV, XML, or Parquet data formats for Kafka messages

   2. K

      krishnak2244

      2023-07-03

      2 upvotes

      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

   3. N

      NachoPrendes

      2024-07-10

      Selected C, D1 upvote

      https://docs.snowflake.com/en/user-guide/kafka-connector-overview#:~:text=Each%20Kafka%20message%20is%20passed%20to%20Snowflake%20in%20JSON%20format%20or%20Avro%20format

8. Question 8 of 25

   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

   Correct answer: D

   How others answered

   • D100%

   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;

   Adapted from community discussion by serg_khar · 2023-04-04 · 5 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Snowflake documentation

   View community discussion4

   Candidate context

   Question 8 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by ARA-C01 or CertExamHQ.

   1. S

      serg_khar

      2023-04-04

      Selected D5 upvotes

      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;

   2. L

      laksnarn

      2024-06-26

      3 upvotes

      B. By default, sharing is supported from a Business Critical Snowflake edition to a Standard edition. Snowflake allows data sharing between different editions of accounts, including from higher editions (like Business Critical) to lower editions (like Standard). This means that the healthcare company can share data with the medical institute without needing to change the institute’s Snowflake edition or contact Snowflake for assistance.

   3. M

      MariusdeWith

      2023-10-31

      3 upvotes

      It is D. https://docs.snowflake.com/en/user-guide/override_share_restrictions -> By default, Snowflake does not allow sharing data from a Business Critical to a non-Business Critical account.

   4. P

      PedroSDG

      2023-10-28

      2 upvotes

      It is B. Sharing is SUPPORTED from business critical to any, but not ENABLED.

9. Question 9 of 25

   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

   Correct answer: A

   How others answered

   • A100%

   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

   Adapted from community discussion by victorleonis · 2024-05-28 · 5 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Snowflake documentation

   View community discussion3

   Candidate context

   Question 9 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by ARA-C01 or CertExamHQ.

   1. V

      victorleonis

      2024-05-28

      Selected A5 upvotes

      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

   2. A

      Alachramkowa

      2024-04-28

      3 upvotes

      With lower buffer.count.records the buffer limits will be reached earlier, the file will be flushed and sent for ingestion through Snowpipe more frequently, thus increasing the cost

   3. J

      jjordan

      2024-11-29

      Selected A2 upvotes

      https://docs.snowflake.com/en/user-guide/data-load-snowpipe-streaming-kafka

10. Question 10 of 25

    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

    Correct answer: C

    How others answered

    • C100%

    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.

    Adapted from community discussion by callipso21 · 2023-10-18 · 3 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation

    View community discussion2

    Candidate context

    Question 10 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by ARA-C01 or CertExamHQ.

    1. C

       callipso21

       2023-10-18

       Selected C3 upvotes

       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.

    2. S

       serg_khar

       2023-10-15

       Selected C4 upvotes

       https://docs.snowflake.com/en/sql-reference/parameters#object-parameters

11. Question 11 of 25

    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

    Correct answer: C

    How others answered

    • C100%

    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.

    Adapted from community discussion by SilversRayleigh · 2024-04-18 · 2 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    View community discussion4

    Candidate context

    Question 11 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by ARA-C01 or CertExamHQ.

    1. S

       SilversRayleigh

       2024-04-18

       2 upvotes

       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.

    2. M

       MSIDDIQUI18

       2024-10-30

       1 upvote

       Answer "A", according to these two points from this link. • Isolates tenants, thereby reducing the risk of mismanaging security. • Allows for strict security measures (encryption keys, IP allow lists, better-than-RBAC controls) by isolating tenants by account.

    3. A

       Alachramkowa

       2023-04-29

       1 upvote

       C https://resources.snowflake.com/white-paper/design-patterns-for-building-multi-tenant-applications-on-snowflake

    4. S

       Soumak

       2025-01-26

       1 upvote

       but why not B, as the question says that isolating the tenants is a viable option.

12. Question 12 of 25

    Select 2

    An Architect needs to allow a user to create a database from an inbound share. To meet this requirement, the user’s role must have which privileges? (Choose two.)

    • AIMPORT SHARE;
    • BIMPORT PRIVILEGES;
    • CCREATE DATABASE;
    • DCREATE SHARE;
    • EIMPORT DATABASE;

    Show answer

    Correct answer: A, C

    How others answered

    • AC83%
    • BC17%

    Explanation

    https://docs.snowflake.com/en/user-guide/data-share-consumers#step-1-create-a-database-from-the-share Create a database from the share using CREATE DATABASE … FROM SHARE. Executing this command requires a role with the global CREATE DATABASE and IMPORT SHARE privileges.

    Adapted from community discussion by serg_khar · 2023-10-15 · 2 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation

    View community discussion2

    Candidate context

    Question 12 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by ARA-C01 or CertExamHQ.

    1. S

       serg_khar

       2023-10-15

       Selected A, C2 upvotes

       https://docs.snowflake.com/en/user-guide/data-share-consumers#step-1-create-a-database-from-the-share Create a database from the share using CREATE DATABASE … FROM SHARE. Executing this command requires a role with the global CREATE DATABASE and IMPORT SHARE privileges.

    2. V

       victorleonis

       2023-11-29

       Selected A, C2 upvotes

       IMPORT SHARE Privilege If the IMPORT SHARE privilege is granted to a role, any user with the role can perform the following tasks: View all INBOUND shares (shared by provider accounts) and create databases for the shares. View all OUTBOUND shares owned by the role.

13. Question 13 of 25

    Select 2

    Files arrive in an external stage every 10 seconds from a proprietary system. The files range in size from 500 K to 3 MB. The data must be accessible by dashboards as soon as it arrives. How can a Snowflake Architect meet this requirement with the LEAST amount of coding? (Choose two.)

    • AUse Snowpipe with auto-ingest.
    • BUse a COPY command with a task.
    • CUse a materialized view on an external table.
    • DUse the COPY INTO command.
    • EUse a combination of a task and a stream.

    Show answer

    Correct answer: A, E

    How others answered

    • AE50%
    • AC38%

    Only 50% agreed on this answer — treat it as contested rather than settled.

    Explanation

    A is definitely valid Correct me if I'm wrong. E is also valid because if we set STREAM_HAS_DATA it will trigger the task to run to insert data although schedule has been set.

    Adapted from community discussion by chiiiik · 2024-03-11 · 2 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    View community discussion4

    Candidate context

    Question 13 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by ARA-C01 or CertExamHQ.

    1. C

       chiiiik

       2024-03-11

       Selected A, E2 upvotes

       A is definitely valid Correct me if I'm wrong. E is also valid because if we set STREAM_HAS_DATA it will trigger the task to run to insert data although schedule has been set.

    2. I

       ivanjs44

       2024-04-14

       1 upvote

       Sorry, I think STREAM_HAS_DATA can not change the scheduling of a task: This function is intended to be used in the WHEN expression in the definition of tasks. If the specified stream contains no change data, the task skips the current run. And this can not be correct because of the charemski comment.

    3. M

       MSIDDIQUI18

       2024-11-07

       1 upvote

       According to following statement "C" is correct, but I am not 100% sure, if this logic applied here: "In many cases, the Materialized view on an external table can provide performance that is faster than equivalent queries over the underline External table. "

    4. I

       ivanjs44

       2024-04-14

       1 upvote

       I think this is also true but the question says: with the LEAST amount of coding

14. Question 14 of 25

    Select 2

    An Architect uses COPY INTO with the ON_ERROR=SKIP_FILE option to bulk load CSV files into a table called TABLEA, using its table stage. One file named file5.csv fails to load. The Architect fixes the file and re-loads it to the stage with the exact same file name it had previously. Which commands should the Architect use to load only file5.csv file from the stage? (Choose two.)

    • ACOPY INTO tablea FROM @%tablea RETURN_FAILED_ONLY = TRUE;
    • BCOPY INTO tablea FROM @%tablea;
    • CCOPY INTO tablea FROM @%tablea FILES = ('file5.csv');
    • DCOPY INTO tablea FROM @%tablea FORCE = TRUE;
    • ECOPY INTO tablea FROM @%tablea NEW_FILES_ONLY = TRUE;
    • FCOPY INTO tablea FROM @%tablea MERGE = TRUE;

    Show answer

    Correct answer: B, C

    How others answered

    • BC100%

    Explanation

    Key point here - "ON_ERROR=SKIP_FILE". It means that file hasn't loaded. I we want to load the file we have to point it explicitly - this is C option or load all unloaded files (with file5.csv); its B option. If we use FORCE we will load again ALL data from the stage - it doesn't look as a good option.

    Adapted from community discussion by serg_khar · 2023-04-02 · 5 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation

    View community discussion4

    Candidate context

    Question 14 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by ARA-C01 or CertExamHQ.

    1. S

       serg_khar

       2023-04-02

       5 upvotes

       Key point here - "ON_ERROR=SKIP_FILE". It means that file hasn't loaded. I we want to load the file we have to point it explicitly - this is C option or load all unloaded files (with file5.csv); its B option. If we use FORCE we will load again ALL data from the stage - it doesn't look as a good option.

    2. L

       laksnarn

       2024-06-17

       2 upvotes

       C & D Here's the reasoning: C. COPY INTO tablea FROM @%tablea FILES = ('file5.csv'); This command specifically targets the file file5.csv, ensuring that only this file is loaded. D. COPY INTO tablea FROM @%tablea FORCE = TRUE; This command forces the reloading of the file, ignoring any previous load history and thus ensuring the fixed file5.csv is loaded even if the system might otherwise think it has already been processed.

    3. G

       Gandharv75

       2024-11-16

       1 upvote

       Option B and C are correct. Question says bulk load files, so there may be files other than fil5.csv. When File5.csv was modified and re-uploaded a new checksum was generated by snowflake, so B. COPY INTO tablea FROM @%tablea- will work as it won't load the files already loaded first time except file5.csv which has a new checksum now. Also, C. COPY INTO tablea FROM @%tablea FILES = ('file5.csv'); works because it specifically requests file5.csv to be loaded only(which already has anew checksum,so will be loaded successfully) Hence B and C only..

    4. G

       ggorzki

       2024-06-28

       Selected B, C1 upvote

       B and C Parameter NEW_FILES_ONLY does not exist. File is already changed in the stage, so FORCE = TRUE is not needed. Besides, it would load duplicates from the other files that reside in the stage.

15. Question 15 of 25

    Select 2

    How is the change of local time due to daylight savings time handled in Snowflake tasks? (Choose two.)

    • AA task scheduled in a UTC-based schedule will have no issues with the time changes.
    • BTask schedules can be designed to follow specified or local time zones to accommodate the time changes.
    • CA task will move to a suspended state during the daylight savings time change.
    • DA frequent task execution schedule like minutes may not cause a problem, but will affect the task history.
    • EA task schedule will follow only the specified time and will fail to handle lost or duplicated hours.

    Show answer

    Correct answer: A, E

    How others answered

    • AE60%
    • AB40%

    Only 60% agreed on this answer — treat it as contested rather than settled.

    Explanation

    Against B: "A scheduled task runs according to the specified cron expression in the local time for a given time zone. Special care should be taken with regard to scheduling tasks for time zones that recognize daylight saving time. Tasks scheduled during specific times on days when the transition from standard time to daylight saving time (or the reverse) occurs can have unexpected behaviors."

    Adapted from community discussion by starkbi · 2023-06-15 · 6 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation

    View community discussion3

    Candidate context

    Question 15 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by ARA-C01 or CertExamHQ.

    1. S

       starkbi

       2023-06-15

       Selected A, E6 upvotes

       Against B: "A scheduled task runs according to the specified cron expression in the local time for a given time zone. Special care should be taken with regard to scheduling tasks for time zones that recognize daylight saving time. Tasks scheduled during specific times on days when the transition from standard time to daylight saving time (or the reverse) occurs can have unexpected behaviors."

    2. A

       Alachramkowa

       2023-04-29

       4 upvotes

       https://docs.snowflake.com/en/user-guide/tasks-intro#task-scheduling-and-daylight-saving-time AE

    3. H

       h8er

       2024-04-15

       1 upvote

       This example provided in your link is below: "During the autumn change from daylight saving time to standard time, a task scheduled to start at 1 AM in the America/Los_Angeles time zone (i.e. 0 1 * * * America/Los_Angeles) would run twice: once at 1 AM and then again when 1:59:59 AM shifts to 1:00:00 AM local time. That is, there are two points in time when the local time is 1 AM." option E states "fail to handle" it is not failing to handle the task as it is executing it twice.

16. Question 16 of 25

    Select 2

    A company has an inbound share set up with eight tables and five secure views. The company plans to make the share part of its production data pipelines. Which actions can the company take with the inbound share? (Choose two.)

    • AClone a table from a share.
    • BGrant modify permissions on the share.
    • CCreate a table from the shared database.
    • DCreate additional views inside the shared database.
    • ECreate a table stream on the shared table.

    Show answer

    Correct answer: C, E

    How others answered

    • CE100%

    Explanation

    On the basis of this documentation, the answer is C and E https://docs.snowflake.com/en/user-guide/data-share-consumers#step-1-create-a-database-from-the-share The reasoning is as follows: Cloning of shared databases is not supported They cannot be modified Streaming (CDC) of updates is supported

    Adapted from community discussion by DataKelpie · 2023-07-21 · 2 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation

    View community discussion3

    Candidate context

    Question 16 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by ARA-C01 or CertExamHQ.

    1. D

       DataKelpie

       2023-07-21

       2 upvotes

       On the basis of this documentation, the answer is C and E https://docs.snowflake.com/en/user-guide/data-share-consumers#step-1-create-a-database-from-the-share The reasoning is as follows: Cloning of shared databases is not supported They cannot be modified Streaming (CDC) of updates is supported

    2. M

       MSIDDIQUI18

       2024-11-05

       1 upvote

       Correct Answer: CE CREATE DATABASE c1 FROM SHARE provider1.share1; Creating streams on shared objects (secure views or tables) enables you to track data manipulation language (DML) changes made in those objects. CREATE STREAM ON TABLE . . ;

    3. P

       Pk2287

       2024-07-23

       1 upvote

       Answer is C & E.. A,B and D options are not possible considering share data is read only

17. Question 17 of 25

    Which of the following are characteristics of Snowflake’s parameter hierarchy?

    • ASession parameters override virtual warehouse parameters.
    • BVirtual warehouse parameters override user parameters.
    • CTable parameters override virtual warehouse parameters.
    • DSchema parameters override account parameters.

    Show answer

    Correct answer: D

    How others answered

    • D83%
    • A17%

    Explanation

    When the parameter like STATEMENT_QUEUED_TIMEOUT_IN_SECONDS is set for both a warehouse and a session, the lowest non-zero value is enforced therefore A is not correct. D is my answer

    Adapted from community discussion by anikl · 2024-11-06 · 2 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation

    View community discussion2

    Candidate context

    Question 17 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by ARA-C01 or CertExamHQ.

    1. C

       charemski

       2024-07-08

       Selected D5 upvotes

       Session parameters not always override Virtual Warehouse parameters, see i.e. here: https://docs.snowflake.com/sql-reference/parameters#statement-timeout-in-seconds Only account->database->schema->table always keeps hierarchy of parameters

    2. A

       anikl

       2024-11-06

       2 upvotes

       When the parameter like STATEMENT_QUEUED_TIMEOUT_IN_SECONDS is set for both a warehouse and a session, the lowest non-zero value is enforced therefore A is not correct. D is my answer

18. Question 18 of 25

    Consider the following COPY command which is loading data with CSV format into a Snowflake table from an internal stage through a data transformation query.

    

    This command results in the following error: SQL compilation error: invalid parameter 'validation_mode' Assuming the syntax is correct, what is the cause of this error?

    • AThe VALIDATION_MODE parameter supports COPY statements that load data from external stages only.
    • BThe VALIDATION_MODE parameter does not support COPY statements with CSV file formats.
    • CThe VALIDATION_MODE parameter does not support COPY statements that transform data during a load.
    • DThe value return_all_errors of the option VALIDATION_MODE is causing a compilation error.

    Show answer

    Correct answer: C

    How others answered

    • C100%

    Explanation

    "VALIDATION_MODE does not support COPY statements that transform data during a load. If the parameter is specified, the COPY statement returns an error."

    Adapted from community discussion by charemski · 2023-07-09 · 5 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation

    View community discussion4

    Candidate context

    Question 18 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by ARA-C01 or CertExamHQ.

    1. C

       charemski

       2023-07-09

       Selected C5 upvotes

       "VALIDATION_MODE does not support COPY statements that transform data during a load. If the parameter is specified, the COPY statement returns an error."

    2. N

       NachoPrendes

       2024-07-16

       Selected C1 upvote

       https://docs.snowflake.com/en/sql-reference/sql/copy-into-table#:~:text=Note-,VALIDATION_MODE,-does%20not%20support

    3. F

       Fabrisa

       2023-04-18

       1 upvote

       I would choose C... https://docs.snowflake.com/en/sql-reference/sql/copy-into-table#optional-parameters

    4. H

       hillcat111

       2023-06-09

       1 upvote

       i would choose D validation mode is causing the compiling error

19. Question 19 of 25

    A user has the appropriate privilege to see unmasked data in a column. If the user loads this column data into another column that does not have a masking policy, what will occur?

    • AUnmasked data will be loaded in the new column.
    • BMasked data will be loaded into the new column.
    • CUnmasked data will be loaded into the new column but only users with the appropriate privileges will be able to see the unmasked data.
    • DUnmasked data will be loaded into the new column and no users will be able to see the unmasked data.

    Show answer

    Correct answer: A

    How others answered

    • A75%
    • C25%

    Explanation

    Definitely A. "Since a masking policy is set on the source column, a role that views unmasked column data can insert unmasked data into another column, where any role with sufficient privileges on the table or view can see the value.". Doc: https://docs.snowflake.com/en/user-guide/security-column-intro

    Adapted from community discussion by Needium · 2023-05-21 · 4 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation

    View community discussion4

    Candidate context

    Question 19 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by ARA-C01 or CertExamHQ.

    1. N

       Needium

       2023-05-21

       Selected A4 upvotes

       Definitely A. "Since a masking policy is set on the source column, a role that views unmasked column data can insert unmasked data into another column, where any role with sufficient privileges on the table or view can see the value.". Doc: https://docs.snowflake.com/en/user-guide/security-column-intro

    2. D

       DBSS

       2024-05-08

       2 upvotes

       C Use caution when inserting values from a source column that has a masking policy on the source column to a target column without a masking policy on the target column. Since a masking policy is set on the source column, a role that views unmasked column data can insert unmasked data into another column, where any role with sufficient privileges on the table or view can see the value. If a role that sees masked data in the source column inserts those values into a target column, the inserted values remain masked. https://docs.snowflake.com/en/user-guide/security-column-intro

    3. L

       laksnarn

       2024-06-17

       1 upvote

       A. Unmasked data will be loaded in the new column. Here’s why: When a user with appropriate privileges to see unmasked data loads data from a column with a masking policy into another column without a masking policy, the data loaded into the new column will be unmasked. This is because the user's privileges allow them to access the original data without the masking applied. Since the new column does not have a masking policy, it will simply store the data as it was accessed by the user, which in this case is unmasked. Therefore, the new column will contain the unmasked data regardless of the masking policy on the original column, and no additional masking will be applied to the new column unless explicitly defined.

    4. 0

       078f5e0

       2025-01-18

       Selected A1 upvote

       Option A: Here is the explanation: Use caution when inserting values from a source column that has a masking policy on the source column to a target column without a masking policy on the target column. Since a masking policy is set on the source column, a role that views unmasked column data can insert unmasked data into another column, where any role with sufficient privileges on the table or view can see the value.

20. Question 20 of 25

    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

    Correct answer: B, E

    How others answered

    • BE100%

    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.

    Adapted from community discussion by cui_li · 2024-11-14 · 4 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation

    View community discussion3

    Candidate context

    Question 20 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by ARA-C01 or CertExamHQ.

    1. A

       Atomic_Gecko

       2024-09-02

       6 upvotes

       Correct answer is B & E, only pipes referencing external stages are cloned, and the clone inherits all grants to child objects but not the database itself

    2. C

       cui_li

       2024-11-14

       4 upvotes

       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.

    3. P

       potatosack

       2025-01-22

       Selected B, E2 upvotes

       B & E, https://docs.snowflake.com/en/user-guide/object-clone

21. Question 21 of 25

    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

    Correct answer: C

    How others answered

    • C100%

    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

    Adapted from community discussion by ukpino · 2024-12-28 · 2 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation
    • Snowflake documentation

    View community discussion4

    Candidate context

    Question 21 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by ARA-C01 or CertExamHQ.

    1. U

       ukpino

       2024-12-28

       Selected C2 upvotes

       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

    2. S

       Soumak

       2025-01-20

       Selected C2 upvotes

       snowpipe looks to be the correct answer as it can easily integrate with SQS for streaming data ingestion.

    3. D

       DBSS

       2024-05-09

       1 upvote

       C Automating Snowpipe using Amazon SQS notifications works well https://docs.snowflake.com/en/user-guide/data-load-snowpipe-auto-s3

    4. I

       isadd_

       2024-07-24

       1 upvote

       A, Kafka is the messaging service so I would use the Snowflake Connector for Kafka

22. Question 22 of 25

    How can the Snowpipe REST API be used to keep a log of data load history?

    • ACall insertReport every 20 minutes, fetching the last 10,000 entries.
    • BCall loadHistoryScan every minute for the maximum time range.
    • CCall insertReport every 8 minutes for a 10-minute time range.
    • DCall loadHistoryScan every 10 minutes for a 15-minute time range.

    Show answer

    Correct answer: C

    How others answered

    • C100%

    Explanation

    By calling this command repeatedly, it is possible to see the full history of events on a pipe over time. Note that the command must be called often enough to not miss events. Events are retained for a maximum of 10 minutes. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-rest-apis#endpoint-insertreport

    Adapted from community discussion by Acaer · 2024-08-21 · 3 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation

    View community discussion4

    Candidate context

    Question 22 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by ARA-C01 or CertExamHQ.

    1. A

       Acaer

       2024-08-21

       Selected C3 upvotes

       By calling this command repeatedly, it is possible to see the full history of events on a pipe over time. Note that the command must be called often enough to not miss events. Events are retained for a maximum of 10 minutes. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-rest-apis#endpoint-insertreport

    2. A

       akellaanurag

       2024-10-26

       2 upvotes

       Correct answer is C Important This endpoint is rate limited to avoid excessive calls. To help avoid exceeding the rate limit (error code 429), we recommend relying more heavily on insertReport than loadHistoryScan. When calling loadHistoryScan, specify the most narrow time range that includes a set of data loads. For example, reading the last 10 minutes of history every 8 minutes would work well. Trying to read the last 24 hours of history every minute will result in 429 errors indicating a rate limit has been reached. The rate limits are designed to allow each history record to be read a handful of times.

    3. C

       cui_li

       2024-03-16

       2 upvotes

       Answer should be C. "..To help avoid exceeding the rate limit (error code 429), we recommend relying more heavily on insertReport than loadHistoryScan.." https://docs.snowflake.com/en/user-guide/data-load-snowpipe-rest-apis

    4. A

       Atomic_Gecko

       2024-03-03

       2 upvotes

       C is correct - insertReport should be favored over loadHistory as excessive usage of the latter tends to lead to API throttling

23. Question 23 of 25

    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

    Correct answer: B, C, E

    How others answered

    • BCE100%

    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.

    Adapted from community discussion by 67422cb · 2024-05-20 · 2 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation

    View community discussion4

    Candidate context

    Question 23 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by ARA-C01 or CertExamHQ.

    1. M

       MSIDDIQUI18

       2024-10-23

       1 upvote

       BCE are correct due to the following reasons: For persisted query results of all sizes, the cache expires after 24 hours. Each time the persisted result for a query is reused, Snowflake resets the 24-hour retention period for the result, up to a maximum of 31 days from the date and time that the query was first executed. After 31 days, the result is purged and the next time the query is submitted, a new result is generated and persisted.

    2. 6

       67422cb

       2024-05-20

       2 upvotes

       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.

    3. C

       carloscloud

       2023-12-22

       1 upvote

       F, E, C, B, A is valid. I have a doubt with A, but the rest is fine. Are these questions well posed? Or does it refer only to the features that are explicitly in the documentation? B, C, E 100%, since it is in the documentation explicitly, but F AND B are fine implicitly.

    4. S

       serg_khar

       2023-04-03

       Selected B, C, E1 upvote

       https://docs.snowflake.com/en/user-guide/querying-persisted-results

24. Question 24 of 25

    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

    Correct answer: B, C, D

    How others answered

    • BCD80%
    • ABC20%

    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

    Adapted from community discussion by Acaer · 2024-09-09 · 3 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation

    View community discussion4

    Candidate context

    Question 24 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by ARA-C01 or CertExamHQ.

    1. A

       Acaer

       2024-09-09

       Selected B, C, D3 upvotes

       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

    2. M

       MSIDDIQUI18

       2024-07-03

       2 upvotes

       A: You can specify a WHERE clause to filter data before it is copied into Snowflake. This allows you to select specific rows based on certain conditions. B: When you define the structure of the target table in Snowflake using CREATE PIPE, you can specify the order of columns. This means you can control the order in which incoming data columns are mapped to the target table. C: Similar to reordering columns, you can specify only the columns from the incoming data that you want to copy into the target table. Columns that are not specified in the CREATE PIPE statement will be ignored during the data copy process.

    3. 6

       6c79d6f

       2024-09-09

       Selected B, C, D1 upvote

       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.

    4. A

       akellaanurag

       2024-10-26

       1 upvote

       correct answer is B,C,D 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. For usage examples, see Transforming data during a load. Note that only simple SELECT statements are supported. Filtering using a WHERE clause is not supported.

25. Question 25 of 25

    What is a key consideration when setting up search optimization service for a table?

    • ASearch optimization service works best with a column that has a minimum of 100 K distinct values.
    • BSearch optimization service can significantly improve query performance on partitioned external tables.
    • CSearch optimization service can help to optimize storage usage by compressing the data into a GZIP format.
    • DThe table must be clustered with a key having multiple columns for effective search optimization.

    Show answer

    Correct answer: A

    How others answered

    • A100%

    Explanation

    Correct Answer should be A "At least one of the columns accessed by the query filter operation has on the order of 100,000 distinct values or more." https://docs.snowflake.com/en/user-guide/search-optimization/queries-that-benefit

    Adapted from community discussion by cui_li · 2024-03-18 · 3 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation

    View community discussion3

    Candidate context

    Question 25 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by ARA-C01 or CertExamHQ.

    1. M

       MSIDDIQUI18

       2024-11-11

       2 upvotes

       Correct Answer: A At least one of the columns accessed by the query filter operation has on the order of 100,000 distinct values or more. To determine the number of distinct values, you can use either of the following: • Use APPROX_COUNT_DISTINCT to get the approximate number of distinct values: SELECT APPROX_COUNT_DISTINCT(column1) FROM table1; • Use COUNT(DISTINCT ) to get the actual number of distinct values: SELECT COUNT(DISTINCT c1), COUNT(DISTINCT c2) FROM test_table;

    2. C

       cui_li

       2024-03-18

       3 upvotes

       Correct Answer should be A "At least one of the columns accessed by the query filter operation has on the order of 100,000 distinct values or more." https://docs.snowflake.com/en/user-guide/search-optimization/queries-that-benefit

    3. A

       akellaanurag

       2024-10-26

       1 upvote

       correct answer is A Additionally, the search optimization service does not support the following: External tables.

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

ARA-C01 practice, question 1 of 25