Topic 1: Exam pool A
When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).
A.
Use multi-clustered warehousing to scale out warehouse capacity
B.
Scale up the warehouse size to allow Queries to execute faster
C.
Stop and start the warehouse to clear the queued queries
D.
Migrate some queries to a new warehouse to reduce load
E.
Limit user access to the warehouse so fewer queries are run against it.
Use multi-clustered warehousing to scale out warehouse capacity
Migrate some queries to a new warehouse to reduce load
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).
A.
Materialized views
B.
Sequences
C.
Procedures
D.
Tables
E.
Secure User Defined Functions (UDFs)
Tables
Secure User Defined Functions (UDFs)
Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared:
Which of the following can be executed/called with Snowpipe?
A.
A User Defined Function (UDF)
B.
A stored procedure
C.
A single copy_into statement
D.
A single insert__into statement
A single copy_into statement
Which data type can be used to store geospatial data in Snowflake?
A.
Variant
B.
Object
C.
Geometry
D.
Geography
Geography
Where would a Snowflake user find information about query activity from 90 days ago?
A.
account__usage . query history view
B.
account__usage.query__history__archive View
C.
information__schema . cruery_history view
D.
information__schema - query history_by_ses s i on view
account__usage . query history view
A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH. Which of the following statements will accommodate this request?
A.
ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
B.
GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;
C.
GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
D.
GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;
GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;
Which copy INTO command outputs the data into one file?
A.
SINGLE=TRUE
B.
MAX_FILE_NUMBER=1
C.
FILE_NUMBER=1
D.
MULTIPLE=FAISE
SINGLE=TRUE
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
Enterprise Edition
Materialized views require Enterprise Edition. To inquire about upgrading, please contact Snowflake Support.
https://docs.snowflake.com/en/sql-reference/sql/create-materializedview.html#:~:text=Materialized-views-require-Enterprise-Edition,upgrading%2C-please-contact-Snowflake-Support.
What is the recommended file sizing for data loading using Snowpipe?
A.
A compressed file size greater than 100 MB, and up to 250 MB
B.
A compressed file size greater than 100 GB, and up to 250 GB
C.
A compressed file size greater than 10 MB, and up to 100 MB
D.
A compressed file size greater than 1 GB, and up to 2 GB
A compressed file size greater than 100 MB, and up to 250 MB
Explanation: https://www.phdata.io/blog/how-to-optimize-snowpipe-dataload/#:~:
text=Snowpipe-is-typically-used-to,data-within-one%2Dmin
ute-intervals.
Which statement about billing applies to Snowflake credits?
A.
Credits are billed per-minute with a 60-minute minimum
B.
Credits are used to pay for cloud data storage usage
C.
Credits are consumed based on the number of credits billed for each hour that a
warehouse runs
D.
Credits are consumed based on the warehouse size and the time the warehouse is running
Credits are consumed based on the warehouse size and the time the warehouse is running
Explanation: Snowflake credits are used to pay for the consumption of resources on Snowflake. A Snowflake credit is a unit of measure, and it is consumed only when a customer is using resources, such as when a virtual warehouse is running, the cloud services layer is performing work, or serverless features are used.
https://docs.snowflake.com/en/user-guide/what-are-credits.html
| Page 9 out of 50 Pages |
| Previous |
Copyright © - All Rights Reserved