Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Microsoft DP-900

Microsoft DP-900 Exam Practice Questions (P. 4)

  • Full Access (306 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #31
You need to create an Azure resource to store data in Azure Table storage.
Which command should you run?
  1. A
    az storage share create
  2. B
    az storage account create
  3. C
    az cosmosdb create
  4. D
    az storage container create

Correct Answer:
D
Reference:
https://docs.microsoft.com/en-us/cli/azure/storage/container?view=azure-cli-latest

Question #32
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:


Correct Answer:

 Azure Cosmos DB SQL API accounts provide support for querying items using the Structured Query Language (SQL) syntax.
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/choose-api

Question #33
You need to modify a view in a relational database by adding a new column.
Which statement should you use?
  1. A
    MERGE
  2. B
    ALTER
  3. C
    INSERT
  4. D
    UPDATE

Correct Answer:
B
chatbot-img GPT-4o - Answer
For modifying a view in a relational database, particularly when adding a new column, the 'ALTER' statement is the way to go. This command enables adjustments or changes in the structure of views or tables, such as the addition of new columns. If directly applying changes isn't feasible, creating the view from scratch might be necessary by employing the 'CREATE OR ALTER' function for seamless transitions between view versions.

Question #34
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.
Hot Area:


Correct Answer:

 Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

Question #35
HOTSPOT -
You plan to deploy a PostgreSQL database to Azure.
Which hosting model corresponds to the available deployment options? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:


Correct Answer:

 Reference:
https://azure.microsoft.com/en-us/overview/what-is-saas/
https://azure.microsoft.com/en-us/overview/what-is-paas/

Question #36
Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?
  1. A
    Azure Table storage
  2. B
    Azure Data Lake Storage
  3. C
    Azure Queue storage
  4. D
    Azure Files

Correct Answer:
B
Reference:
https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control

Question #37
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:


Correct Answer:

Question #38
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:


Correct Answer:

 Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/stored-procedures-database-engine?view=sql-server-ver15

Question #39
DRAG DROP -
Match the types of analytics that can be used to answer the business questions.
To answer, drag the appropriate analytics type from the column on the left to its question on the right. Each analytics type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:


Correct Answer:
Incorrect Answer:
Box 1: Diagnostic -
Diagnostic Analytics: At this stage you can begin to answer some of those why questions. Historical data can begin to be measured against other data to answer the question of why something happened in the past. This is the process of gathering and interpreting different data sets to identify anomalies, detect patters, and determine relationships.

Box 2: Prescriptive -
Prescriptive analytics is a combination of data, mathematical models, and various business rules to infer actions to influence future desired outcomes.
Predictive analytics, broadly speaking, is a category of business intelligence that uses descriptive and predictive variables from the past to analyze and identify the likelihood of an unknown future outcome

Box 3: Cognitive -
Reference:
https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/ https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/

Question #40
Which type of database is Azure Database for PostgreSQL?
  1. A
    Platform as a service (PaaS)
  2. B
    Infrastructure as a service (IaaS)
  3. C
    Microsoft SQL Server
  4. D
    on-premises

Correct Answer:
A
Reference:
https://docs.microsoft.com/en-us/azure/postgresql/overview-postgres-choose-server-options

Previous Questions Next Questions

All Pages