SnowPro Advanced Architect

Here you have the best Snowflake SnowPro Advanced Architect practice exam questions

  • You have 100 total questions to study from
  • Each page has 5 questions, making a total of 20 pages
  • You can navigate through the pages using the buttons at the bottom
  • This questions were last updated on November 29, 2024
Question 1 of 100

What built-in Snowflake features make use of the change tracking metadata for a table? (Choose two.)

    Correct Answer: C, D

    Snowflake's built-in features that utilize change tracking metadata for a table include the CHANGES clause and a STREAM object. The CHANGES clause allows for querying change tracking metadata directly, while STREAM objects are specifically designed to track changes in tables for use in data pipelines and other operations.

Question 2 of 100

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

    Correct Answer: C, D

    The Snowflake Connector for Kafka supports the JSON and Avro data formats for the messages. These formats are well-integrated with Snowflake's data storage and processing capabilities, particularly with its VARIANT data type which is designed to handle semi-structured data like JSON and Avro. CSV, XML, and Parquet are not supported formats in the context of Kafka messages within the Snowflake ecosystem.

Question 3 of 100

At which object type level can the APPLY MASKING POLICY, APPLY ROW ACCESS POLICY and APPLY SESSION POLICY privileges be granted?

    Correct Answer: C

    APPLY MASKING POLICY, APPLY ROW ACCESS POLICY, and APPLY SESSION POLICY privileges are granted at the schema level. These policies affect data security and access control within a specific schema, making the schema the appropriate level for these privileges.

Question 4 of 100

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.)

    Correct Answer: B, C

    The commands required to load only file5.csv are those that either specify to load the specific file directly or to reload all files in the stage, including those not previously loaded successfully. Using 'COPY INTO tablea FROM @%tablea FILES = ('file5.csv')' targets the specific file and loads it. Using 'COPY INTO tablea FROM @%tablea' ensures that all files in the stage, including file5.csv, will be loaded. Therefore, options B and C are correct.

Question 5 of 100

A large manufacturing company runs a dozen individual Snowflake accounts across its business divisions. The company wants to increase the level of data sharing to support supply chain optimizations and increase its purchasing leverage with multiple vendors.

The company’s Snowflake Architects need to design a solution that would allow the business divisions to decide what to share, while minimizing the level of effort spent on configuration and management. Most of the company divisions use Snowflake accounts in the same cloud deployments with a few exceptions for European-based divisions.

According to Snowflake recommended best practice, how should these requirements be met?

    Correct Answer: D

    To meet the requirements of increasing data sharing while allowing business divisions to determine what to share with minimal configuration and management effort, the recommended approach involves deploying a Private Data Exchange. This solution aligns with Snowflake's best practices for securely and efficiently sharing data within an organization. Additionally, to address the scenario of European-based divisions using different cloud deployments, replication is used to ensure data can be shared across regions within the Private Data Exchange. This approach maintains the integrity and accessibility of data across diverse geographic locations.