An Architect needs to design a Snowflake account and database strategy to store and analyze large amounts of structured and semi-structured dat a. There are many business units and departments within the company. The requirements are scalability, security, and cost efficiency.
What design should be used?

• A.Create a single Snowflake account and database for all data storage and analysis needs, regardless of data volume or complexity.
• B.Set up separate Snowflake accounts and databases for each department or business unit, to ensure data isolation and security.
• C.Use Snowflake's data lake functionality to store and analyze all data in a central location, without the need for structured schemas or indexes
• D.Use a centralized Snowflake database for core business data, and use separate databases for departmental or project-specific data.

Comment: *

Name: *

Email: *

Verification: *

The diagram shows the process flow for Snowpipe auto-ingest with Amazon Simple Notification Service (SNS) with the following steps:
Step 1: Data files are loaded in a stage.
Step 2: An Amazon S3 event notification, published by SNS, informs Snowpipe - by way of Amazon Simple Queue Service (SQS) - that files are ready to load. Snowpipe copies the files into a queue.
Step 3: A Snowflake-provided virtual warehouse loads data from the queued files into the target table based on parameters defined in the specified pipe.

If an AWS Administrator accidentally deletes the SQS subscription to the SNS topic in Step 2, what will happen to the pipe that references the topic to receive event messages from Amazon S3?

• A.The pipe will continue to receive the messages as Snowflake will automatically restore the subscription to the same SNS topic and will recreate the pipe by specifying the same SNS topic name in the pipe definition.
• B.The pipe will no longer be able to receive the messages and the user must wait for 24 hours from the time when the SNS topic subscription was deleted. Pipe recreation is not required as the pipe will reuse the same subscription to the existing SNS topic after 24 hours.
• C.The pipe will continue to receive the messages as Snowflake will automatically restore the subscription by creating a new SNS topic. Snowflake will then recreate the pipe by specifying the new SNS topic name in the pipe definition.
• D.The pipe will no longer be able to receive the messages. To restore the system immediately, the user needs to manually create a new SNS topic with a different name and then recreate the pipe by specifying the new SNS topic name in the pipe definition.

Comment: *

Name: *

Email: *

Verification: *

What are purposes for creating a storage integration? (Choose three.)

• A.Control access to Snowflake data using a master encryption key that is maintained in the cloud provider's key management service.
• B.Store a generated identity and access management (IAM) entity for an external cloud provider regardless of the cloud provider that hosts the Snowflake account.
• C.Support multiple external stages using one single Snowflake object.
• D.Avoid supplying credentials when creating a stage or when loading or unloading data.
• E.Create private VPC endpoints that allow direct, secure connectivity between VPCs without traversing the public internet.
• F.Manage credentials from multiple cloud providers in one single Snowflake object.

Comment: *

Name: *

Email: *

Verification: *

Which of the below commands will use warehouse credits?

• A.SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY FLAKE_ID;
• B.SHOW TABLES LIKE 'SNOWFL%';
• C.SELECT COUNT(*) FROM SNOWFLAKE;
• D.SELECT MAX(FLAKE_ID) FROM SNOWFLAKE;

Comment: *

Name: *

Email: *

Verification: *

A stream stores data with the same columns as the source data but with additional columns.
What are those additional columns?

• A.METADATA$ROW_ID
• B.METADATA$ISUPDATE
• C.METADATA$DELETE
• D.METADATA$ACTION

Comment: *

Name: *

Email: *

Verification: *