SnowPro Core Certification SnowPro-Core Sample Questions Reliable

Prepare for the Actual SnowPro Core SnowPro-Core Exam Practice Materials Collection

NEW QUESTION # 94
Which of the following is true of Snowpipe via REST API?
Choose 2 answers

• A. Snowflake automatically manages the compute required to execute the Pipe's copy into commands
• B. All COPY INTO options are available fluting pipe creation
• C. Snowpipe keeps track of which files it has loaded
• D. you can only use it on internal Stages

Answer: A,C

NEW QUESTION # 95
A user needs to create a materialized view in the schema MYDB.MYSCHEMA.
Which statements will provide this access?
A)

B)

C)

D)

• A. Option A
• B. Option B
• C. Option D
• D. Option C

Answer: A

NEW QUESTION # 96
Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

• A. Data encryption
• B. External stages
• C. Tri-Secret Secure
• D. Time Travel
• E. Fail-safe

Answer: D,E

NEW QUESTION # 97
Which of the following is the Snowflake Account_Usage.Metering_History view used for?

• A. Compiling an account's average cloud services cost over the previous month
• B. Gathering the hourly credit usage for an account
• C. Summarizing the throughput of Snowpipe costs for an account
• D. Calculating the funds left on an account's contract

Answer: B

NEW QUESTION # 98
True or False: During data unloading, only JSON and CSV files can be compressed.

• A. False
• B. True

Answer: A

NEW QUESTION # 99
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

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

Answer: B

Explanation:
Explanation
Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:

https://docs.snowflake.com/en/user-guide/warehouses-overview.html

NEW QUESTION # 100
User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.
Which command will show all privileges granted to that schema?

• A. SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING
• B. SHOW GRANTS TO USER INQUISITIVE_PERSON
• C. SHOW GRANTS OF ROLE DATA_SCIENCE
• D. SHOW GRANTS ON ROLE DATA_SCIENCE

Answer: A

NEW QUESTION # 101
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

• A. False
• B. True

Answer: A

Explanation:
By default, COPY INTO location statements separate table data into a set of output files to take advantage of parallel operations. The maximum size for each file is set using the MAX_FILE_SIZE copy option. The default value is 16777216 (16 MB) but can be increased to accommodate larger files. The maximum file size supported is 5 GB for Amazon S3, Google Cloud Storage, or Microsoft Azure stages. To unload data to a single output file (at the potential cost of decreased performance), specify the SINGLE = true copy option in your statement. You can optionally specify a name for the file in the path.

NEW QUESTION # 102
Which of the following can be used when unloading data from Snowflake? (Choose two.)

• A. When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.
• B. By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.
• C. Use the ENCODING file format option to change the encoding from the default UTF-8.
• D. Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.
• E. The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.

Answer: A,B

NEW QUESTION # 103
Which of the following is true of Snowpipe via REST API?
Choose 2 answers

• A. All COPY INTO options are available fluting pipe creation
• B. Snowpipe keeps track of which files it has loaded
• C. Snowflake automatically manages the compute required to execute the Pipe's copy into commands
• D. you can only use it on internal Stages

Answer: A,B

NEW QUESTION # 104
When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

• A. For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.
• B. The user must have the ORGADMIN role available in at least one account to link accounts for replication.
• C. Shares attached to listings in remote regions can be viewed from any account in an organization.
• D. The listing is replicated into all selected regions automatically, the data is not.
• E. There is no need to have a Snowflake account in the target region, a share will be created for each user.

Answer: B,E

NEW QUESTION # 105
What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

• A. Enterprise
• B. Standard
• C. Business Critical Edition
• D. Premier

Answer: A

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

NEW QUESTION # 106
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 # 107
What actions will prevent leveraging of the ResultSet cache? (Choose two.)

• A. Changing a column that is not in the cached query
• B. Executing the RESULTS_SCAN() table function
• C. Clustering of the data used by the query
• D. Stopping the virtual warehouse that the query is running against
• E. Removing a column from the query SELECT list

Answer: B,E

NEW QUESTION # 108
A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true?
Choose 2 answers

• A. The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous
• B. The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within the previous 24 hour period
• C. The ''24 hour'' on the percomputed results gets renewed every time the exact query is executed
• D. The exact query win ALWAYS return me precomputed result set for the RESULT_CACHE_ACTIVE = time period

Answer: B,C

NEW QUESTION # 109
Snowflake is designed for which type of workloads? (Choose two.)

• A. OLTP (Transactional) workloads
• B. On-premise workloads
• C. Concurrent workloads
• D. OLAP (Analytics) workloads

Answer: A,D

Explanation:
Explanation/Reference: https://blog.couchbase.com/its-the-workload-stupid/

NEW QUESTION # 110
What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?
Select one.

• A. START_AFTCR_CREATE = TRUE/FALSE
• B. INITTIALLY_SUSPENDED = TRUE/FALSE
• C. START_TTIME = 60 // (seconds from now)
• D. START.TIME = CURRENT.DATE()

Answer: B

NEW QUESTION # 111
Which formats are supported for unloading data from Snowflake?
Choose 2 answers

• A. ORC
• B. Delimited (CSV, TSV, etc.)
• C. JSON
• D. Avro

Answer: B,C

NEW QUESTION # 112
......

Ace Snowflake SnowPro-Core Certification with Actual Questions Jan 09, 2024 Updated: https://pass4sure.examstorrent.com/SnowPro-Core-exam-dumps-torrent.html