ExamGecko
Login
Home / Microsoft / DP-900 / List of questions
Ask Question

Microsoft DP-900 Practice Test - Questions Answers, Page 16

List of questions

Question 151

Report
Export
Collapse

Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance.

Which Azure service should you use?

Azure HDInsight
Azure HDInsight
Azure SQL Database
Azure SQL Database
Azure Cosmos DB
Azure Cosmos DB
SQL Server on Azure virtual machines
SQL Server on Azure virtual machines
Suggested answer: B

Explanation:

Section: Describe how to work with relational data on Azure

Reference: https://azure.microsoft.com/en-us/services/sql-database/#features

asked 02/10/2024
Patrick Thiel
36 questions

Question 152

Report
Export
Collapse

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?

Microsoft SQL Server Management Studio (SSMS)
Microsoft SQL Server Management Studio (SSMS)
Azure Data Studio
Azure Data Studio
Azure CLI
Azure CLI
Azure PowerShell
Azure PowerShell
Suggested answer: B

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/

asked 02/10/2024
Maurice Nicholson
33 questions

Question 153

Report
Export
Collapse

You have an e-commerce application that reads and writes data to an Azure SQL database.

Which type of processing does the application use?

stream processing
stream processing
batch processing
batch processing
Online Analytical Processing (OLAP)
Online Analytical Processing (OLAP)
Online Transaction Processing (OLTP)
Online Transaction Processing (OLTP)
Suggested answer: D

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/

asked 02/10/2024
Ahti Paju
34 questions

Question 154

Report
Export
Collapse

When can you use an Azure Resource Manager template?

to automate the creation of an interdependent group of Azure resources in a repeatable way
to automate the creation of an interdependent group of Azure resources in a repeatable way
to apply Azure policies for multi-tenant deployments
to apply Azure policies for multi-tenant deployments
to provision Azure subscriptions
to provision Azure subscriptions
to control which services and feature administrators and developers can deploy from the Azure portal
to control which services and feature administrators and developers can deploy from the Azure portal
Suggested answer: A

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

asked 02/10/2024
Melih Sivrikaya
37 questions

Question 155

Report
Export
Collapse

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?

role-based access control (RBAC)
role-based access control (RBAC)
Dynamic Host Configuration Protocol (DHCP)
Dynamic Host Configuration Protocol (DHCP)
Domain Name Service (DNS)
Domain Name Service (DNS)
a database-level firewall
a database-level firewall
Suggested answer: D

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/

asked 02/10/2024
ftere yagoglu
32 questions

Question 156

Report
Export
Collapse

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.

database
database
item
item
container
container
partition
partition
Suggested answer: A, C

Explanation:

Section: Describe how to work with non-relational data on Azure

Reference:

https://docs.microsoft.com/en-us/azure/cosmos-db/set-throughput

asked 02/10/2024
Siza Motha
30 questions

Question 157

Report
Export
Collapse

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.

the throughput
the throughput
the read region
the read region
the partition key
the partition key
the API
the API
Suggested answer: A, C

Explanation:

Section: Describe how to work with non-relational data on Azure

Reference: https://www.sqlshack.com/start-your-journey-with-azure-cosmos-db/

asked 02/10/2024
Luca Arcuri
28 questions

Question 158

Report
Export
Collapse

Your company is designing a data store that will contain student data. The data has the following format.

Microsoft DP-900 image Question 18 90533 10022024020006000000

Which type of data store should you use?

graph
graph
key/value
key/value
object
object
columnar
columnar
Suggested answer: D

Explanation:

Section: Describe how to work with non-relational data on Azure

asked 02/10/2024
Vasco Ricardo Ribeiro
30 questions

Question 159

Report
Export
Collapse

Which storage solution supports role-based access control (RBAC) at the file and folder level?

Azure Disk Storage
Azure Disk Storage
Azure Data Lake Storage
Azure Data Lake Storage
Azure Blob storage
Azure Blob storage
Azure Queue storage
Azure Queue storage
Suggested answer: B

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

asked 02/10/2024
Prabith Balagopalan
37 questions

Question 160

Report
Export
Collapse

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?

Archive
Archive
Hot
Hot
Cool
Cool
Suggested answer: A

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

asked 02/10/2024
Andy Hodges
39 questions
Total 285 questions
Go to page: of 29
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

You have an application that runs on Windows and requires access to a mapped drive. Which Azure service should you use?
DRAG DROP Match the data processing languages to the appropriate real-time analytics services. To answer, drag the appropriate language from the column on the left to its service on the right. Each language may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
DRAG DROP Match the Azure SQL services to the appropriate use cases. To answer, drag the appropriate service from the column on the left to its use case on the right. Each service may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
DRAG DROP Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process. Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.
DRAG DROP You have a table named Sales that contains the following data. You need to query the table to return the average sales amount per day. The output must produce the following results. How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.
Your company recently reported sales from the third quarter. You have the chart shown in the following exhibit. Which type of analysis is shown in the fourth quarter?
DRAG DROP Match the database normalization terms to the appropriate descriptions. To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
DRAG DROP Match the Azure Data Lake Storage terms to the appropriate levels in the hierarchy. To answer, drag the appropriate term from the column on the left to its level on the right. Each term may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
HOTSPOT Select the answer that correctly completes the sentence.
You have a banking application that transfers money in to and out of accounts. Of which type of solution is this is an example?