Topic 1: Exam pool A
Which of the following describes external functions in Snowflake?
A.
They are a type of User-defined Function (UDF).
B.
They contain their own SQL code.
C.
They call code that is stored inside of Snowflake.
D.
They can return multiple rows for each row received
They are a type of User-defined Function (UDF).
External functions are user-defined functions that are stored and executed outside of Snowflake. External functions make it easier to access external API services such as geocoders, machine learning models, and other custom code running outside of Snowflake. This feature eliminates the need to export and reimport data when using third-party services, significantly simplifying your data pipelines.
https://docs.snowflake.com/en/sql-reference/externalfunctions.html#:~:text=External-functions-are-user%2Ddefined,code-running-outside-of-Snowflake.
Which cache type is used to cache data output from SQL queries?
A.
Metadata cache
B.
Result cache
C.
Remote cache
D.
Local file cache
Result cache
https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse
Will data cached in a warehouse be lost when the warehouse is resized?
A.
Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
B.
Yes. because the compute resource is replaced in its entirety with a new compute resource.
C.
No. because the size of the cache is independent from the warehouse size
D.
Yes. became the new compute resource will no longer have access to the cache encryption key
Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
What can be used to view warehouse usage over time? (Select Two).
A.
The load HISTORY view
B.
The Query history view
C.
The show warehouses command
D.
The WAREHOUSE_METERING__HISTORY View
E.
The billing and usage tab in the Snowflake web Ul
The WAREHOUSE_METERING__HISTORY View
The billing and usage tab in the Snowflake web Ul
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)
A.
Bytes scanned
B.
Bytes sent over the network
C.
Number of partitions scanned
D.
Percentage scanned from cache
E.
External bytes scanned
Bytes scanned
Number of partitions scanned
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a XSmall Warehouse.
A.
True
B.
False
True
You can experiment the same with snowflake UI.
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
A.
Informatica
B.
Power Bl
C.
Adobe
D.
Data Robot
Data Robot
https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html
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
Load files that are approximately 100-250 MB (or larger)
Avoid using embedded characters such as commas for numeric data types
https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html
Which command can be used to load data into an internal stage?
A.
LOAD
B.
copy
C.
GET
D.
PUT
PUT
https://medium.com/@divyanshsaxenaofficial/snowflake-loading-unloadingof-
data-part-1-internal-stages-7121cc3cc9
What is the default File Format used in the COPY command if one is not specified?
A.
CSV
B.
JSON
C.
Parquet
D.
XML
CSV
https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html
| Page 2 out of 50 Pages |
| Previous |
Copyright © - All Rights Reserved