DP-900 Identify Considerations for Relational Data Practice Questions

Free DP-900 Identify Considerations for Relational Data practice test questions

8 questions from this domain with answers and explanations - different from the samples on the main DP-900 page. Sign up free to practice the full set.

1. Question 1Identify Considerations for Relational Data

   A mid-sized company is migrating its on-premises SQL Server database to Azure. The database uses SQL Server Agent jobs, cross-database queries, and SQL Server Integration Services (SSIS). The company wants to minimize code changes during migration. Which Azure service should they use?

   • AAzure SQL Database (single database)
   • BAzure Cosmos DB
   • CAzure Database for PostgreSQL
   • DAzure SQL Managed InstanceCorrect
   ✓ Correct answer: D

   Azure SQL Managed Instance provides near 100% compatibility with on-premises SQL Server, including support for SQL Server Agent jobs, cross-database queries, and SSIS packages. It runs a managed SQL Server instance that provides these SQL Server-specific features while minimizing migration effort and code changes. Managed Instance is designed specifically to ease migration for organizations with complex SQL Server dependencies.

   Why the other options are wrong

   • AAzure SQL Database (single database) is incorrect because while it supports many SQL Server features, it does not support SQL Server Agent jobs, SSIS packages, or cross-database queries in the same way, requiring significant application refactoring.
   • BAzure Cosmos DB is incorrect because it is a NoSQL database for document and key-value data, fundamentally incompatible with relational SQL Server applications.
   • CAzure Database for PostgreSQL is incorrect because it is a different database engine that would require significant code changes and does not support SQL Server-specific features.
2. Question 2Identify Considerations for Relational Data

   In a relational database, what uniquely identifies each row in a table?

   • AForeign key
   • BPrimary keyCorrect
   • CStored procedure
   • DIndex
   ✓ Correct answer: B

   A primary key is a column or combination of columns that uniquely identifies each row in a table. Every table must have exactly one primary key, and its values must be unique and non-null. The primary key enforces entity integrity by ensuring that each record can be uniquely identified and distinguished from all other records in the table, forming the foundation for relational data organization and foreign key relationships.

   Why the other options are wrong

   • AForeign key is incorrect because a foreign key references a primary key in another table for establishing relationships, not for uniquely identifying rows within the current table.
   • CStored procedure is incorrect because stored procedures are executable code objects that perform operations, not identifiers for table rows.
   • DIndex is incorrect because while indexes improve query performance, they do not uniquely identify rows; an index is a separate data structure used for faster data retrieval.
3. Question 3Identify Considerations for Relational Data

   Fabrikam has an existing on-premises PostgreSQL database that powers their line-of-business application. They want to migrate to Azure with minimal application code changes. Which Azure service should they use?

   • AAzure Database for PostgreSQLCorrect
   • BAzure SQL Database
   • CAzure Cosmos DB for PostgreSQL
   • DAzure SQL Managed Instance
   ✓ Correct answer: A

   Azure Database for PostgreSQL is the purpose-built Azure service for PostgreSQL database workloads, providing full compatibility with on-premises PostgreSQL installations and requiring minimal application code changes for migration. The fully managed service handles patching, backups, high availability, and scaling automatically. Applications using PostgreSQL drivers and connection strings can connect without modification, making it the optimal choice for straightforward PostgreSQL migrations.

   Why the other options are wrong

   • BAzure SQL Database is incorrect because SQL Database is designed for SQL Server workloads; migrating from PostgreSQL would require schema translation and code changes.
   • CAzure Cosmos DB for PostgreSQL is incorrect because while this is a PostgreSQL-compatible option, it is specifically designed for distributed, globally-replicated workloads with vector database capabilities, not typical line-of-business applications seeking direct migration.
   • DAzure SQL Managed Instance is incorrect because Managed Instance is optimized for SQL Server, not PostgreSQL, and would require extensive schema and code translation.
4. Question 4Identify Considerations for Relational Data

   In a relational database, what is the term for a column or set of columns that uniquely identifies each row in a table?

   • Aconstraint
   • Bindex
   • CForeign key
   • DPrimary keyCorrect
   ✓ Correct answer: D

   A primary key is the column or set of columns whose values uniquely identify each row in a table, and its values must be unique and non-null. It gives every row a distinct identity that other tables can reference. Uniquely identifying each row is the defining purpose of a primary key.

   Why the other options are wrong

   • AConstraint is a general term for any rule enforced on data, not specifically the column that uniquely identifies a row.
   • BIndex speeds up data retrieval but does not by itself define a row's unique identity.
   • CForeign key references the primary key of another table to enforce relationships, rather than uniquely identifying rows in its own table.
