Question No : 1
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

• A.Load files that are approximately 25 MB or smaller.
• B.Remove all dates and timestamps.
• C.Load files that are approximately 100-250 MB (or larger)
• D.Avoid using embedded characters such as commas for numeric data types
• E.Remove semi-structured data types

Show Answers

Answer:
Explanation:
https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html

Question No : 2
Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

• A.Pipes
• B.Streams
• C.Tasks
• D.Procedures

Show Answers

Answer:
Explanation:
https://dataterrain.com/how-to-change-tracking-using-table-streams-in-snowflake/#:~:text=A%20stream%20is%20a%20Snowflake,as%20metadata%20about%20 each%20change.

Question No : 3
What tasks can be completed using the copy command? (Select TWO)

• A.Columns can be aggregated
• B.Columns can be joined with an existing table
• C.Columns can be reordered
• D.Columns can be omitted
• E.Data can be loaded without the need to spin up a virtual warehouse

Show Answers

Answer:

Question No : 4
What is the minimum Snowflake edition required to create a materialized view?

• A.Standard Edition
• B.Enterprise Edition
• C.Business Critical Edition
• D.Virtual Private Snowflake Edition

Show Answers

Answer:
Explanation:
Materialized views require Enterprise Edition. To inquire about upgrading,please contact Snowflake Support
https://docs.snowflake.com/en/sql-reference/sql/create-materialized-view.html#:~:text=Materialized%20views%20require%20Enterprise%20Edition,upgrading%2C%20please%20contact%20Snowflake%20Support.

Question No : 5
What happens when a cloned table is replicated to a secondary database? (Select TWO)

• A.A read-only copy of the cloned tables is stored.
• B.The replication will not be successful.
• C.The physical data is replicated
• D.Additional costs for storage are charged to a secondary account
• E.Metadata pointers to cloned tables are replicated

Show Answers

Answer:
Explanation:
Cloned objects are replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database do not contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data.
However, when a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account. https://docs.snowflake.com/en/user-guide/database-replication-considerations.html#:~:text=Replication%20and%20Cloning,-Cloned%20objects%20are&text=However%2C%20when%20a%20cloned%20table,storag e%20usage%20for%20your%20account.

Question No : 6
What happens when an external or an internal stage is dropped? (Select TWO).

• A.When dropping an external stage, the files are not removed and only the stage is dropped
• B.When dropping an external stage, both the stage and the files within the stage are removed
• C.When dropping an internal stage, the files are deleted with the stage and the files are recoverable
• D.When dropping an internal stage, the files are deleted with the stage and the files are not recoverable
• E.When dropping an internal stage, only selected files are deleted with the stage and are not recoverable

Show Answers

Answer:

Question No : 7
What is the default character set used when loading CSV files into Snowflake?

• A.UTF-8
• B.UTF-16
• C.ISO S859-1
• D.ANSI_X3.A

Show Answers

Answer:
Explanation:
https://docs.snowflake.com/en/user-guide/intro-summary-loading.html#:~:text=For%20delimited%20files%20(CSV%2C%20TSV,encoding%20to%20 use%20for%20loading.
For delimited files (CSV, TSV, etc.), the default character set is UTF-8. To use any othercharacters sets, you must explicitly specify the encoding to use for loading. For the list ofsupported character sets, see Supported Character Sets for Delimited Files (in this topic).

Question No : 8
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

• A.Informatica
• B.Power Bl
• C.Adobe
• D.Data Robot

Show Answers

Answer:
Explanation:
https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html

Question No : 9
What data is stored in the Snowflake storage layer? (Select TWO).

• A.Snowflake parameters
• B.Micro-partitions
• C.Query history
• D.Persisted query results
• E.Standard and secure view results

Show Answers

Answer:

Question No : 10
Which Snowflake feature is used for both querying and restoring data?

• A.Cluster keys
• B.Time Travel
• C.Fail-safe
• D.Cloning

Show Answers

Answer:
Explanation:
https://docs.snowflake.com/en/user-guide/data-availability.html#:~:text=Snowflake%20provides%20powerful%20CDP%20features,days%2 0through%20Snowflake%20Time%20Travel.