Practice Free DP-900 Exam Online Questions
You have an Azure SQL database that you access directly from the internet.
You recently changed your external IP address.
After changing the IP address, you can no longer access the database. You can connect to other resources in Azure
What is a possible cause of the issue?
- A . a database-level firewall
- B . role-based access control (RSAC)
- C . Dynamic Host Configuration Protocol (DHCP)
- D . Domain Name Service (DNS)
A
Explanation:
The Azure SQL Database firewall lets you decide which IP addresses may or may not have access to either your Azure SQL Server or your Azure SQL database.
When creating an Azure SQL Database, the firewall needs to be configured before anyone will be able to access the database. By default, no external access to your SQL Database will be allowed until you explicitly assign permission by creating a firewall rule.
Reference: https://www.sqlshack.com/configuring-the-azure-sql-database-firewall/
You have an e-commerce application that reads and writes data to an Azure SQL database.
Which type of processing does the application use?
- A . stream processing
- B . batch processing
- C . Online Analytical Processing (OLTP)
- D . Online Transaction Processing (OLTP)
D
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-processing
You need to store data in Azure Blob storage for seven years to meet your company’s compliance requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs.
Which storage tier should you use?
- A . Archive
- B . Hot
- C . Cool
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
HOTSPOT
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview
HOTSPOT
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
Which Azure Data Factory component initiates the execution of a pipeline?
- A . a control flow
- B . a trigger
- C . a parameter
- D . an activity
B
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipeline-execution-triggers#trigger-execution
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Explanation:
Box 1: simple lookups
A key/value store associates each data value with a unique key. Most key/value stores only support simple query, insert, and delete operations. To modify a value (either partially or completely), an application must overwrite the existing data for the entire value. In most implementations, reading or writing a single value is an atomic operation.
An application can store arbitrary data as a set of values. Any schema information must be provided by the application. The key/value store simply retrieves or stores the value by key.
Reference: https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview