[Feb-2023] DP-900 Free PDF from ExamDumpsVCE [Q34-Q54]

4.7/5 - (7 votes)

Feb-2023 Latest ExamDumpsVCE DP-900 Exam Dumps with PDF and Exam Engine Free Updated Today!

Following are some new DP-900 Real Exam Questions!

NO.34 Select the answer that correctly completes the sentence.

NO.35 You are reviewing the data model shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point

Reference:
https://en.wikipedia.org/wiki/Snowflake_schema
https://azure.microsoft.com/en-us/blog/data-models-within-azure-analysis-services-and-power-bi/

NO.36 To complete the sentence, select the appropriate option in the answer area.

Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

NO.37 Match the Azure Cosmos DB APIs to the appropriate data structures.
To answer, drag the appropriate API from the column on the left to its data structure on the right. Each API may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/faq

NO.38 To complete the sentence, select the appropriate option in the answer area.

NO.39 To complete the sentence, select the appropriate option in the answer area.

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/choose-api

NO.40 For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Explanation
A screenshot of a computer Description automatically generated with medium confidence

NO.41 You are reviewing the data model shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point

Reference:
https://en.wikipedia.org/wiki/Snowflake_schema
https://azure.microsoft.com/en-us/blog/data-models-within-azure-analysis-services-and-power-bi/

NO.42 Which database transaction property ensures that individual transactions are executed only once and either succeed in their entirety or roll back?

isolation

durability

atomicity

consistency

NO.43 For each of the following statements. select Yes if the statement is true. Otherwise, select No. NOTE Each correct selection is worth one point.

NO.44 Which statement is an example of Data Definition Language (DDL)?

SELECT

INSERT

DELETE

DROP

Data Definition Language (DDL) statements defines data structures. Use these statements to create, alter, or drop data structures in a database. These statements include:
ALTER
Collations
CREATE
DROP
DISABLE TRIGGER
ENABLE TRIGGER
RENAME
UPDATE STATISTICS
TRUNCATE TABLE
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/statements

NO.45 Match the Azure services to appropriate requirements.
To answer, drag the appropriate services from the column on the left to its requirement on the right. Each service may be used once. more than once, or not at all.
NOTE: Each correct match is worth one point.

NO.46 To complete the sentence, select the appropriate option in the answer area.

Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described?view=sql-server-ver15

NO.47 For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Reference:
https://azure.microsoft.com/en-us/pricing/details/synapse-analytics/

NO.48 For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

NO.49 You have a table named Sales that contains the following data.

You need to query the table to return the average sales amount 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.

Reference:
https://docs.microsoft.com/en-us/sql/t-sql/functions/avg-transact-sql

NO.50 You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database.
Which type of authentication should you use?

service principal authentication

Azure Active Directory (Azure AD) authentication

SQL authentication

certificate authentication

Section: Describe how to work with relational data on Azure
Explanation/Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-overview

NO.51 For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Reference:
https://docs.microsoft.com/en-us/azure/databricks/data/data-sources/sql-databases-azure
https://docs.microsoft.com/en-us/azure/databricks/scenarios/databricks-stream-from-eventhubs

NO.52 Match the Azure Cosmos DB APIs to the appropriate data structures.
To answer, drag the appropriate API from the column on the left to its data structure on the right. Each API may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

NO.53 To complete the sentence, select the appropriate option in the answer area.

Explanation:
https://powerbi.microsoft.com/en-us/blog/announcing-paginated-reports-in-power-bi-general-availability/

NO.54 To complete the sentence, select the appropriate option in the answer area.

Explanation

Generally speaking, data analytics comes in four types (Figure 1):
Descriptive, to answer the question: What’s happening?
Diagnostic, to answer the question: Why’s happening?
Predictive, to answer the question: What will happen?
Prescriptive, to answer the question: What actions should we take?

Loading …