Download Snowflake SnowPro Certification Practice Exam Questions and more Exams Computer Science in PDF only on Docsity!
Snowflake SnowPro Certification โ 77
Practice Exam Questions
Which statement best described Snowflake tables? (Choose 1)
A) Tables are logical representations of underlying physical data B) Tables are the physical instantiation of data loaded into Snowflake C) Tables require that clustering keys be defined to perform optimally D) Tables are owned by a user - โ โ A
Tables are logical representations of underlying physical data What happens when a database provider revokes privileges to a Share on an object in their source database?
A) The object immediately becomes unavailable for all data consumers B) Any additional data arriving after this point will not be visible to data consumers C) The data consumers stop seeing data updates and become responsible for storage charges D) A static copy of the object at the time is created in the data consumers' accounts - โ โ A
The object is immediately unavailable for all data consumers True or False, Snowpipe via REST API can only reference External Stages as source. - โ โ True True or False, When active, a pipe requires a dedicated virtual warehouse to execute. - โ โ False True or False, You can resize a virtual warehouse while queries are running. - โ โ True Which of the following statements is true of Snowflake?
A) It was built specifically for the cloud B) It was built as an on-premesis solution and then ported to the cloud C) It was designed as a hybrid database to allow customers to store data either on premise or in the cloud D) It was built for Hadoop architecture E) It's based on Oracle architecture - โ โ A
It was build specifically for the cloud Which is the recommended way to load data in Snowflake?
A) Load row by row
C) Provisioned D) Permanent - โ โ A, B and C
Temporary, Transient and Permanent Snowflake recommends that at a MINIMUM, all users of which roles should be enrolled in Multi-Factor Authentication (MFA)?
A) SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN B) SECURITYADMIN, ACCOUNTADMIN, SYSADMIN C) SECURITYADMIN, ACCOUNTADMIN D) ACCOUNTADMIN - โ โ D
At a minimum, ACCOUNTADMIN is recommended to have MFA Which of the following are valid Snowflake Virtual Warehouse Scaling Policies?
A) Custom B) Economy C) Optimized D) Standard - โ โ A, B and D
Custom, Economy and Standard True or False, Each worksheet in the Snowflake UI can be associated with different roles, databases, schemas and Virtual Warehouses. - โ โ True What is the most granular object that Time Travel retention period can be defined on?
A) Account B) Database C) Schema D) Table - โ โ D
Table True or False, In order to execute, the COPY command requires the user to specify a file format. - โ โ False True or False, A user can run a query against the result cache without requiring an active warehouse. - โ โ False The Fail-Safe retention period is how long?
A) 1 Day
1 Minute is the minimum duration charged True or False, All virtual warehouses have access to all data - โ โ True What does the acronym 'ETL' stand for?
A) Extract, Transfer, Load B) Enterprise Transition Loading C) Extract, Transform, Load D) Extract To Location - โ โ C
A database may contain more than one schemas and a schema is a logical grouping of database objects Which of the following statements describes a benefit of Snowflake's separation of compute and storage?
A) Growth and storage and compute are tightly coupled together B) Storage expands without the requirement to add more compute C) Compute can be scaled up or down without the requirement to add more storage
D) Multiple compute clusters can access stored data without contention - โ โ B, C and D
Storage can be expanded and compute can be scaled independently of each other and multiple clusters can access stored data at the same time When a pipe is recreating using the CREATE OR REPLACE PIPE command:
A) The pipe load history is reset to empty B) The REFRESH parameter is set to TRUE C) Previously loaded files will be ignored D) All of the above - โ โ B
The REFRESH parameter is set to TRUE What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?
A) Standard B) Premier C) Enterprise
Clustering represents the way the data is grouped together and stored within Snowflake's micro-partitions Snowflake is designed for which type of workloads? (Choose 2)
A) OLAP (Analytics) workloads B) OLTP (Transactional) workloads C) Concurrent workloads D) On-premise workloads - โ โ A and C
OLAP and Concurrent How many shares can a single data consumer consume?
A) 1 B) 10 C) 100 D) Unlimited E) Depends on Snowflake edition - โ โ D
A data consumer can consume unlimited shares
What is the MAXIMUM compressed row size in Snowflake?
A) 8kb B) 16mb C) 50mb D) 40gb - โ โ B
16mb Which of the following is true of micro-partitioning?
A) It has been known to introduce data-skew B) It requires a partitioning schema to be defined up front C) It's completed using the ordering that occurs when data is inserted/loaded D) It can be disabled within a Snowflake account - โ โ C
Micro-partitioning is completed using the ordering that occurs when data is loaded/inserted Which of the following are options when creating a virtual warehouse?
A) 12am-5am local time B) Only during admin-defined time slots C) When it's provisioning is complete D) After replication - โ โ C For a multi-cluster warehouse, the number of credits billed is calculated on ________ (Choose 1)
A) The number of queries ran B) The size of the warehouse and number of cluster ran within a time period C) The size of the warehouse and maximum clusters configured for the warehouse D) The number of users who accessed the warehouse - โ โ B True or False, It is possible to unload structured data to semi-structured formats like JSON and parquet. - โ โ True Assuming no data changes have occurred, how long are query results stored in the result cache after being last accessed?
A) 1 Hours B) 3 Hours
C) 12 Hours D) 24 Hours - โ โ D
24 Hours For unloading data, which of the following data formats are supported?
A) Delimited (CSV, TSV, etc) B) Avro C) JSON D) ORC E) All of the Above - โ โ E True or False, When a user creates a new role, they are initially assigned ownership of the role and they maintain ownership until it's transferred to another user. - โ โ True True or False, Snowflake allows customers to directly access the micro- partition files that make up each table. - โ โ False When coding in SQL, which of the following can be typed in front of a line to make it a comment rather than be treated as code?
A) Double slash: // B) Double dash: --
record (loading each into a separate row), what FILE_FORMAT property did we change?
A) PRESERVE SPACE B) STRIP OUTER ELEMENT C) DISABLE SNOWFLAKE DATA D) DISABLE AUTO CONVERT E) IGNORE UTF-8 ERROR - โ โ B
STRIP OUTER ELEMENT True or False, A customer needs to have a pre-existing account with AWS or Microsoft Azure before creating a Snowflake account. - โ โ False You own table T1 in schema S1. The schema lives in database D1. In order to grant read-only permissions to this table to a newly created role, R1, you need to...
A) Grant USAGE on D B) Grant SELECT on D C) Grant USAGE on S D) Grant SELECT on S
E) Grant USAGE on T F) Grant SELECT on T1 - โ โ A, C and F
Grant USAGE on D1, USAGE on S1 and SELECT on T Identify system-defined roles in Snowflake from the roles given:
A) ACCOUNTADMIN B) SYSADMIN C) AUDITOR D) ROLEADMIN E) SECURITYADMIN F) PUBLIC - โ โ A, B, E and F
ACCOUNTADMIN, SYSADMIN, SECURITYADMIN and PUBLIC What are the minimum and the maximum number of clusters in a multi-cluster warehouse?
A) Min: 1 Max: 99 B) Min: 1 Max: 100 C) Min: 1 Max: 10
C) HP Virtual Private Cloud D) Cloud Foundry E) Microsoft Azure - โ โ A, B and E
AWS, GCP and Microsoft Azure True or False, After choosing a cloud platform upon account creation you can change it at any time. - โ โ False
Each snowflake account is hosted on one cloud platform. To change, a new account must be created. Which of the following are the key considerations when choosing a specific region for your Snowflake account?
A) Cost B) Proximity to the end-users C) Data sovereignty D) Regulatory requirements E) All of the Above - โ โ E
Cost, Proximity to end-users, Data sovereignty and Regulatory requirements are all key considerations
Informatica, Matillion, Azure data factory are all examples of _____________ partners of the Snowflake partner ecosystem?
A) Data Management B) Business Intelligence C) Data Integration D) Data Science - โ โ Data Integration
Each of these partners provide extract, transform and load functionalities Which of the following programming languages are supported in Snowflake to write User-Defined Functions (UDFs)?
A) SQL B) Java C) JavaScript D) Python - โ โ A and C
SQL and JavaScript are supported for writing UDFs Which Snowflake edition supports transmitting data in encrypted form over the network between VPCs (Virtual Private Cloud)
