Free Microsoft DP-900 Test Practice Test Questions Exam Dumps [Q34-Q56]

DP-900 Microsoft

admin • July 9, 2022

Free Microsoft DP-900 Test Practice Test Questions Exam Dumps [Q34-Q56]

Rate this post

Free Microsoft DP-900 Test Practice Test Questions Exam Dumps

Prepare Top Microsoft DP-900 Exam Audio Study Guide Practice Questions Edition

Career Potential with Microsoft DP-900 Exam

The Microsoft Certified: Azure Data Fundamentals certification is a foundational certificate but the candidates can still get a lucrative job holding it. Some of the positions that the certified professionals can consider include an IT Administrator, a Systems Administrator, a Junior Data Analyst, a Program Manager, and an Azure Security Engineer. The salary potential for these job roles is an average of $57,630 per annum.

The Microsoft DP-900 (Microsoft Azure Data Fundamentals) is the single exam students will have to overcome if they want to attain the Microsoft Certified: Azure Data Fundamentals certificate. Those who hold this certification can become a developer, data engineer, data administrator, or data analyst.

NEW QUESTION 34
Match the types of data stores to the appropriate scenarios.
To answer, drag the appropriate data store type from the column on the left to its scenario on the right. Each data store type 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/architecture/guide/technology-choices/data-store-overview

NEW QUESTION 35
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.

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

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/create-cosmosdb-resources-portal

NEW QUESTION 37
You have the following SQL query.

NOTE: Each correct selection is worth one point.

NEW QUESTION 38
Match the Azure services to the appropriate locations in the architecture.
To answer, drag the appropriate service from the column on the left to its location on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

NEW QUESTION 39
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/cosmos-db/partitioning-overview

NEW QUESTION 40
To complete the sentence, select the appropriate option in the answer area.

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

NEW QUESTION 41
To complete the sentence, select the appropriate option in the answer area.

NEW QUESTION 42
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/sql/big-data-cluster/connect-to-big-data-cluster?view=sql-server-ver15
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-query-ssms
https://docs.microsoft.com/en-us/azure/mariadb/connect-workbench

NEW QUESTION 43
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. Each location may be used 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.

Explanation

Box 1: The CRM system
Data is extracted from the CRM system.
Box 2: The data warehouse
Data is loaded to the data warehouse.
Box 3: An in-memory data integration tool
The data transformation that takes place usually involves various operations, such as filtering, sorting, aggregating, joining data, cleaning data, deduplicating, and validating data.

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

NEW QUESTION 45
Match the tools to the appropriate descriptions.
To answer, drag the appropriate tool from the column on the left to its description on the right. Each tool may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

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

NEW QUESTION 47
To complete the sentence, select the appropriate option in the answer area.

NEW QUESTION 48
You have a quality assurance application that reads data from a data warehouse.
Which type of processing does the application use?

Online Transaction Processing (OLTP)

batch processing

Online Analytical Processing (OLAP)

stream processing

Section: Describe an analytics workload on Azure
Explanation/Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-processing

NEW QUESTION 49
To complete the sentence, select the appropriate option in the answer area.

Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/massively-parallel-processing-mpp-architecture

NEW QUESTION 50
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

Section: Describe core data concepts
Explanation/Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

NEW QUESTION 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.

NEW QUESTION 52
To complete the sentence, select the appropriate option in the answer area.

Reference:
https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-namespace

NEW QUESTION 53
You have the following SQL query.

NOTE: Each correct selection is worth one point.

NEW QUESTION 54
Which statement is an example of Data Manipulation Language (DML)?

REVOKE

DISABLE

CREATE

UPDATE

Data Manipulation Language (DML) affect the information stored in the database. Use these statements to insert, update, and change the rows in the database.
BULK INSERT
DELETE
INSERT
SELECT
UPDATE
MERGE
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/statements

NEW QUESTION 55
You have an Azure SQL database that you access directly from the internet.
You recently changed your external IP address.
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?

a database-level firewall

role-based access control (RSAC)

Dynamic Host Configuration Protocol (DHCP)

Domain Name Service (DNS)

NEW QUESTION 56
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 apply Azure policies for multi-tenant deployments

to provision Azure subscriptions

to control which services and feature administrators and developers can deploy from the Azure portal

Section: Describe how to work with relational data on Azure
Explanation:
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

Loading …