5. Question 5Identify Considerations for Relational DataSelect all that apply

   Which two features does Azure SQL Database provide as a managed service? (Choose two.)

   • AAutomatic backups and point-in-time restoreCorrect
   • BManual operating system patching required by the customer
   • CBuilt-in high availability with an availability SLACorrect
   • DCustomer-managed hardware capacity planning
   ✓ Correct answer: A, C

   As a managed PaaS service, Azure SQL Database automatically backs up database data and transaction logs, enabling point-in-time restore to any moment within the retention period with no manual effort. It also provides built-in high availability through automated failover and redundancy, backed by a published availability service-level agreement (SLA) for uptime. Microsoft manages the underlying OS, patching, and hardware, so customers focus on the database, not the infrastructure.

   Why the other options are wrong

   • BManual operating system patching required by the customer is incorrect because Azure SQL Database is a fully managed PaaS service where Microsoft handles all OS-level patching and maintenance; customers do not manage patching.
   • DCustomer-managed hardware capacity planning is incorrect because Azure manages infrastructure and capacity scaling automatically; customers do not manually plan or provision hardware.
6. Question 6Identify Considerations for Relational Data

   By default, a newly provisioned Azure Database for PostgreSQL server rejects connections from client IP addresses. What must an administrator configure to allow a specific client to connect over the public endpoint?

   • AA new primary key constraint
   • BAn additional nonclustered index
   • CA server-level firewall ruleCorrect
   • DA larger compute service tier
   ✓ Correct answer: C

   By default a managed database server blocks connections from client IP addresses, so you must add a server-level firewall rule that permits the specific address or range that needs access. The rule works at the network layer to decide which clients may reach the public endpoint. It is unrelated to schema features: primary keys enforce uniqueness, indexes speed up queries, and a larger compute tier adds capacity, but none of them authorize a client to connect.

   Why the other options are wrong

   • AA primary key enforces row uniqueness within a table and has nothing to do with which clients may connect.
   • BAn index speeds up query performance; it does not control network access to the server.
   • DIncreasing the compute tier adds capacity but does not authorize a client IP address to connect.
7. Question 7Identify Considerations for Relational Data

   In SQL, statements such as CREATE TABLE, ALTER TABLE, and DROP TABLE belong to which language category?

   • AData Definition Language (DDL), defining database structureCorrect
   • BData Manipulation Language (DML), which reads and changes rows
   • CData Control Language (DCL), granting and revoking permissions
   • DTransaction Control Language (TCL) that commits or rolls back
   ✓ Correct answer: A

   DDL statements define and modify the structure of database objects such as tables, indexes, and schemas - CREATE builds them, ALTER changes them, and DROP removes them. This is distinct from DML (SELECT, INSERT, UPDATE, DELETE) that works with the data inside those objects, from DCL (GRANT, REVOKE) that manages permissions, and from TCL (COMMIT, ROLLBACK) that controls transactions. The listed statements all shape structure, placing them in DDL.

   Why the other options are wrong

   • BDML reads and changes the rows within tables; it does not create or drop the tables themselves.
   • CDCL manages permissions with GRANT and REVOKE, not the definition of tables.
   • DTCL controls transaction boundaries with COMMIT and ROLLBACK, unrelated to defining structure.
8. Question 8Identify Considerations for Relational DataSelect all that apply

   A team is designing relationships between tables in a relational schema. Which TWO of the following are valid types of relationships between two tables? (Choose two.)

   • AOne-to-manyCorrect
   • BMany-to-manyCorrect
   • CColumn-to-row
   • DIndex-to-key
   ✓ Correct answer: A, B

   Relational databases model relationships as one-to-one, one-to-many, and many-to-many. A one-to-many relationship (such as one customer to many orders) is the most common, and a many-to-many relationship (such as students and courses) is typically implemented through a junction table. These describe how rows in one table relate to rows in another.

   Why the other options are wrong

   • CColumn-to-row is not a recognized type of relationship between tables; relationships are defined between rows across tables via keys.
   • DIndex-to-key is not a relationship type; indexes and keys are database objects, not a category of table relationship.

How Identify Considerations for Relational Data is tested

This domain holds 177 of the 717 questions in the DP-900 bank, about 25%. The mix is 121 single-answer multiple choice, 28 multiple-response, 20 true/false, 5 ordering, 2 hotspot and 1 yes/no scenario, so it is worth practising the formats as well as the content.

Once you have a few attempts recorded, CertGrid scores every domain separately and points you at the weakest one, so you can drill Identify Considerations for Relational Data on its own rather than re-running full-length mocks.

Other DP-900 exam domains

• Describe Core Data Concepts199 questions
• Describe Considerations for Non-Relational Data137 questions
• Describe an Analytics Workload204 questions
• All DP-900 practice questions717 total
• Identify Considerations for Relational Data study notesKey concepts
• Microsoft practice examsAll Microsoft

DP-900 Identify Considerations for Relational Data FAQ