1 / 11

SnowPro Core Certification Exam Questions

PassQuestion provides the latest SnowPro Core Certification Exam Questions to make you familiar with actual exam question format and exam pattern.

examquestionsonline
Download Presentation

SnowPro Core Certification Exam Questions

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SnowPro Core Free Questions SnowPro Core Free Questions SnowPro Core Certification Exam SnowPro Core Certification Exam https://www.passquestion.com/ https://www.passquestion.com/SnowPro-Core SnowPro-Core.html .html

  2. Question 1 Question 1 When a pipe is recreated using the CREATE on REPLAC PIPE command: Select one. When a pipe is recreated using the CREATE on REPLAC PIPE command: Select one. A. The Pipe load history is reset to empty A. The Pipe load history is reset to empty B. The REFRESH parameter is set to TRUE B. The REFRESH parameter is set to TRUE C. Previously loaded files will be ignored C. Previously loaded files will be ignored D. All of the above D. All of the above Answer: A Answer: A

  3. Question 2 Question 2 Select the different types of Internal Stages: (Choose three.) Select the different types of Internal Stages: (Choose three.) A. Named Stage A. Named Stage B. User Stage B. User Stage C. Table Stage C. Table Stage D. Schema Stage D. Schema Stage Answer: A,B,C Answer: A,B,C

  4. Question 3 Question 3 Which statement best describes Snowflake tables? Which statement best describes Snowflake tables? A. Snowflake tables are logical representations of underlying physical data A. Snowflake tables are logical representations of underlying physical data B. Snowflake tables ate the physical instantiation of data loaded Into Snowflake B. Snowflake tables ate the physical instantiation of data loaded Into Snowflake C. Snowflake tables require that clustering keys be defined to perform optimally C. Snowflake tables require that clustering keys be defined to perform optimally D. Snowflake tables are owned by a user D. Snowflake tables are owned by a user Answer: A Answer: A

  5. Question 4 Question 4 What happens when a Data Provider revokes privileges to a Share on an object in their source What happens when a Data Provider revokes privileges to a Share on an object in their source database? database? A. The object immediately becomes unavailable for all Data Consumers A. The object immediately becomes unavailable for all Data Consumers B. Any additional data arriving after this point in time will not be visible to Data Consumers B. Any additional data arriving after this point in time will not be visible to Data Consumers C. The Data Consumers stop seeing data updates and become responsible for storage charges for the C. The Data Consumers stop seeing data updates and become responsible for storage charges for the object object D. A static copy of the object at the time the privilege was revoked is created In the Data Consumers' D. A static copy of the object at the time the privilege was revoked is created In the Data Consumers' accounts accounts Answer: A Answer: A

  6. Question 5 Question 5 Which of the following statements about data sharing are true? choose 2 answers Which of the following statements about data sharing are true? choose 2 answers A. New objects created by a Data Provider are automatically shared with existing Data Consumers & A. New objects created by a Data Provider are automatically shared with existing Data Consumers & Reader Accounts Reader Accounts B. All database objects can be included In a shared database B. All database objects can be included In a shared database C. Reader Accounts are created and funded by Data Prowlers C. Reader Accounts are created and funded by Data Prowlers D. Shared databases are read-only D. Shared databases are read-only Answer: C,D Answer: C,D

  7. Question 6 Question 6 Which of the following statements is true of Snowflake? Which of the following statements is true of Snowflake? A. It was built specifically for the cloud A. It was built specifically for the cloud B. It was built as an on-premises solution and then ported to the cloud B. It was built as an on-premises solution and then ported to the cloud C. It was designed as a hybrid database to allow customers to store data either on premises or in the C. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud cloud D. It was built for Hadoop architecture D. It was built for Hadoop architecture E. It's based on an Oracle Architecture E. It's based on an Oracle Architecture Answer: A Answer: A

  8. Question 7 Question 7 What is the recommended method for loading data into Snowflake? What is the recommended method for loading data into Snowflake? A. Load row by row A. Load row by row B. Load data in batch B. Load data in batch C. Load data by writing it In the Snowflake Web Interface (UI) C. Load data by writing it In the Snowflake Web Interface (UI) D. Load data via frequent, angle row DML's D. Load data via frequent, angle row DML's Answer: B Answer: B

  9. Question 8 Question 8 What is the lowest Snowflake edition that offers Time Travel up to 90 days. What is the lowest Snowflake edition that offers Time Travel up to 90 days. A. standard Edition A. standard Edition B. Premier Edition B. Premier Edition C. Enterprise Edition C. Enterprise Edition D. Business Critical Edition D. Business Critical Edition Answer: C Answer: C

  10. Question 9 Question 9 Which of the following statements are true of Virtual Warehouses? (Choose all that apply.) 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 A. Customers can change the size of the Warehouse after creation B. A Warehouse can be resized while running B. A Warehouse can be resized while running C. A Warehouse can be configured to suspend after a period of inactivity C. A Warehouse can be configured to suspend after a period of inactivity D. A Warehouse can be configured to auto-resume when new queries are submitted D. A Warehouse can be configured to auto-resume when new queries are submitted Answer: B,C Answer: B,C

  11. Question 10 Question 10 Select the three types of tables that exist within Snowflake. Select the three types of tables that exist within Snowflake. Choose 3 answers Choose 3 answers A. Temporary A. Temporary B. Transient B. Transient C. Provisioned C. Provisioned D. Permanent D. Permanent Answer: A,B,D Answer: A,B,D

More Related