Use Free SnowPro-Core Exam Questions that Stimulates Actual EXAM
Get 100% Real SnowPro-Core Free Online Practice Test
NEW QUESTION # 91
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
- A. True
- B. False
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
NEW QUESTION # 92
Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously?
Choose 3 answers
- A. SUM(<< column value >>)
- B. MIN(< < column value>>)
- C. COPY
- D. UPDATE
Answer: A,C,D
NEW QUESTION # 93
Which of the following statements would be used to export/unload data from Snowflake?
- A. COPY INTO @stage
- B. EXPORT TO @stage
- C. INSERT INTO @stage
- D. EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);
Answer: A
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-unload-considerations.html
NEW QUESTION # 94
True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.
- A. True
- B. False
Answer: B
NEW QUESTION # 95
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
- A. To accommodate fluctuations in workload
- B. To accommodate a more complex workload
- C. To accommodate more users
- D. To accommodate more queries
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html
NEW QUESTION # 96
How long does Snowflake retain information in the ACCESS HISTORY view?
- A. 7 days
- B. 14 days
- C. 365 days
- D. 28 days
Answer: B
NEW QUESTION # 97
Which of the following accurately represents how a table fits into Snowflake's logical container hierarchy?
Select one.
- A. Account -> Schema -> Database -> Table
- B. Database -> Table -> Schema -> Account
- C. Database -> Schema -> Table -> Account
- D. Account -> Database -> Schema -> Table
Answer: D
NEW QUESTION # 98
What role is required to use Partner Connect?
- A. SECURITYADMIN
- B. ORGADMIN
- C. SYSADMIN
- D. ACCOUNTADMIN
Answer: A
NEW QUESTION # 99
Which of the following objects can be shared through secure data sharing?
- A. Task
- B. Masking policy
- C. Stored procedure
- D. External table
Answer: D
Explanation:
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:
Tables
External tables
Secure views
Secure materialized views
Secure UDFs
Snowflake enables the sharing of databases through shares, which are created by data providers and "imported" by data consumers.
https://docs.snowflake.com/en/user-guide/data-sharing-intro.html#:~:text=Secure%20Data%20Sharing%20enables%20sharing,External%20tables
NEW QUESTION # 100
When a Pipe is recreated using the CREATE OR REPLACE PIPE command:
- A. Previously loaded files will be ignored
- B. All of the above
- C. The REFRESH parameter is set to TRUE
- D. The Pipe load history is reset to empty
Answer: C
Explanation:
Explanation
NEW QUESTION # 101
How can a Snowflake user optimize query performance in Snowflake? (Select TWO).
- A. Index a table.
- B. Cluster a table.
- C. Enable Time Travel.
- D. Enable the search optimization service.
- E. Create a view.
Answer: B,D
NEW QUESTION # 102
How can a data provider ensure that a data consumer is going to have access to the required objects?
- A. Set the SIMULATED DATA SHARING CONSUMER session parameter to the name of the consumer account for which access is being simulated.
- B. Use the CURRENT_ function to authorize users from a specific account to access rows in a base table.
- C. Enable the data sharing feature in the account and validate the view.
- D. Use the CURRENT_ROLE and CURRENT_USER functions to validate secure views.
Answer: C
NEW QUESTION # 103
Which user object property requires contacting Snowflake Support in order to set a value for it?
- A. MINS TO BYPASS NETWORK POLICY
- B. DISABLED
- C. MINS TO UNLOCK
- D. MINS TO BYPASS MFA
Answer: A
NEW QUESTION # 104
Which of the following statements describes a benefit of Snowflake's separation of compute and storage?
(Choose all that apply.)
- A. Storage expands without the requirement to add more compute
- B. Multiple compute clusters can access stored data without contention
- C. Growth of storage and compute are tightly coupled together
- D. Compute can be scaled up or down without the requirement to add more storage
Answer: A,B,D
Explanation:
Reference:
separate-storage-and-compute-65d2dffd450f
NEW QUESTION # 105
A materialized view should be created when which of the following occurs? (Choose two.)
- A. There is minimal cost associated with running the query.
- B. The base table gets updated frequently.
- C. The query is highly optimized and does not consume many compute resources.
- D. The query consumes many compute resources every time it runs.
- E. The results of the query do not change often and are used frequently.
Answer: B,E
NEW QUESTION # 106
When unloading data to an external stage, what is the MAXIMUM file size supported?
- A. 16 GB
- B. 1 GB
- C. 10 GB
- D. 5 GB
Answer: D
NEW QUESTION # 107
......
BEST Verified Snowflake SnowPro-Core Exam Questions (2024) : https://pass4sure.practicedump.com/SnowPro-Core-exam-questions.html