Snowflake Test-2

Free SnowPro Core Free Mock Tests. Prepare for a data career by doing these tests

Welcome to your Snowflake Test-2

Name

Phone

Q1. In the Snowflake container hierarchy, what container is represented as a URL (for example: https://AB12345.snowflakecomputing.com)?

Select 1 option(s):

Database

Schema

Role

Account

Q2. Which of the following Snowflake Editions provides automatic encryption of all data?

Select 1 option(s):

All Editions provide automatic encryption of all data

Standard

Business Critical

Enterprise

Q3. Scaling in is a manual process (e.g. Max Clusters to min clusters)

Select 1 option(s):

TRUE

FALSE

Q4. What are some differences between a Tech Partner and a Solution Partner?

Select 4 option(s):

Tech Partners offer software, drivers or interfaces

Tech Partners offer consulting and implementation services

Matillion is an example of a Tech Partner

Slalom is an example of a Technology Partner

Solution Partners offer consulting and implementation services

Wipro is an example of a Solution Partner

Q5. Snowflake Administrators should utilize resource monitors to help control costs and avoid unexpected credit usage. Which of the following actions can Snowflake‘s resource monitor triggers initiate automatically? (Check all that apply)

Select 3 option(s):

Roll over query executions to under utilized warehouses

Impose limits on the number of credits that warehouses consume each month

Trigger alert notifications for high usage

Trigger warehouse suspension for high usage

Q6. Data Consumers can be set up to consume data using which two types of consuming accounts?

Select 1 option(s):

Sharing Accounts & Query Accounts

Full Accounts & Reader Accounts

Sharing Accounts & Providing Accounts

Query Accounts & Full Accounts

Q7. Which of the following are performed by the Cloud Services layer?

Select 4 option(s):

Access control

Metadata Management

Query parsing and optimization

User Authentication

Availability Zone Management

Q8. What snowflake objects can be shared?

Select 5 option(s):

Tables

External Tables

Secure Views

Regular Views

Secure Materialized Views

Secure UDFs

Q9. How many number of shares can be created in a Snowflake Account?

Select 1 option(s):

Unlimited

100

Q10. How many number of consumer accounts can be added to a single share?

Select 1 option(s):

100

Unlimited

Q11. When a data is shared with an existing snowflake customer, the compute is charged to

Select 1 option(s):

Provider

Consumer

No Charges applied

Q12. When a data is shared with an non snowflake customer, the compute is charged to

Select 1 option(s):

Provider

Consumer

No Charges applied

Q13. Which of the below is not a role available when Snowflake account is created initially

Select 1 option(s):

Accountadmin

Sysadmin

Useradmin

Developer

Q14. When choosing a geographic deployment region, what factors might an enrollee consider?

Select 2 option(s):

Proximity to the point of service

Number of availability zones within a region

Additional fees charged for regions with geo-political unrest

End-user perceptions of glamorous or trendy geographic locations

Q15. Which of the following are true about the variant data type in Snowflake? Select all that apply.

Select 2 option(s):

Requires a custom mapping for each record type

Optimized storage based on repeated elements

Stored in a separate file format from structured data

Can be queried using JSON path notation

Q16. MFA can be used for connecting to Snowflake via the Snowflake JDBC driver

Select 1 option(s):

TRUE

FALSE

Q17. Which of the following Snowflake Editions automatically store data in an encrypted state?

Select 3 option(s):

Standard

Enterprise

Business Critical

Unattempted

Q18. What are the names of the three Snowflake Editions offered when signing up for a trial account?

Select 3 option(s):

Free-Tier Basic

Standard

Ultra

Enterprise

Business Critical

Q19. Tri-secret requires that customers manage their own keys

Select 1 option(s):

TRUE

FALSE

Q20. Which account supports Query Statement encryption?

Select 1 option(s):

Standard

Enterprise

Enterprise for Sensitive Data (Business Critical)

Virtual Private Snowflake

Q21. What functional category does Looker fall into?

Select 1 option(s):

Select 1 option(s):

Business Intelligence

SQL Editors

Security & Governance

Advanced Analytics

Programmatic Interfaces

Q22. Which statements about Data Integration Tech Partners are true?

Select 4 option(s):

Data Integration Tech Partner software can be used to extract data from other systems.

Data Integration Tech Partner software can be used to carry out transformations.

Snowflake can carry out transformations after loading files staged by partner software (ELT).

Snowflake must be used to extract data from other databases but Data Integration Tech Partner software can load data

Snowflake can be used to extract data from other databases but Data Integration Tech Partner software must be used to do transformations.

Data Integration Tech Partner software should be used to deliver data to stages, Snowflake is then used to load the data

Q23. Three of these terms refer to the same layer. Select the correct 3.

Select 3 option(s):

Compute Layer

Virtual Warehouse Layer

Catalog Layer

Metadata Layer

Query Processing Layer

Q24. Storage can increase or decrease without any effect on virtual warehouse sizes.

Select 1 option(s):

TRUE

FALSE

Q25. Compute can be scaled up, down, out, or in and there is no effect on storage used.

Select 1 option(s):

TRUE

FALSE

Q26. Two Virtual Warehouses can access the same data at the same time without causing contention issues.

Select 1 option(s):

TRUE

FALSE

Q27. What attributes make Snowflake a true SaaS solution?

Select 3 option(s):

No hardware to purchase or configure.

No creation of user accounts or roles is required.

No maintenance upgrades or patches to install.

No data storage costs.

No query processing costs.

Transparent releases don‘t require user intervention.

Q28. Which installment option versions of Snowflake are available?

Select 2 option(s):

Microsoft Cloud Native Accounts

Snowflake-Hosted Accounts (on Amazon cloud infrastructure)

Hybrid On-Premise + Cloud Installation

Enterprise In-House VPC Installation

On-Premise Custom Installation

Snowflake-Hosted Accounts (on Azure cloud infrastructure)

Q29. With Time Travel, a Snowflake administrator can, restore tables, schemas, and databases that have been dropped after the retention period lapses

Select 1 option(s):

TRUE

FALSE

Q30. Snowflake is what kind of offering?

Select 1 option(s):

On Premise Application

Software as a service (SaaS)

Platform as a service (PaaS)

Infrastructure as a service (IaaS)

Q31. True or false: The warehouse cache may be reset if a running warehouse is suspended and then resumed.

Select 1 option(s):

TRUE

FALSE

Q32. Snowflake is HIPAA compliant?

Select 1 option(s):

FALSE

TRUE

Q33. Snowflake account hosted on AWS cannot load data from a file that is staged on GCP or Azure

Select 1 option(s):

TRUE

FALSE

Q34. Which of the following term is associated with the Compute/Warehouse Layer?

Select 1 option(s):

Query Optimization

Query Design

Query Processing

Query Compilation

Query Planning

Q35. Snowflake supports which of the following file formats for data loading? Select all that apply.

Select 3 option(s):

Parquet

PDF

CSV

ORC

Q36. Which of the below two stages are automatically created and need not be configured explicitly by the user

Select 2 option(s):

User Stage

Role Stage

S3 Stage

Internal Stage

Table Stage

External Stage

Q37. What is the recommended file size, to optimize the number of parallel operation for a load

Select 1 option(s):

50 MB to 150 MB (Compressed)

100-250 MB (Compressed)

None of the above

1 MB to 10 MB (Compressed)

Q38. What is the maximum compressed size limit for an individual row in the VARIANT data type column

Select 1 option(s):

18 MB

10 MB

16 MB

100 MB

Q39. When configuring a Warehouse using a Snowflake edition that has Elastic Data Warehousing enabled, what facets or components will you need to configure that are not needed in accounts where Elastic Data Warehousing is not enabled

elect 2 option(s):

Minimum and Maximum Clusters

Scaling Policy

Minimum and Maximum Servers

Auto-Suspend

Auto-Resume

Q40. Snowflake Instances in different regions require separate accounts

Select 1 option(s):

FALSE

TRUE

Q41. The Snowflake Data Marketplace has two types of listings. What are they?

Select 1 option(s):

De-Personalized and Premier

Business Critical and Premier

De-Personalized and Personalized

Standard and Business Critical

Standard and Personalized

Q42. Shares take place between which two groups?

Select 1 option(s):

Sharers & Consumers

Providers & Consumers

Data Writers & Data Readers

Full Accounts & Reading Accounts

Q43. Which of the following are Snowflake view types?

Select 3 option(s):

External

Permanent

Secure

Materialized

Standard

Transient

Q44. Scaling a warehouse IN will decrease the number of clusters. (e.g. Max to Min)

Select 1 option(s):

FALSE

TRUE

Q45. Snowflake has which type of architecture

Select 1 option(s):

None of the above

Shared Disk

Hybrid of Shared disk & shared nothing

Shared Nothing

Q46. Mark the types of Stages available in Snowflake

Select 4 option(s):

External Stage

S3 Stage

Internal Stage

User Stage

Table Stage

Role Stage

Q47. An agreement must be signed by Data Providers before a listing will be made public on Data Marketplace

Select 1 option(s):

FALSE

TRUE

Q48. Which of the following options would result in a column named MY_COL being sandwiched between two percent signs? (Select all that apply)

Select 2 option(s):

Q49. Which command is used to download the data from Snowflake Stage

Select 1 option(s):

DOWNLOAD

PUT

GET

RETRIEVE

Q50. Many logical data models refer to entities, attributes and values. In JSON, and some other semi-structured types, the word “attribute“ is often replaced with what word?

Select 1 option(s):

Values

Rows

Keys

Relationships

Columns

Q51. If you find a data-related tool that is not listed as part of the Snowflake ecosystem, what industry standard options could you check for as a way to easily connect to Snowflake?

Select 2 option(s):

Check to see if the tool can connect to other solutions via ODBC

Check to see if the tool can connect to other solutions via JDBC

Check to see if you can develop a driver and put it on Github

Check to see if there is a petition in the community to create a driver

Q52. How much Snowpipe charge for the files in Queue

Select 1 option(s):

0.06 credits per 1000 files queued

0.06 credits per 100 files queued

0.06 credits per 10000 files queued

No charges for files in Queue

Q53. External Stages require a cloud storage provider

Select 1 option(s):

TRUE

FALSE

Q54. A CAST command will force a value to be output as a certain datatype. Which of the following symbols will result in the “castcolumn“ being output using the VARCHAR datatype?

Select 1 option(s):

Q55. Which SQL statements can work on a cloned Table?

Select 1 option(s):

SELECT command

SHOW command

All of the above

DROP table command

Q56. Among the three different cloud providers, currently which provider do not offer a facility to configure direct, secure connectivity between VPCs (as of year 2020)

Select 1 option(s):

Azure

AWS

GCP

Above all cloud provide the required facility