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

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

Add to Whishlist

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?

Become a Premium Member for full access
  Unlock Premium Member

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?

Become a Premium Member for full access
  Unlock Premium Member

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 154

Report Export Collapse

When can you use an Azure Resource Manager template?

Become a Premium Member for full access
  Unlock Premium Member

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?

Become a Premium Member for full access
  Unlock Premium Member

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.

Become a Premium Member for full access
  Unlock Premium Member

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.

Become a Premium Member for full access
  Unlock Premium Member

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 159

Report Export Collapse

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

Become a Premium Member for full access
  Unlock Premium Member

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?

Become a Premium Member for full access
  Unlock Premium Member
Total 285 questions
Go to page: of 29
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

DRAG DROP Match the processes to the appropriate scenarios. To answer, drag the appropriate process from the column on the left to its scenario on the right. Each process may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
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 Match the 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.
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 terms to the appropriate descriptions. To answer, drag the appropriate term from the column on the left to its description on the right. Each termmay 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.