[Dec 10, 2023] Free SnowPro Core SnowPro-Core Official Cert Guide PDF Download
Snowflake SnowPro-Core Official Cert Guide PDF
NEW QUESTION # 121
True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.
- A. False
- B. True
Answer: A
NEW QUESTION # 122
Which of the following significantly improves the performance of selective point lookup queries on a table?
- A. Search Optimization Service
- B. Zero-copy Cloning
- C. Clustering
- D. Materialized Views
Answer: C
NEW QUESTION # 123
True or False: AWS Private Link provides a secure connection from the Customer's on-premise data center to the Snowflake.
- A. False
- B. True
Answer: A
NEW QUESTION # 124
The PUT command: (Choose two.)
- A. Automatically creates a File Format object
- B. Automatically encrypts files
- C. Automatically uses the last Stage created
- D. Automatically compresses files using Gzip
Answer: B,D
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/put.html
NEW QUESTION # 125
True or False: Snowflake charges a premium for storing semi-structured data.
- A. False
- B. True
Answer: A
Explanation:
Reference:
premium-for-storing-semi-structured-data
NEW QUESTION # 126
Data storage for individual tables can be monitored using which commands and/or object(s)?
Choose 2 answers
- A. SHOW STORAGE BY TABLE;
- B. SHOW TABLES;
- C. Information Schema -> TABLE_STORAGE_METRICS
- D. Information Schema -> TASLE_HISTORY
Answer: B,D
NEW QUESTION # 127
True or False: Snowflake charges additional fees to Data providers for each share they create.
- A. True
- B. False
Answer: A
NEW QUESTION # 128
The Snowflake Search Optimization Services supports improved performance of which kind of query?
- A. Queries against tables larger than 1 TB
- B. Queries against a subset of columns in a table
- C. Selective point lookup queries
- D. Queries against large tables where frequent DML occurs
Answer: C
Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/search-optimization-service.html#:~:text=The%20search%20optimiza
%20point,OBJECT%2C%20and%20ARRAY%20columns)
NEW QUESTION # 129
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
- A. Remove semi-structured data types
- B. Remove all dates and timestamps.
- C. Avoid using embedded characters such as commas for numeric data types
- D. Load files that are approximately 100-250 MB (or larger)
- E. Load files that are approximately 25 MB or smaller.
Answer: C,D
Explanation:
https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html
NEW QUESTION # 130
What does Snowflake's search optimization service support?
- A. External tables
- B. Casts on table columns (except for fixed-point numbers cast to strings)
- C. Tables and views that are not protected by row access policies
- D. Materialized views
Answer: C
NEW QUESTION # 131
Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:
- A. Scaling out
- B. Scaling rhythmically
- C. Scaling max
- D. Scaling Up
Answer: D
NEW QUESTION # 132
A user has an application that writes a new Tile to a cloud storage location every 5 minutes.
What would be the MOST efficient way to get the files into Snowflake?
- A. Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest
- B. Create a task that runs a copy into operation from an external stage every 5 minutes
- C. Create a task that puts the files in an internal stage and automate the data loading wizard
- D. Create a task that runs a GET operation to intermittently check for new files
Answer: A
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
NEW QUESTION # 133
Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?
- A. Increases the latency staging and accuracy when loading the data
- B. Optimizes the virtual warehouse size and multi-cluster setting to economy mode
- C. Allows a user to import the files in a sequential order
- D. Allows optimization of parallel operations
Answer: D
NEW QUESTION # 134
By default, which Snowflake role is required to create a share?
- A. ACCOUNTADMIN
- B. ORGADMIN
- C. SHAREADMIN
- D. SECURITYADMIN
Answer: C
NEW QUESTION # 135
True or False: You can resize a Virtual Warehouse while queries are running.
- A. True
- B. False
Answer: A
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html
NEW QUESTION # 136
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
- A. Pipe
- B. Stream
- C. External stage
- D. Task
Answer: A
Explanation:
Snowpipe enables loading data from files as soon as they're available in a stage. This means you can load data from files in micro-batches, making it available to users within minutes, rather than manually executing COPY statements on a schedule to load larger batches.
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
NEW QUESTION # 137
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 EVENT_TIMESTAMP, USER_NAME
FROM ACCOUNT_USAGE.ACCESS_HISTORY; - B. SELECT EVENT_TIMESTAMP, USER_NAME
FROM ACCOUNT_USAGE.LOGIN_HISTORY; - C. SELECT EVENT_TIMESTAMP, USER_NAME
FROM table(information_schema.login_history_by_user()) - D. SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME
FROM ACCOUNT_USAGE.USERS;
Answer: B
NEW QUESTION # 138
What is the minimum Snowflake edition that provides data sharing?
- A. Business Critical Edition
- B. Standard
- C. Enterprise
- D. Premier
Answer: B
NEW QUESTION # 139
True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.
- A. False
- B. True
Answer: A
Explanation:
Explanation
NEW QUESTION # 140
In which scenarios would a user have to pay Cloud Services costs? (Select TWO).
- A. Compute Credits = 200 Credits Cloud Services = 26
- B. Compute Credits = 80 Credits Cloud Services = 5
- C. Compute Credits = 120 Credits Cloud Services = 10
- D. Compute Credits = 50 Credits Cloud Services = 10
- E. Compute Credits = 10 Credits Cloud Services = 9
Answer: B,C
NEW QUESTION # 141
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
- A. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
- B. QUERY_TIMEOUT_IN_SECONDS
- C. STATEMENT_TIMEOUT__IN__SECONDS
- D. MAX_CONCURRENCY__LEVEL
Answer: A
Explanation:
Explanation
The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get its chance of running on the warehouse. The query will quit after reaching this limit.
By default, the value of this parameter is 0 which mean the queries will wait indefinitely in the waiting queue
https://community.snowflake.com/s/article/Warehouse-Concurrency-and-Statement-Timeout-Parameters#:~:text
NEW QUESTION # 142
Which clients does Snowflake support Multi-Factor Authentication (MFA) token caching for? (Select TWO).
- A. Python connector
- B. GO driver
- C. Spark connector
- D. Node.js driver
- E. ODBC driver
Answer: A,E
NEW QUESTION # 143
True or False: A Virtual Warehouse can be resized while suspended.
- A. True
- B. False
Answer: A
Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-of-resizing-a-suspended-warehouse
NEW QUESTION # 144
Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:
- A. Scaling rhythmically
- B. Scaling out
- C. Scaling max
- D. Scaling Up
Answer: B
Explanation:
https://docs.snowflake.com/en/user-guide/warehouses-considerations.html#scaling-up-vs-scaling-out
"Scale out by adding warehouses to a multi-cluster warehouse"
NEW QUESTION # 145
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)
- A. Key-pair authentication
- B. Federated authentication
- C. OCSP authentication
- D. OAuth
- E. TLS 1.2
- F. SCIM
Answer: A,B,D
NEW QUESTION # 146
......
Free SnowPro-Core Exam Dumps to Improve Exam Score: https://www.passleadervce.com/SnowPro-Core/reliable-SnowPro-Core-exam-learning-guide.html
Exam SnowPro-Core: New Brain Dump Professional - PassLeaderVCE: https://drive.google.com/open?id=1qS3y5C7e9nulW1U4yy2utaVsKBUOvdl0