Microsoft DP-900 Practice Test - Questions Answers, Page 16
List of questions
Question 151
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance.
Which Azure service should you use?
Explanation:
Section: Describe how to work with relational data on Azure
Reference: https://azure.microsoft.com/en-us/services/sql-database/#features
Question 152
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database.
You need to embed documents and query results into a SQL notebook.
What should you use?
Explanation:
Section: Describe how to work with relational data on Azure
Reference:
https://www.mssqltips.com/sqlservertip/5997/create-sql-server-notebooks-in-azure-data-studio/
Question 153
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
You have an e-commerce application that reads and writes data to an Azure SQL database.
Which type of processing does the application use?
Explanation:
Section: Describe how to work with relational data on Azure
OLTP is designed to serve as a persistent data store for business or front-end applications. OLTP administers day to day transaction of an organization.
Reference:
https://sqlwizard.blog/2020/03/15/sql-server-oltp-vs-olap/
Question 154
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
When can you use an Azure Resource Manager template?
Explanation:
Section: Describe how to work with relational data on Azure
You can automate deployments and use the practice of infrastructure as code. In code, you define the infrastructure that needs to be deployed
To implement infrastructure as code for your Azure solutions, use Azure Resource Manager templates (ARM templates). The template is a JavaScript Object Notation (JSON) file that defines the infrastructure and configuration for your project. The template uses declarative syntax, which lets you state what you intend to deploy without having to write the sequence of programming commands to create it. In the template, you specify the resources to deploy and the properties for those resources.
Reference: https://docs.microsoft.com/en-us/azure/azure-resource-manager/templates/overview
Question 155
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
You have an Azure SQL database that you access directly from the Internet.
You recently changed the public IP address of your computer.
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?
Explanation:
Section: Describe how to work with relational data on Azure
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/
Question 156
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution. (Choose two.) NOTE: Each correct selection is worth one point.
Explanation:
Section: Describe how to work with non-relational data on Azure
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/set-throughput
Question 157
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
You have an Azure Cosmos DB account that uses the Core (SQL) API.
Which two settings can you configure at the container level? Each correct answer presents a complete solution. (Choose two.) NOTE: Each correct selection is worth one point.
Explanation:
Section: Describe how to work with non-relational data on Azure
Reference: https://www.sqlshack.com/start-your-journey-with-azure-cosmos-db/
Question 158
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Your company is designing a data store that will contain student data. The data has the following format.
Which type of data store should you use?
Explanation:
Section: Describe how to work with non-relational data on Azure
Question 159
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Which storage solution supports role-based access control (RBAC) at the file and folder level?
Explanation:
Section: Describe how to work with non-relational data on Azure
Reference:
https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control
Question 160
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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?
Explanation:
Section: Describe how to work with non-relational data on Azure
Reference:
https://cloud.netapp.com/blog/azure-blob-storage-pricing-the-complete-guide-azure-cvo-blg#H1_4
Question