Sunday , November 3 2024
Breaking News

The Foundations of Schema Design in CockroachDB Exam Answers

The Foundations of Schema Design in CockroachDB Exam Answers:

Quiz 1:

  • now()
  • TIME
  • TIMESTAMPTZ
  • Scale
  • Measure
  • Precision
  • STRING(n)
  • BYTES
  • VARCHAR

Quiz 2:

  • TIMESTAMPTZ
  • TIME
  • now()
  • STRING(n)
  • GEOGRAPHY
  • Collation
  • GEOGRAPHY
  • TIMETZ
  • GEOMETRY

Quiz 3:

  • You need to import JSON data from a third party API
  • You want to store a record of every single video game action ever taken by a player in one JSON object
  • You’re storing data from an app and you know all of the fields and data types ahead of time
  • You need to store 3-dimensional coordinates for player locations in a game in sub-ARRAYs like so: [ [23, 18, 5], [19, 4, 10], [1, 25, 8] ]
  • You need to store a user’s name as a STRING, age as an INT, and test score as a FLOAT all together in one column
  • You need to store a list of phone numbers associated with a user’s account
  • They can help avoid the need for full table scans when querying for a matching key: value pair in a JSON column.
  • Inverted indexes are extremely compact, increasing the efficiency of writing to a JSON column.
  • They increase the efficiency of queries that use less than or greater than
  • They expose data generated from other columns by an expression.
  • They store a homogeneous list of data in every row.
  • They separate each field in a JSON object into a unique index entry.

Quiz 4: Hash

  • When all candidate index keys are monotonically increasing
  • When you’re using a composite index with a TIMESTAMPTZ column as the second column
  • When you’re running a 3-node cluster but are ready to scale out
  • When there are many null values in the column
  • When the column has only a few possible values (such as a BOOLEAN)

Final Assessment:

  • Use the status column as the primary key
  • Create a hash sharded primary key with the check_in column
  • Create a compound primary key that includes the status column as the leading column and the check_in column
  • Precision
  • Scale
  • Accuracy
  • (n)
  • Create a compound key with device_id as the leading column and the alert_time column
  • Create a hash sharded primary key with just the alert_time column
  • Create a separate UUID column to use
  • 3
  • 5
  • 7
  • 9
  • 11
  • It can display a TIMESTAMP with more digits than the application
  • It provides accuracy through the implementation of atomic clocks on the cluster
  • It allows the database to be the source of truth for date and time
  • GEOMETRY
  • Collation
  • GEOGRAPHY
  • The EXPERIMENTAL flag
  • BYTES
  • JSON
  • Letting the database assign UUIDs to a row, which are then used as the primary key
  • Using a compound index key
  • Using the TIMESTAMP data type as the first column of an index
  • Computed Column with a secondary index
  • A regular secondary index on the JSON column
  • Inverted Index
  • STRING
  • Collation
  • GEOGRAPHY
  • VARCHAR

About Clear My Certification

Check Also

AICTE Internships | Work based Learning with Stipend and Certification

AICTE Internships | Work based Learning with Stipend and Certification About the Program: The objective …

Leave a Reply

Your email address will not be published. Required fields are marked *