Easy DP-900 practice questions

A retail company collects sales transactions from all its stores throughout the day. Every night at 2 AM, a job runs to consolidate the entire day's transactions, calculate daily totals, and load the results into a data warehouse for reporting. Which characteristic best identifies this as a batch processing workload?

A retail company collects sales transactions throughout the day and processes all of them together once every night to produce a summary report for the previous day. There is no requirement to react to individual transactions as they occur. How should this workload be classified?

A retail company stores customer order records where every record has the same predefined columns, such as OrderID, CustomerName, Quantity, and Price, all conforming to a fixed schema enforced by the storage system. How should this data be classified?

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 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 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?

A database developer needs to permanently remove an entire table, including its structure and all of its data, from an Azure SQL Database. Which SQL statement should they use?

A sales analyst needs to view only the customer records where the Country column equals 'Canada' from an Azure SQL Database table named Customers. Which SQL statement should the analyst use?

A logistics company scans paper invoices and stores the resulting JPEG image files. These files have no fixed schema and cannot be organized into rows and columns. How should this data be classified?

A data analyst is writing a SQL query against a Customers table. They want the result set to include only customers located in the city of Seattle, without changing any stored data. Which SQL clause should they use to accomplish this?

A marketing team collects social media posts that include free-form text captions, embedded images, and short video clips. The team wants to store these files in their raw, native form for later processing. How should this data be classified?

A sales analyst runs a query against an Azure SQL Database to list all customers, and needs the results returned alphabetically by the customer's last name. Which SQL clause should be added to the SELECT statement to achieve this?

At a healthcare company, a team member is responsible for installing and configuring the organization's databases, managing backups, granting and revoking user permissions, and monitoring database performance to ensure availability. Which data role best describes these responsibilities?

A database administrator is documenting a relational table named Employees that contains the columns EmployeeID, FirstName, LastName, and DepartmentID. During the review, a colleague asks what term describes the set of columns that define the structure of each row in this table. Which relational concept is the colleague referring to?

A data engineering team receives a raw export file where each record is on its own line and the fields within each line are separated by tab characters rather than commas. They need to document the file format so downstream tools can parse it correctly. Which plain-text tabular file format does this description match?

A retail company stores customer records where every entry has the same fixed fields: CustomerID (integer), Name (text), Email (text), and DateJoined (date). The data is organized into rows and columns with a predefined schema enforced before any record is saved. How should this data best be classified?

A media company stores thousands of raw video recordings and audio interview files that have no fixed schema or internal tabular structure. An architect needs to classify these files correctly to choose an appropriate storage approach. How should this data be classified?

A retail operations manager wants a Power BI report page to prominently display a single headline number — the current total sales for the day — with no chart, axis, or breakdown. Which Power BI visualization best fits this requirement?

A sales analyst is building a Power BI report and needs a visual that compares total revenue across several product categories for a single time period, making it easy to see which category earned the most. Which visualization type is most appropriate?

A retail company has a business intelligence team that builds Power BI reports. The sales managers only need to open and interact with these published reports on their mobile phones and browsers — they do not create or edit any content. Which Power BI experience is designed for these sales managers?

A business analyst needs to connect to multiple data sources, shape and model the data, and design a new report from scratch on their Windows workstation before publishing it for colleagues to view. Which Power BI component should the analyst use to author the report?

A retail analyst wants to build a Power BI report that shows how total monthly sales revenue has changed continuously over the past three years so viewers can spot seasonal patterns and long-term trends. Which visualization should the analyst choose?

A retail analyst wants to build a Power BI report that shows total sales by store location, plotting each city on a geographic map so regional managers can quickly see how sales are distributed across the country. Which Power BI visualization is most appropriate for this requirement?

A finance analyst needs to present a report page where users can see individual invoice records with columns for invoice number, customer name, amount, and due date. They want the data displayed in rows and columns with sortable headers, rather than a summarized chart. Which Power BI visualization should they use?