Microsoft DP-100: Azure Data Fundamentals Sample Questions
Question 1. You are required to create an Azure Storage account, and the data in the account must replicate automatically outside the Azure region.
Which two of the following replications could you use for the storage account?
- A. zone-redundant storage (ZRS)
- B. read-access geo-redundant storage (RA-GRS)
- C. locally-redundant storage (LRS)
- D. geo-redundant storage (GRS)
Correct Answer: BD
Explanation: D: Azure Storage offers two options to copy data to any secondary region:
- Geo-redundant storage (GRS)
- Geo-zone-redundant storage (GZRS)
B. In GRS- or GZRS-based instances, the data in the secondary region isn’t accessible unless there is a failover to the secondary region. You need to set up your storage account to use the read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS) for reading access to the secondary region.
Reference:
Question 2. Which of the given statement serves as an example of Data Manipulation Language (DML)?
- A. REVOKE
- B. DISABLE
- C. INSERT
- D. GRANT
Correct Answer: C
Question 4. What are the two main characteristics of real-time data processing?
- A. Data is processed periodically
- B. Low latency is expected
- C. High latency is acceptable
- D. Data is processed as it is created
Correct Answer: BD
Explanation: The real-time processing of data involves capturing data in real-time, processing it in a timely manner, and generating reports in real-time (or near-real-time) based on the results.
Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/real-time-processing
Question 5. Which of the given statement serves as an example of Data Manipulation Language (DML)?
- A. REVOKE
- B. DISABLE
- C. CREATE
- D. UPDATE
Correct Answer: D
Reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/statements
Question 6. You are creating an Azure resource for storing data in Azure Table storage.
Which command would you run?
- A. az storage share create
- B. az storage account create
- C. az cosmos DB create
- D. az storage container create
Correct Answer: D
Reference: https://docs.microsoft.com/en-us/cli/azure/storage/container?view=azure-cli-latest
Question 7. Your task is modifying a view in a relational database by adding a new column.
Which of the following statement would you use?
- A. MERGE
- B. ALTER
- C. INSERT
- D. UPDATE
Correct Answer: B
Question 8. Is there a storage solution in Azure that offers native POSIX-compliant access control lists (ACLs)?
- A. Azure Table storage
- B. Azure Data Lake Storage
- C. Azure Queue storage
- D. Azure Files
Correct Answer: B
Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control
Question 9. What type of database is the Azure Database for PostgreSQL?
- A. Platform as a service (PaaS)
- B. Infrastructure as a service (IaaS)
- C. Microsoft SQL Server
- D. on-premises
Correct Answer: A
Reference: https://docs.microsoft.com/en-us/azure/postgresql/overview-postgres-choose-server-options
Question 10. Do you know which storage solution offers file and folder level access control lists (ACLs)?
- A. Azure Data Lake Storage
- B. Azure Queue storage
- C. Azure Blob storage
- D. Azure Cosmos DB
Correct Answer: A
Explanation: As part of its access control model, Azure Data Lake Storage Gen2 supports both Azure role-based access control (Azure RBAC) and POSIX-like access control lists (ACLs).
Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control
Question 11. Which of the following can be considered as a characteristic of batch processing?
- A. The data that is ingested during batch processing should be processed as soon as it is received.
- B. Large datasets should be split up into batches of less than 1 GB before it can be processed.
- C. There is a significant time delay between ingestion of the data and obtaining the data processing results.
- D. Batch processing can only process data that is well-structured.
Correct Answer: D
Question 12. Your company must necessarily implement a relational database in Azure. Which Azure service should you use for minimizing ongoing maintenance?
- A. Azure HDInsight
- B. Azure SQL Database
- C. Azure Cosmos DB
- D. SQL Server on Azure Virtual Machines
Correct Answer: B
Reference: https://azure.microsoft.com/en-us/services/sql-database/#features
Question 13. It is your responsibility to create a set of SQL queries that administrators will use to troubleshoot an Azure SQL database, and you need to embed documents and query results in a SQL notebook.
What should you be using?
- A. Microsoft SQL Server Management Studio (SSMS)
- B. Azure Data Studio
- C. Azure CLI
- D. Azure PowerShell
Correct Answer: B
Reference: https://www.mssqltips.com/sqlservertip/5997/create-sql-server-notebooks-in-azure-data-studio/
Question 14. A web application based on e-commerce reads and writes data to an Azure SQL database. What kind of processing does the application use?
- A. stream processing
- B. batch processing
- C. Online Analytical Processing (OLAP)
- D. Online Transaction Processing (OLTP)
Correct Answer: D
Explanation: Business or front-end applications rely on OLTP as a persistent data storage system. This system manages day-to-day business operations.
Reference: https://sqlwizard.blog/2020/03/15/sql-server-oltp-vs-olap/
Question 15. When is the most appropriate time for using an Azure Resource Manager template?
- A. for automating the creation of an interdependent group of Azure resources in a repeatable way
- B. for applying Azure policies for multi-tenant deployments
- C. for provisioning Azure subscriptions
- D. for controlling which services and features administrators and developers can deploy from the Azure portal
Correct Answer: A
Explanation: The infrastructure as code practice, which involves defining the infrastructure you want to deploy, can automate deployments. Use Azure Resource Manager templates to implement infrastructure as code in your Azure solutions (ARM templates).
You define the infrastructure and configuration of your project in the template, which is a JavaScript Object Notation (JSON) file. This template uses declarative syntax, so you don’t have to write program commands to create the deployment. By defining the properties of the resources in the template, you can deploy them.
Reference: https://docs.microsoft.com/en-us/azure/azure-resource-manager/templates/overview
Question 16. You have recently changed your computer’s public IP address, and you are able to access an Azure SQL database directly from the Internet. It is no longer possible to access the database after changing the IP address, but you can connect to other Azure resources.
What could be a possible cause of this issue?
- A. role-based access control (RBAC)
- B. Dynamic Host Configuration Protocol (DHCP)
- C. Domain Name Service (DNS)
- D. a database-level firewall
Correct Answer: D
Explanation: You can choose which IP addresses are allowed or denied access to your Azure SQL Server or Azure SQL database using the Azure SQL Database firewall. Before anyone can access an Azure SQL Database, the firewall needs to be configured. SQL server is protected by default from external access. Until you explicitly grant permission through a firewall rule, the database will be accessible.
Reference: https://www.sqlshack.com/configuring-the-azure-sql-database-firewall/
Question 17. Which command-line tool will be required for querying the Azure SQL databases?
- A. sqlcmd
- B. bcp
- C. azdata
- D. Azure CLI
Correct Answer: A
Explanation: The sqlcmd utility allows you to enter Transact-SQL statements, system procedures, and script files at the command prompt.
Reference: https://docs.microsoft.com/en-us/sql/tools/overview-sql-tools?view=sql-server-ver15
Question 18. Which of the following statements is an example of Data Definition Language (DDL)?
- A. SELECT
- B. JOIN
- C. UPDATE
- D. CREATE
Correct Answer: D
Explanation: Data Definition Language (DDL) statements define data structures, and are used to create, alter, or drop data structures in a database. These statements include:
- ALTER
- Collations
- CREATE
- DROP
- DISABLE TRIGGER
- ENABLE TRIGGER
- RENAME
- UPDATE STATISTICS
- TRUNCATE TABLE
- INSERT
Reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/statements
Question 19. Your task is to deploy a software as a service (SaaS) application that needs a relational database for Online Transaction Processing (OLTP).
Which Azure service would you be using to support such an application?
- A. Azure Cosmos DB
- B. Azure HDInsight
- C. Azure SQL Database
- D. Azure Synapse Analytics
Correct Answer: C
Explanation: Azure SQL Database is a relational database as well as a managed service.
Reference: https://cloud.netapp.com/blog/azure-cvo-blg-azure-database-review-your-guide-for-database-assessment
Question 20. What are two most important benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database?
- A. access to the latest features
- B. complete control over backup and restore processes
- C. in-database machine learning services
- D. reduced administrative effort to manage the server infrastructure
Correct Answer: AD
Explanation:
- A: Microsoft Azure SQL Database is a fully managed platform as a service (PaaS) database engine that can upgrade, patch, back up, and monitor databases without user interaction.
- B: With multiple resource types, service tiers, and compute sizes, SQL Database provides predictable performance. There is no downtime with dynamic scalability, intelligent optimization built-in, global scalability, and advanced security features. Instead of managing virtual machines and infrastructure, you can focus on rapid application development and accelerating time-to-market.
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview
