Prepstellar
Get the app

COF-C03 · Practice set 2 of 2

Snowflake Platform Features and Data Objects: 10 practice questions

10 questions · Untimed · Free

10 free COF-C03 practice questions on Snowflake Platform Features and Data Objects, with an explanation for every answer. Untimed. The full mock exam and the timed version are in the app.

Set 2 · Snowflake Platform Features and Data Objects · 10 questions Read the lesson

  1. Question 1 of 10

    Which table type stores its data and metadata files in customer-managed external cloud storage?

    1. AHybrid table
    2. BDynamic table
    3. CSnowflake table
    4. DApache Iceberg table
    Show the answer

    Iceberg tables retain data and metadata files in an external location managed by the customer, fitting existing lake and lakehouse storage.

    Next → 1 / 10

  2. Question 2 of 10

    Which feature continuously loads row-level data with low latency without first loading from files?

    1. ASnowpipe Streaming
    2. BCOPY INTO <table>
    3. CSnowpipe
    4. DDynamic tables
    Show the answer

    Snowpipe Streaming uses SDKs or a REST API for continuous row-level ingestion, unlike the two file-oriented loading paths.

    Next → 2 / 10

  3. Question 3 of 10

    Which table type provides row locking and enforced unique and referential integrity constraints?

    1. AApache Iceberg table
    2. BDynamic table
    3. CHybrid table
    4. DSnowflake table
    Show the answer

    Hybrid tables combine indexed random access, row locking, and integrity enforcement for transactional workloads.

    Next → 3 / 10

  4. Question 4 of 10

    Which pairing correctly distinguishes aggregate and window functions?

    1. AAggregates stream rows continuously; windows load staged files
    2. BAggregates return one summary value; windows calculate across row partitions
    3. CAggregates build applications; windows deploy container workloads
    4. DAggregates enforce row locks; windows manage external table files
    Show the answer

    Aggregate functions summarize a related row set into one value, while window functions preserve a partitioned calculation context for operations such as running totals.

    Next → 4 / 10

  5. Question 5 of 10

    How do streams and tasks divide transformation responsibilities?

    1. AStreams deploy containers; tasks create interactive Python interfaces
    2. BStreams capture base-object changes; tasks define transformation work
    3. CStreams enforce table constraints; tasks manage external data files
    4. DStreams build semantic metrics; tasks answer freeform questions
    Show the answer

    A stream records changes to a base object, and a task defines work that can act on data to perform transformations.

    Next → 5 / 10

  6. Keep the ones you got wrong

    In the app, every question you miss comes back exactly when you’re about to forget it.

    Get the app

  7. Question 6 of 10

    Which capability is provided by Data Clean Rooms?

    1. ALoading each shared row continuously through a REST API
    2. BEnforcing row locks for every collaborative analytical query
    3. CMoving all shared data into consumer-managed external storage
    4. DRestricting which analyses consumers can run on shared data
    Show the answer

    Data Clean Rooms permit consumers to derive insight through allowed analyses without receiving unrestricted analytical access.

    Next → 6 / 10

  8. Question 7 of 10

    Which capability belongs to the Snowflake Native App Framework?

    1. ASharing applications that package data with business logic
    2. BStoring external Iceberg files permanently in Snowflake-managed warehouse storage
    3. CTurning window calculations into enforced integrity constraints
    4. DReplacing row-level ingestion with periodic staged-file loading
    Show the answer

    The Native App Framework enables an application to combine shared data with related business logic for other Snowflake accounts.

    Next → 7 / 10

  9. Question 8 of 10

    A company has an existing data lake whose files must remain in cloud storage that the company manages. It needs Snowflake query semantics over structured and semi-structured data. Which object is the best fit?

    1. AA hybrid table optimized for transactional locking
    2. BA Snowflake table using only managed storage
    3. CA dynamic table defined only by target freshness
    4. DAn Apache Iceberg table for the existing data lake
    Show the answer

    Iceberg tables combine Snowflake query behavior with data and metadata files retained in customer-managed external storage.

    Next → 8 / 10

  10. Question 9 of 10

    An order service needs low-latency random reads and writes, row locking, and enforced referential integrity while remaining usable with analytical Snowflake data. Which table type should the architect choose?

    1. AA Snowflake table chosen only for warehousing
    2. BA dynamic table chosen only for automatic refresh
    3. CAn Apache Iceberg table
    4. DA hybrid table for indexed transactional access
    Show the answer

    Hybrid tables are the transactional choice because their indexed access, row locking, and constraints can participate in a Unistore workload with analytical data.

    Next → 9 / 10

  11. Question 10 of 10

    A pipeline must react to files as they appear in a stage, but it does not need direct row-level SDK ingestion. Which loading feature fits?

    1. ASnowpipe for staged file-arrival loading
    2. BA dynamic table as the staged-file loader
    3. CCOPY INTO <table> as the continuous row API
    4. DSnowpipe Streaming
    Show the answer

    Snowpipe is the file-arrival path: it loads staged files as they become available, between manual file loading and direct streaming rows.

    Next → 10 / 10

  12. You’ve finished this set

    That’s 10 questions on Snowflake Platform Features and Data Objects. In the app the ones you miss come back exactly when you’re about to forget them.

    Back to the course Get the app
Keep your progress · Get the app

The whole course, on your phone

Lessons you can read, audio you can listen to on the way to work, and practice that remembers what you got wrong.

Get the app