You need to create an Azure Storage account.Data in the account must replicate outside the Azure region automatically.Which two types of replication can you use for the storage account? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.
Answer(s): B,D
D: Azure Storage offers two options for copying your data to a secondary region:- Geo-redundant storage (GRS)- Geo-zone-redundant storage (GZRS)B: With GRS or GZRS, the data in the secondary region isn't available for read or write access unless there is a failover to the secondary region. For read access to the secondary region, configure your storage account to use read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RAGZRS).
https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy#redundancy-in-a-secondary-region
HOTSPOT (Drag and Drop is not supported)For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point.Hot Area:
Answer(s): A
Box 1: Yes Like IaaS, PaaS includes infrastructure ג€" servers, storage, and networking ג€" but also middleware, development tools, business intelligence (BI) services, database management systems, and more. PaaS is designed to support the complete web application lifecycle: building, testing, deploying, managing, and updating.PaaS allows you to avoid the expense and complexity of buying and managing software licenses, the underlying application infrastructure and middleware, container orchestrators such as Kubernetes, or the development tools and other resourcesBox 2: No You manage the applications and services you develop, and the cloud service provider typically manages everything else.Box 3: No There really is no way to pause / stop billing for your Azure SQL Database.Microsoft's official answer "Yes, you can export your database. Delete the Azure SQL database and that will pause billing. Then when you need it you can create a new database and import your previously exported DB."
https://azure.microsoft.com/en-us/overview/what-is-paas
Which statement is an example of Data Manipulation Language (DML)?
Answer(s): C
Data Manipulation Language (DML) affect the information stored in the database. Use these statements to insert, update, and change the rows in the database.- BULK INSERT - DELETE- INSERT- SELECT- UPDATE- MERGE
https://docs.microsoft.com/en-us/sql/t-sql/statements/statements
You have a SQL query that combines customer data and order data. The query includes calculated columns.You need to create a database object that would allow other users to rerun the same SQL query.What should you create?
Answer(s): B
A view is a virtual table whose contents are defined by a query. A view acts as a filter on the underlying tables referenced in the view. The query that defines the view can be from one or more tables or from other views in the current or other databases.
https://docs.microsoft.com/en-us/sql/relational-databases/views/views
HOTSPOT (Drag and Drop is not supported)To complete the sentence, select the appropriate option in the answer area.Hot Area:
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.
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
Share your comments for Microsoft DP-900 exam with other users:
Question 4:Question 4 is about when to use batch processing.
The DP-900 exam can be tricky if you aren't familiar with Microsoft’s specific cloud terminology. I used the practice questions from free-braindumps.com and found them incredibly helpful. The site breaks down core data concepts and Azure services in a way that actually mirrors the real test. As a resutl I passed my exam.