AMAADOR ACADEMYCertificatesVerify a certificate

DP900

Final check — Microsoft Azure Data Fundamentals (DP-900) Exam Prep

Answer the 42 questions. You need 80% or more to pass. You can retry as many times as you like.

Study the course →

Question 1Which score is required to pass the DP-900 exam, according to Microsoft Learn?
Question 2A web shop stores each order as a JSON document. Some orders include a gift message and a delivery slot; others do not. How should this data be classified?
Question 3An analytics team queries billions of sales rows but usually reads only three of the forty columns. Which file format will make these queries most efficient?
Question 4Which of these is an example of unstructured data?
Question 5A mobile game must store player profiles for users on four continents, with very low latency reads and writes in every region. Which Azure data store fits best?
Question 6A partner sends a daily file where each line is one record and the fields are separated by commas, with a header row. What kind of file is it?
Question 7A payment moves 500 dirhams from account A to account B. The debit succeeds, then the server crashes before the credit. After restart, neither change is visible. Which ACID property made this happen?
Question 8Which description best fits an analytical workload?
Question 9After a server failure, a company needs someone to restore last night's database backup, check user permissions and bring the database back online. Which role normally owns this?
Question 10A sales director asks for an interactive report showing monthly revenue by region, with the ability to drill into cities. Which role should build it?
Question 11Why do organisations usually copy operational data to a separate analytical store instead of reporting directly on the transactional database?
Question 12A team must design a pipeline that removes personal identifiers from patient records before they land in the data lake. Which role is responsible for building this step?
Question 13In a normalized database, the Orders table has a column CustomerID that must match a CustomerID in the Customers table. What is CustomerID in the Orders table?
Question 14What is the main purpose of normalization in a transactional database?
Question 15A developer must add a new column, LoyaltyLevel, to the existing Customers table. Which type of SQL statement will she use?
Question 16Which statements belong to the Data Control Language (DCL)?
Question 17Searches on the Email column of a 20-million-row Customers table are slow. The DBA wants faster lookups without changing the application. What should be created?
Question 18Several apps must apply the same rule when a product is discontinued: update its status, log the change and notify stock. The team wants this logic saved once in the database and run with a product ID parameter. What should they create?
Question 19A start-up is building a new cloud application and wants a relational database with the least possible administration: no OS, no patching, automatic backups. Which option fits best?
Question 20A vendor's application requires a specific older SQL Server version and a monitoring agent installed on the database server's operating system. Which Azure option allows this?
Question 21Which feature describes an Azure SQL Database elastic pool?
Question 22A news website runs on a PHP and MySQL stack. The team wants a managed service with automated backups and patching, without changing its SQL code or drivers. What should it choose?
Question 23Which Azure SQL option is described as near-complete compatibility with the SQL Server instance, delivered as PaaS?
Question 24A mapping start-up uses PostgreSQL with geospatial extensions and wants Microsoft to run patching, backups and high availability. Which service fits?
Question 25An accounting firm is moving a legacy Windows application that reads and writes documents on a mapped network drive (SMB). It wants no code changes. Which service should host the shared drive?
Question 26In Azure Table storage, what uniquely identifies an entity (row)?
Question 27A data team wants Blob storage that supports real directories and fine-grained access control lists, so Spark jobs in Azure Databricks can process big data efficiently. What should they enable?
Question 28Which blob type is designed for data that is only ever added at the end, such as application logs?
Question 29A company already runs an app written with MongoDB drivers. It wants a fully managed, globally distributed database without rewriting the data access code. Which option should it choose?
Question 30Which Azure Cosmos DB API stores data as vertices and edges to model relationships?
Question 31A team loads raw sales files into a data lake first, then runs Spark jobs inside the lake to clean and aggregate them. Which processing pattern is this?
Question 32In a star schema, what does a fact table usually contain?
Question 33An architect wants data kept as open Delta Parquet files in a lake, but queried with SQL like relational tables, with transactions and schema enforcement. Which analytical store does she describe?
Question 34What is OneLake in Microsoft Fabric?
Question 35A data science team needs a managed Apache Spark platform with notebooks in Python and Scala, Delta Lake tables and Unity Catalog governance, and wants the same platform on other clouds too. Which service fits best?
Question 36Every night, data must be copied from an on-premises SQL Server and a partner's SFTP folder into a data lake on a schedule, with retries if a step fails. Which kind of tool orchestrates this?
Question 37A bank wants to block a suspicious card payment within a second of it being made. Which processing approach is required?
Question 38In Real-Time Intelligence in Microsoft Fabric, which item stores streaming data in KQL databases for fast querying?
Question 39A manager wants to see how monthly revenue has changed over the last 24 months on one Power BI page. Which visual is most appropriate?
Question 40A Power BI model has a Sales fact table and a Product dimension table. Users need a reusable Total Sales value that recalculates for any filter they apply. What should the analyst create?
Question 41Which Power BI component is mainly used to share reports, schedule data refresh and pin visuals to dashboards?
Question 42Sensors on 300 delivery trucks send GPS and engine data every few seconds. The team wants a PaaS service that queries the stream with a SQL-like language and writes 1-minute averages to a dashboard. Which service fits?