[Jul-2021] SnowPro-Core Pre-Exam Practice Tests | Exam Questions and Answers for SnowPro Core Study Guide
SnowPro Core Certification Exam Certification Sample Questions
NEW QUESTION 16
What happens when a Data Provider revokes privileges to a Share on an object in their source database?
- A. Any additional data arriving after this point in time will not be visible to Data Consumers
- B. A static copy of the object at the time the privilege was revoked is created In the Data Consumers' accounts
- C. The Data Consumers stop seeing data updates and become responsible for storage charges for the object
- D. The object immediately becomes unavailable for all Data Consumers
Answer: D
NEW QUESTION 17
Which of the following statements would be used to export/unload data from Snowflake?
- A. INSERT INTO @stage
- B. COPY INTO @slage
- C. EXPORT TO @stage
- D. EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);
Answer: B
NEW QUESTION 18
True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.
- A. False
- B. True
Answer: A
NEW QUESTION 19
What are the three things customers want most from their enterprise data warehouse solution?
Choose 3 answers
- A. On-premise availability
- B. Open source based
- C. Simplicity
- D. Concurrency
- E. Performance
Answer: C,D,E
NEW QUESTION 20
What privileges are required to execute a task?
- A. A task is an account-level object and can only be executed by the Account Admin role.
- B. Tasks run automatically and do run under any rote.
- C. Tasks are stored in a special database called the utility database and require EXECUTE TASK privilege in the utility database.
- D. To execute a task, you need the EXECUTE TASK.
Answer: D
NEW QUESTION 21
Select the different types of Internal Stages: (Choose three.)
- A. User Stage
- B. Table Stage
- C. Schema Stage
- D. Named Stage
Answer: A,B,D
Explanation:
Reference:
Named-Stage
NEW QUESTION 22
Which interfaces can be used to create and/or manage Virtual Warehouses?
- A. SQL commands
- B. All of the above
- C. Data integration tools
- D. The Snowflake Web Interface (UI)
Answer: B
NEW QUESTION 23
For a multi-cluster Warehouse, the number of credits billed is calculated on:
Select one.
- A. The number of queries that ran using the Warehouse.
- B. The number of users who accessed the Warehouse.
- C. The sue of the Warehouse and the maximum number of clusters configured for the Warehouse.
- D. The size of the Warehouse and the number of clusters that ran within a given time period.
Answer: D
NEW QUESTION 24
Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are:
Choose 2 answers
- A. Temporary Tables
- B. Translent Tables
- C. Provisional Tables
- D. Permanent Tables
Answer: A,B
NEW QUESTION 25
which of the following are valid approaches to loading data into a snowflake table? select all the below that apply.
- A. Bulk copy from an External Stage
- B. Continuous load using Snowpipe REST API
- C. Bulk copy from an Internal Stage
- D. The Snowflake Web Interface (UT) data loading wizard
Answer: A,B,D
NEW QUESTION 26
True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.
- A. True
- B. False
Answer: A
NEW QUESTION 27
When should you consider disabling auto-suspend for a Virtual Warehouse?
Choose 2 answers
- A. When managing a steady workload
- B. When the compute must be available with no delay or lag time
- C. When users will be using compute at different times throughout a 24/7 period
- D. When you don't want to have to manually turn on the Warehouse each time a user needs it
Answer: A,B
NEW QUESTION 28
True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.
- A. True
- B. False
Answer: A
NEW QUESTION 29
When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:
- A. Performance
- B. Concurrency
Answer: B
NEW QUESTION 30
True or False the longer the data retention period, the higher the resulting storage costs.
- A. True
- B. False
Answer: A
NEW QUESTION 31
True or False: The COPY command must specify a File Format in order to execute.
- A. True
- B. False
Answer: A
NEW QUESTION 32
True or False: Snowflake charges a premium for storing semi-structured data.
- A. False
- B. True
Answer: A
NEW QUESTION 33
Which type of table corresponds to a single Snowflake session?
- A. Provisional
- B. Temporary
- C. Transient
- D. Permanent
Answer: B
NEW QUESTION 34
True or False: You can query the files in an External Stage directly without having to load the data into a table.
- A. True
- B. False
Answer: A
NEW QUESTION 35
True or false: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.
- A. False
- B. True
Answer: A
NEW QUESTION 36
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 37
When creating a user it is advisable sable to:
Choose 2 answers
- A. Force an immediate password change
- B. Set the users access to expire within a specified timeframe
- C. Set the user to be initially disabled
- D. Set a default role for the user
- E. Set the number of minutes to unlock to 15 minutes
Answer: A,D
NEW QUESTION 38
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
- A. False
- B. True
Answer: A
NEW QUESTION 39
What is the minimum Snowflake edition that provides data sharing?
- A. Enterprise
- B. Standard
- C. Business Critical Edition
- D. Premier
Answer: A
NEW QUESTION 40
......
Snowflake Exam Practice Test To Gain Brilliante Result: https://www.dumpsking.com/SnowPro-Core-testking-dumps.html
Tested Material Used To SnowPro-Core: https://drive.google.com/open?id=1-ZfOJJSZox4XwcdIJMCpnkkVJqDR0r0t
