SnowPro Core SnowPro-Core Dumps Full Questions with Free PDF Questions to Pass

100% Updated Snowflake SnowPro-Core Enterprise PDF Dumps

NEW QUESTION # 76
User-level network policies can be created by which of the following roles? (Select TWO).

• A. SECURITYADMIN
• B. ROLEADMIN
• C. SYSADMIN
• D. ACCOUNTADMIN
• E. USERADMIN

Answer: A,E

Explanation:
By default, Snowflake allows users to connect to the service from any computer or device IP address. A security administrator (or higher) can create a network policy to allow or deny access to a single IP address or a list of addresses. Network policies currently support only Internet Protocol version 4 (i.e. IPv4) addresses.
An administrator with sufficient permissions can create any number of network policies.
https://docs.snowflake.com/en/user-guide/network-policies.html#:~:text=A%20security%20administrator%20(or%20higher,any%20number%20of%20network%20policies.

NEW QUESTION # 77
What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?

• A. USAGK
• B. WRTTF
• C. OWNERSHIP
• D. READ

Answer: A

NEW QUESTION # 78
True or False: Snowpipe via RFST API can only reference External Stages as source.

• A. True
• B. False

Answer: B

NEW QUESTION # 79
Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

• A. Premium
• B. Business Critical
• C. Standard
• D. Enterprise

Answer: B

Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/privatelink-azure.html

NEW QUESTION # 80
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. GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
• B. GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;
• C. GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;
• D. ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

Answer: C

NEW QUESTION # 81
Fail-safe is unavailable on which table types?

• A. Permanent
• B. Provisional
• C. Transient
• D. Temporary

Answer: C,D

NEW QUESTION # 82
Which of the following languages can be used to implement Snowflake User Defined Functions (UDFs)?
Choose 2 answers

• A. Java
• B. SQL
• C. JavaScript
• D. Python

Answer: B,C

NEW QUESTION # 83
Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

• A. Customers can change the size of the Warehouse after creation
• B. A Warehouse can be configured to suspend after a period of inactivity
• C. A Warehouse can be resized while running
• D. A Warehouse can be configured to auto-resume when new queries are submitted

Answer: B,C

NEW QUESTION # 84
What are the default Time Travel and Fail-safe retention periods for transient tables?

• A. Time Travel - 1 day. Fail-safe - 1 day
• B. Time Travel - 0 days. Fail-safe - 1 day
• C. Transient tables are retained in neither Fail-safe nor Time Travel
• D. Time Travel - 1 day. Fail-safe - 0 days

Answer: D

Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/data-cdp-storage-costs.html#:~:text=Temporary%20and%20Transient

NEW QUESTION # 85
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

• A. Virtual Private Snowflake
• B. Business Critical
• C. Standard
• D. Enterprise

Answer: B

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html#business-critical-edition

NEW QUESTION # 86
What is used to diagnose and troubleshoot network connections to Snowflake?

• A. Snowpark
• B. SnowSQL
• C. SnowCD
• D. Snowsight

Answer: C

NEW QUESTION # 87
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 ACCOUNT_USAGE.LOGIN_HISTORY;
• C. SELECT EVENT_TIMESTAMP, USER_NAME
  FROM table(information_schema.login_history_by_user())
• D. SELECT EVENT_TIMESTAMP, USER_NAME
  FROM ACCOUNT_USAGE.ACCESS_HISTORY;

Answer: B

NEW QUESTION # 88
True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

• A. True
• B. False

Answer: A

Explanation:
Reference: https://docs.snowflake.com/en/user-guide-data-unload.html

NEW QUESTION # 89
Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

• A. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors
• B. The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error
• C. The validation_mode option is used when creating an Internal Stage
• D. validation_mode=return_all_errors is a parameter of the copy command

Answer: A,D

NEW QUESTION # 90
Which of the following statements is true of Snowflake?

• A. It was built as an on-premises solution and then ported to the cloud
• B. It was built for Hadoop architecture
• C. It's based on an Oracle Architecture
• D. It was built specifically for the cloud
• E. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud

Answer: D

NEW QUESTION # 91
True or False: Snowflake's Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

• A. True
• B. False

Answer: A

Explanation:
Explanation
Snowflake is a single, integrated platform delivered as-a-service. It features storage, compute, and global services layers that are physically separated but logically integrated.

NEW QUESTION # 92
True or False the longer the data retention period, the higher the resulting storage costs.

• A. True
• B. False

Answer: A

NEW QUESTION # 93
If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

• A. 0
• B. 1
• C. 2
• D. 3

Answer: D

NEW QUESTION # 94
......

Use Valid Exam SnowPro-Core by DumpTorrent Books For Free Website: https://www.dumptorrent.com/SnowPro-Core-braindumps-torrent.html

Free SnowPro Core SnowPro-Core Official Cert Guide PDF Download: https://drive.google.com/open?id=1BhawZ6-hWuxdYGuHYGsTbkU_EYm8RvJ9