Q01 - Question
A retail company plans to store information about customers and products in a relational database. The design team must represent these real-world collections of entities. Which design approach should the team use?
Domain: Identify considerations for relational data on Azure (20–25%) Type: Single choice
- A. Represent each collection of entities as a stored procedure.
- B. Represent the entities as a single index with no other structures.
- C. Model each collection of entities, such as customers and products, as a table.
- D. Represent the entities by using SQL as the storage structure.
C is correct.
Explanation: In a relational database, you model collections of entities from the real world as tables. Customers and products are two collections of entities, so each one maps to a table.
A is incorrect: A stored procedure encapsulates programmatic actions. It is not the structure that models a collection of entities.
B is incorrect: An index is a structure that exists in addition to tables. It does not replace tables as the way to model entities.
D is incorrect: SQL is used to communicate with a relational database. It is a language, not a structure that stores entities.
Q02 - Question
A database designer finds that the same customer address is repeated in many rows of an orders table. The designer decides to apply normalization to the schema. Which TWO goals does normalization address?
Domain: Identify considerations for relational data on Azure (20–25%) Type: Multi-select
- A. Encapsulate programmatic actions in a database object.
- B. Minimize data duplication.
- C. Communicate with the database by using a query language.
- D. Enforce data integrity.
B and D are correct.
Explanation: Normalization is a schema design process that minimizes data duplication and enforces data integrity. Repeating the same address in many rows is the kind of duplication that this process reduces.
A is incorrect: Encapsulating programmatic actions is a purpose of other database structures, not a goal of normalization.
C is incorrect: Communicating with a relational database is the purpose of SQL. Normalization is a schema design process and does not provide a query language.
Q03 - Question
A development team is building an application that must send requests to a relational database. Data analysts on the same team also need to communicate with that database. What should both groups use to communicate with the database?
Domain: Identify considerations for relational data on Azure (20–25%) Type: Single choice
- A. Structured Query Language (SQL)
- B. Data normalization
- C. Stored procedures
- D. Database indexes
A is correct.
Explanation: SQL stands for Structured Query Language. It is used to communicate with a relational database, so both the application and the analysts can use it.
B is incorrect: Normalization is a schema design process that minimizes data duplication and enforces data integrity. It is not used to communicate with a database.
C is incorrect: A stored procedure is a database object that encapsulates programmatic actions. It is not the primary method used to communicate with the database.
D is incorrect: An index is a structure that helps improve the speed of access. It is not used to communicate with the database.
Q04 - Question
A database architect needs structures in addition to tables. The structures must help optimize data organization, encapsulate programmatic actions, and improve the speed of access. Which set of database objects should the architect consider?
Domain: Identify considerations for relational data on Azure (20–25%) Type: Single choice
- A. Entities, rows, and columns
- B. Normalization rules, schemas, and SQL statements
- C. Collections, documents, and keys
- D. Views, stored procedures, and indexes
D is correct.
Explanation: A relational database can contain structures in addition to tables that optimize data organization, encapsulate programmatic actions, and improve the speed of access. These structures are views, stored procedures, and indexes.
A is incorrect: Entities, rows, and columns describe how data is modeled in tables. They are not additional database objects beyond tables.
B is incorrect: Normalization is a design process and SQL is a language. These are not database objects in the set of views, stored procedures, and indexes.
C is incorrect: Collections and documents are not the database objects that are described for a relational database in this scenario.
Q05 - Question
A company is designing a transactional application. The application must store and manage its data. What should the company use to store and manage the data?
Domain: Identify considerations for relational data on Azure (20–25%) Type: Single choice
- A. A relational database
- B. A normalization process
- C. A SQL statement
- D. A database view
A is correct.
Explanation: Relational databases are a common way for transactional applications to store and manage data. A relational database fits the requirement to store and manage application data.
B is incorrect: Normalization is a schema design process. It is not a data store.
C is incorrect: A SQL statement is used to communicate with a relational database. It does not store data itself.
D is incorrect: A view is a structure within a relational database. It is not the primary data store for the application.
Q06 - Question
A company plans to migrate several databases to Azure. The databases currently run on SQL Server, PostgreSQL, and MySQL. Which statement describes Azure support for these relational database management systems?
Domain: Identify considerations for relational data on Azure (20–25%) Type: Single choice
- A. Azure supports multiple database services that enable you to run SQL Server, PostgreSQL, and MySQL in the cloud.
- B. Azure supports SQL Server natively, but requires third-party virtual machines for PostgreSQL and MySQL.
- C. Azure supports PostgreSQL and MySQL, but requires on-premises hosting for SQL Server.
- D. Azure supports these systems only if they are converted to a non-relational format.
A is correct.
Explanation: The evidence states that Azure supports multiple database services, enabling you to run popular relational database management systems, such as SQL Server, PostgreSQL, and MySQL, in the cloud.
B is incorrect: Azure supports PostgreSQL and MySQL as relational database services, not just through third-party virtual machines.
C is incorrect: Azure supports SQL Server natively in the cloud; it does not require on-premises hosting.
D is incorrect: Azure supports these systems as relational database management systems; they do not need to be converted to a non-relational format.
Q07 - Question
A development team plans to use a family of Microsoft SQL Server based database services in Azure. Which term collectively describes these services?
Domain: Identify considerations for relational data on Azure (20–25%) Type: Single choice
- A. Azure SQL
- B. Azure data services for MySQL
- C. Azure data services for PostgreSQL
- D. Azure relational database management systems
A is correct.
Explanation: The evidence states that Azure SQL is a collective term for a family of Microsoft SQL Server based database services in Azure.
B is incorrect: Azure data services for MySQL support the MySQL relational database system, not Microsoft SQL Server based services.
C is incorrect: Azure data services for PostgreSQL support the PostgreSQL relational database system, not Microsoft SQL Server based services.
D is incorrect: Azure SQL is the specific collective term for the family of Microsoft SQL Server based database services in Azure.
Q08 - Question
A project manager is preparing a summary of Azure SQL for a planning meeting. Which two statements about Azure SQL are accurate? Select two.
Domain: Identify considerations for relational data on Azure (20–25%) Type: Multiple choice
- A. Azure SQL is a single standalone database service.
- B. Azure SQL is a collective term for a family of database services.
- C. Azure SQL services are based on PostgreSQL.
- D. Azure SQL services are based on Microsoft SQL Server.
B and D are correct.
Explanation: The evidence states that Azure SQL is a collective term for a family of Microsoft SQL Server based database services in Azure.
A is incorrect: Azure SQL is a collective term for a family of services, not a single standalone database service.
C is incorrect: Azure SQL services are based on Microsoft SQL Server, not PostgreSQL.
Q09 - Question
An organization already uses Azure SQL services. A new application team wants to use MySQL, and another team wants to use PostgreSQL. Which statement best describes the Azure options for these teams?
Domain: Identify considerations for relational data on Azure (20–25%) Type: Single choice
- A. Azure data services are available for both MySQL and PostgreSQL.
- B. The teams must migrate their databases to Microsoft SQL Server.
- C. MySQL and PostgreSQL are available only as part of the Azure SQL family.
- D. Azure data services are available for MySQL, but PostgreSQL is not supported.
A is correct.
Explanation: The evidence states that in addition to Azure SQL services, Azure data services are available for other popular relational database systems, including MySQL and PostgreSQL.
B is incorrect: Azure data services are available for MySQL and PostgreSQL, so the teams do not need to migrate to Microsoft SQL Server.
C is incorrect: MySQL and PostgreSQL are supported by separate Azure data services, not as part of the Azure SQL family.
D is incorrect: Azure data services are available for both MySQL and PostgreSQL.
Q10 - Question
A company plans to build a new cloud application and migrate an existing on-premises application to the cloud. How do Azure database services support these plans?
Domain: Identify considerations for relational data on Azure (20–25%) Type: Single choice
- A. Azure supports a range of database services that can be used for both new cloud applications and migrating existing applications.
- B. Azure database services are designed exclusively for new cloud applications.
- C. Azure database services are designed exclusively for migrating existing applications.
- D. Azure requires the use of a single database service for both new and migrated applications.
A is correct.
Explanation: The evidence states that Azure supports a range of database services that you can use to support new cloud applications or migrate existing applications to the cloud.
B is incorrect: Azure database services can support both new cloud applications and migrated applications, not exclusively new ones.
C is incorrect: Azure database services can support both migrated applications and new cloud applications, not exclusively migrated ones.
D is incorrect: Azure supports a range of database services; there is no requirement to use a single database service for both new and migrated applications.