What Is Snowflake?: 10 practice questions

Question 1 of 10

Which description best captures Snowflake?

1. AA client driver that provides storage without query processing
2. BA private-cloud appliance used only for business intelligence dashboards
3. CA local database package dedicated to storing structured tables
4. DA self-managed cloud data platform that combines storage, processing, and analytics

Question 2 of 10

Which responsibility does Snowflake handle as part of its self-managed service?

1. AOngoing platform maintenance, upgrades, tuning, and software updates
2. BChoosing the business meaning and quality rules for customer data
3. CDeciding which employees should receive each business role
4. DWriting every analytical query that a customer organization needs

Question 3 of 10

A strict rows-and-columns table, a JSON document, and an image file arrive together. In that order, how does Snowflake classify them?

1. AStructured, semi-structured, and unstructured
2. BStructured, unstructured, and semi-structured
3. CUnstructured, semi-structured, and structured
4. DSemi-structured, structured, and unstructured

Question 4 of 10

Where does Snowflake run its virtual compute instances and persistent storage?

1. AOn customer-managed private-cloud hosts selected for each query
2. BInside client drivers that applications install on their servers
3. COn public-cloud infrastructure used by the Snowflake service
4. DOn customer laptops as an installed desktop database

Question 5 of 10

Which workload area focuses on ingesting, transforming, and delivering data?

1. AData engineering
2. BApplications and collaboration
3. CAI and machine learning
4. DAnalytical insight consumption

Question 6 of 10

What is the relationship between Snowsight and a Snowflake driver?

1. ASnowsight hosts persistent storage while a driver supplies the compute layer
2. BBoth connect to the same service, but one is a web UI and the other supports applications
3. CBoth install separate private copies of Snowflake for isolated local use
4. DA driver is the Snowflake platform while Snowsight is an unrelated reporting product

Question 7 of 10

Which task remains a customer decision even though Snowflake is self-managed?

1. APerforming the platform's ongoing infrastructure upgrades and tuning
2. BChoosing what data to use and who should be allowed to access it
3. CReplacing failed platform hardware used by Snowflake virtual compute
4. DInstalling and patching the Snowflake service software on physical servers

Question 8 of 10

A team wants engineering, analytics, and AI workloads to use current data without maintaining separate platform software. Which Snowflake characteristic best fits both constraints?

1. AA private-cloud database whose upgrades remain the customer's responsibility
2. BIntegrated workload features delivered through a self-managed data platform
3. CA dashboard service that excludes ingestion and machine-learning work
4. DA local SQL engine installed separately for each workload team

Question 9 of 10

A regulated team requires the complete data platform to run on its own on-premises hardware and forbids public-cloud infrastructure. What conclusion follows?

1. AThe team can select private hardware while Snowflake manages its local operating system
2. BThat deployment requirement is incompatible with the documented Snowflake service model
3. CSnowsight can convert Snowflake into an on-premises installation for the team
4. DAn ODBC driver can host Snowflake storage and compute inside the private network

Question 10 of 10

Three teams need to ingest data, analyze trends, and share controlled access while avoiding synchronized copies in separate systems. Which platform idea addresses the combined need?

1. ARestrict the platform to structured tables and dashboard queries
2. BUse a client driver as the shared persistent data repository
3. CMove each workload to a separate local database installation
4. DBring integrated workloads to the data within Snowflake