Topic 1: Exam pool A
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
A company's security audit requires generating a report listing all Snowflake logins (e.g..date and user) within the last 90 days. Which of the following statements will return the required information?
A.
SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME
FROM ACCOUNT_USAGE.USERS;
B.
SELECT EVENT_TIMESTAMP, USER_NAME
FROM table(information_schema.login_history_by_user())
C.
SELECT EVENT_TIMESTAMP, USER_NAME
FROM ACCOUNT_USAGE.ACCESS_HISTORY;
D.
SELECT EVENT_TIMESTAMP, USER_NAME
FROM ACCOUNT_USAGE.LOGIN_HISTORY;
SELECT EVENT_TIMESTAMP, USER_NAME
FROM ACCOUNT_USAGE.LOGIN_HISTORY;
A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?
A.
The primary cluster in the virtual warehouse
B.
The entire virtual warehouse
C.
The database in which the virtual warehouse resides
D.
The Queries currently being run on the virtual warehouse
The entire virtual warehouse
Explanation: https://docs.snowflake.com/en/user-guide/warehousesoverview.
html#:~:text=Similarly%2C-auto%2Dresume-ensures-that,individual%
20clusters-in-the-warehouse.
In which use cases does Snowflake apply egress charges?
A.
Data sharing within a specific region
B.
Query result retrieval
C.
Database replication
D.
Loading data into Snowflake
Data sharing within a specific region
Explanation: Cloud providers apply data egress charges in either of the following use cases:
https://docs.snowflake.com/en/user-guide/billing-datatransfer.
html#:~:text=Cloud-providers-apply-data-egress,out-of-the-cloud-platform.
True or False: A Virtual Warehouse can be resized while suspended.
A.
True
B.
False
True
Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-ofresizing-a-suspended-warehouse
Which Snowflake feature is used for both querying and restoring data?
A.
Cluster keys
B.
Time Travel
C.
Fail-safe
D.
Cloning
Time Travel
Explanation: https://docs.snowflake.com/en/user-guide/dataavailability.
html#:~:text=Snowflake-provides-powerful-CDP-features,days%2
0through-Snowflake-Time-Travel.
What are ways to create and manage data shares in Snowflake? (Select TWO)
A.
Through the Snowflake web interface (Ul)
B.
Through the DATA_SHARE=TRUE parameter
C.
Through SQL commands
D.
Through the enable__share=true parameter
E.
Using the CREATE SHARE AS SELECT * TABLE command
Through SQL commands
Through the enable__share=true parameter
| Page 8 out of 42 Pages |
| Previous |