Identify considerations for relational data on Azure

A data analyst has written two SELECT queries that each return customer names from different regional tables, and both queries produce columns with identical data types. The analyst wants a single result set that stacks the rows from both queries into one list, automatically removing any duplicate customer names that appear in both regions. Which SQL keyword should the analyst use?

A sales analyst needs a query that returns the total order amount for each customer from an Orders table. Each customer has many rows, and the analyst wants one summary row per customer showing the sum of the order amounts. Which SQL clause is required to produce this per-customer aggregation?

A sales analyst runs a query against an Azure SQL Database and only wants to see the 10 highest-value orders. They combine an ORDER BY clause that sorts the results in descending order by order amount. Which additional clause should they use to restrict the query so that only the first 10 rows are returned?

A data analyst at a retail company runs a query against the Customers table to produce a list of the countries where the company has customers. The raw column contains many repeated country values, but the analyst wants each country to appear only once in the results. Which SQL keyword should be added to the SELECT statement to achieve this?

A reporting analyst runs a query against a SQL table that stores employee records. The column is named 'annual_comp', but the exported report must display the heading 'Annual Salary'. Which SQL keyword should the analyst use to rename the column in the query output without changing the underlying table?

A developer wants to automatically write a record into an audit table every time a row is updated in the Orders table, without changing any of the application code that performs the updates. Which database object should be used to achieve this?

A data engineer needs to periodically empty a large staging table so it can be reloaded. All rows must be removed as quickly as possible, but the table structure, columns, and indexes must remain intact. Which SQL statement should be used?

A retail company runs an Azure SQL Database. Analysts complain that queries filtering customer orders by the CustomerEmail column are very slow because the database must scan the entire Orders table each time. A database administrator wants to create a database object that improves the retrieval speed of these lookups without changing the table's data. Which database object should the administrator create?

A development team has built a web application that currently uses a self-hosted PostgreSQL database running on an on-premises Linux server. They want to migrate the database to Azure to eliminate the burden of operating system patching, backups, and high-availability configuration, while keeping full PostgreSQL compatibility so their existing queries and extensions continue to work. Which Azure service should they choose?

A startup is deploying a new relational database for a single web application. The team has no database administrators and wants Microsoft to handle nearly all maintenance tasks, including operating system patching, SQL engine updates, automated backups, and high availability, so the developers can focus only on the database schema and queries. Which Azure SQL family option requires the least operational management effort from the team?

A development team is deploying an open-source WordPress content management system to Azure. The application natively uses a MySQL database backend. The team wants a fully managed database service so they do not have to patch the operating system or manage database engine updates themselves, while keeping compatibility with the existing MySQL schema. Which Azure data service should they choose?

A finance team frequently needs to convert amounts between currencies inside many different SELECT queries. They want to encapsulate the conversion logic so it can accept input values and return a single computed value that can be used directly within a column expression. Which relational database object should they create?

A startup is launching a new customer-facing web application backed by a single relational database. The team has no dedicated database administrator and wants Microsoft to handle patching, backups, and high availability automatically. They do not need operating system access or the ability to run cross-database queries. Which Azure relational service best fits these requirements while minimizing administrative overhead?

A startup is building a new customer-facing web application with a relational backend. Traffic is unpredictable, with long idle periods overnight followed by unpredictable bursts. The team has no database administrators and wants to minimize infrastructure management while automatically scaling compute and pausing during inactivity to reduce costs. Which Azure relational service best fits these requirements?

A financial services company is migrating an on-premises SQL Server database to Azure. Their security team requires that the database be deployed into a private virtual network with a native private IP address, but the team does not want to manage the underlying operating system or apply SQL Server patches manually. Which Azure relational service best meets these requirements?

A company is migrating an on-premises SQL Server database to Azure. The application relies on SQL Server Agent jobs, cross-database queries, and the Service Broker feature. The team wants a fully managed PaaS solution that requires minimal application code changes while supporting these instance-level features. Which Azure SQL option should they choose?

A company is migrating an on-premises SQL Server application to Azure. The application relies heavily on SQL Server Agent jobs for scheduled maintenance and on cross-database queries that reference multiple databases on the same instance. The team wants a fully managed PaaS service so they no longer patch the operating system, while retaining near-full compatibility with these instance-level features. Which Azure service should they choose?

A developer at a retail company needs to add several new customer records into an existing 'Customers' table in an Azure SQL Database. The table structure already exists and should not be changed. Which SQL statement should the developer use?

A reporting analyst needs a single result set that combines each order with the corresponding customer name. The orders are stored in an Orders table and customer details are in a Customers table, linked by a CustomerID column present in both tables. Which SQL keyword should be used to bring the matching rows from both tables together?

A developer at a retail company needs to change the unit price of several existing products in the Products table without deleting or adding any rows. Which SQL statement should the developer use?