Question 60 A measurement table must reject negative sample quantities. What should the engineer choose? Make a required business value NOT NULL Create a PRIMARY KEY constraint on the record identifier Add a CHECK constraint defining the allowed value range Add a UNIQUE constraint to the business identifier Explanation Correct Answer C:This implementation enforces a domain rule at insert and update time. Incorrect Answers A:This option disallows absent values rather than silently substituting a default. This does not meet the need for a method that enforces a domain rule at insert and update time. B:That technique enforces unique non-null row identity for referenced records. This does not meet the need for a method that enforces a domain rule at insert and update time. D:That technique rejects repeated non-key business values without making them the table's primary key. This does not meet the need for a method that enforces a domain rule at insert and update time.
Question 61 A ledger table's row identifier must always exist and never identify two records. What should the engineer choose? Add a UNIQUE constraint to the business identifier Use an IDENTITY column for automatically generated row keys Create a PRIMARY KEY constraint on the record identifier Use a SEQUENCE object for IDs shared by independent tables Explanation Correct Answer C:Create a PRIMARY KEY constraint on the record identifier fits because it enforces unique non-null row identity for referenced records. That addresses the stated technical constraint. Incorrect Answers A:This option rejects repeated non-key business values without making them the table's primary key. This does not meet the need for a method that enforces unique non-null row identity for referenced records. B:That technique derives a numeric value as each row is inserted into a particular table. This does not meet the need for a method that enforces unique non-null row identity for referenced records. D:This choice generates numeric values independently of one table's identity column. This does not meet the need for a method that enforces unique non-null row identity for referenced records.
Question 62 A billing API filters by account ID and posting date with a highly selective predicate. Which approach would you recommend? Use a ledger table to detect unauthorized tampering Use a rowstore nonclustered index for a selective lookup Use a system-versioned temporal table to retain prior row versions Use a filtered index for a small predictable row subset Explanation Correct Answer B:This implementation fits because it accelerates supported predicates with ordered key entries. That addresses the stated technical constraint. Incorrect Answers A:That technique supplies tamper-evident cryptographic verification of table changes. This does not meet the need for a method that accelerates supported predicates with ordered key entries. C:This choice maintains a history of row changes for point-in-time queries. This does not meet the need for a method that accelerates supported predicates with ordered key entries. D:This alternative indexes only rows matching a specified filter predicate. This does not meet the need for a method that accelerates supported predicates with ordered key entries.
Question 63 A transaction sequence column grows rapidly and needs whole-number capacity beyond INT. What is the most appropriate next design step? Use VARBINARY for arbitrary binary payloads Use BIGINT for the monotonically increasing row number Use BIT for a two-state flag Use DECIMAL(19,4) for the amount column Explanation Correct Answer B:This approach supplies a wide integral range without fractional storage. Incorrect Answers A:This choice stores uninterpreted bytes without character conversion. This does not meet the need for a method that supplies a wide integral range without fractional storage. C:That technique represents a Boolean-like value with compact storage. This does not meet the need for a method that supplies a wide integral range without fractional storage. D:That technique stores fixed-point financial values without binary floating-point rounding. This does not meet the need for a method that supplies a wide integral range without fractional storage.
Question 64 A report selectively queries active subscriptions while most stored rows are historical. What should the engineer choose? Use an external table for supported data virtualization Use graph node and edge tables for stored relationships Use a system-versioned temporal table to retain prior row versions Use a filtered index for a small predictable row subset Explanation Correct Answer D:This implementation fits because it indexes only rows matching a specified filter predicate. That addresses the stated technical constraint. Incorrect Answers A:This option queries external data through a mapped schema without copying every source row first. This does not meet the need for a method that indexes only rows matching a specified filter predicate. B:This alternative represents entities and their many-to-many connections in a graph model. This does not meet the need for a method that indexes only rows matching a specified filter predicate. C:This alternative maintains a history of row changes for point-in-time queries. This does not meet the need for a method that indexes only rows matching a specified filter predicate.
Question 65 An auditor wants cryptographically verifiable integrity evidence for material database transactions. Which implementation is the best fit? Use a ledger table to detect unauthorized tampering Use a filtered index for a small predictable row subset Use graph node and edge tables for stored relationships Use a system-versioned temporal table to retain prior row versions Explanation Correct Answer A:This choice supplies tamper-evident cryptographic verification of table changes. Incorrect Answers B:That technique indexes only rows matching a specified filter predicate. This does not meet the need for a method that supplies tamper-evident cryptographic verification of table changes. C:This choice represents entities and their many-to-many connections in a graph model. This does not meet the need for a method that supplies tamper-evident cryptographic verification of table changes. D:This choice maintains a history of row changes for point-in-time queries. This does not meet the need for a method that supplies tamper-evident cryptographic verification of table changes.
Question 66 A lookup table requires database-generated numeric IDs without application-side allocation. Which technical choice addresses this need? Add a DEFAULT constraint for a missing optional input Use an IDENTITY column for automatically generated row keys Add a UNIQUE constraint to the business identifier Create a PRIMARY KEY constraint on the record identifier Explanation Correct Answer B:This implementation fits because it derives a numeric value as each row is inserted into a particular table. That addresses the stated technical constraint. Incorrect Answers A:This option supplies a declared value when an insert omits the column. This does not meet the need for a method that derives a numeric value as each row is inserted into a particular table. C:This choice rejects repeated non-key business values without making them the table's primary key. This does not meet the need for a method that derives a numeric value as each row is inserted into a particular table. D:That technique enforces unique non-null row identity for referenced records. This does not meet the need for a method that derives a numeric value as each row is inserted into a particular table.
Question 67 A support application records whether an alert has been acknowledged with a binary flag. What should the SQL developer implement? Use UNIQUEIDENTIFIER for externally generated UUID keys Use VARBINARY for arbitrary binary payloads Use DECIMAL(19,4) for the amount column Use BIT for a two-state flag Explanation Correct Answer D:This implementation represents a Boolean-like value with compact storage. Incorrect Answers A:This choice stores globally assigned identifier values rather than sequential integers. This does not meet the need for a method that represents a Boolean-like value with compact storage. B:This option stores uninterpreted bytes without character conversion. This does not meet the need for a method that represents a Boolean-like value with compact storage. C:This alternative stores fixed-point financial values without binary floating-point rounding. This does not meet the need for a method that represents a Boolean-like value with compact storage.
Question 68 An employee review score must remain within the approved one-to-five range. Which technical choice addresses this need? Add a CHECK constraint defining the allowed value range Create a PRIMARY KEY constraint on the record identifier Add a DEFAULT constraint for a missing optional input Add a UNIQUE constraint to the business identifier Explanation Correct Answer A:This approach enforces a domain rule at insert and update time. Incorrect Answers B:That technique enforces unique non-null row identity for referenced records. This does not meet the need for a method that enforces a domain rule at insert and update time. C:This option supplies a declared value when an insert omits the column. This does not meet the need for a method that enforces a domain rule at insert and update time. D:That technique rejects repeated non-key business values without making them the table's primary key. This does not meet the need for a method that enforces a domain rule at insert and update time.
Question 69 A small-read workload spends most time fetching projected attributes after an index seek. Which change most directly meets the requirement? Choose a composite index key that leads with the query's filtering columns Create a table partition function and scheme on a date key Persist a computed column derived from a JSON scalar and index it when supported Use included non-key columns to cover a selective query Explanation Correct Answer D:This approach avoids unnecessary key lookups when a predicate index misses returned columns. Incorrect Answers A:This option supports seek and range access for the recurring predicate. This does not meet the need for a method that avoids unnecessary key lookups when a predicate index misses returned columns. B:This alternative separates large rows into predictable date-based partitions for maintenance. This does not meet the need for a method that avoids unnecessary key lookups when a predicate index misses returned columns. C:This option exposes an often-filtered JSON property as an indexable typed expression. This does not meet the need for a method that avoids unnecessary key lookups when a predicate index misses returned columns.
Question 70 An asset registry needs distinct serial-number values in addition to its internal record keys. Which approach would you recommend? Add a UNIQUE constraint to the business identifier Add a DEFAULT constraint for a missing optional input Make a required business value NOT NULL Use a SEQUENCE object for IDs shared by independent tables Explanation Correct Answer A:This implementation rejects repeated non-key business values without making them the table's primary key. Incorrect Answers B:This alternative supplies a declared value when an insert omits the column. This does not meet the need for a method that rejects repeated non-key business values without making them the table's primary key. C:This option disallows absent values rather than silently substituting a default. This does not meet the need for a method that rejects repeated non-key business values without making them the table's primary key. D:This option generates numeric values independently of one table's identity column. This does not meet the need for a method that rejects repeated non-key business values without making them the table's primary key.