Pass Microsoft DP-900 Exam with Guarantee Updated 215 Questions
Latest DP-900 Pass Guaranteed Exam Dumps Certification Sample Questions
What is the duration, language, and format of Microsoft DP-900: Microsoft Azure Data Fundamentals Exam
- Type of Questions: This test format is multiple choice.
- Language: English
- Number of Questions: 40 to 60 questions (Since Microsoft does not publish this information, the number of exam questions may change without notice.)
- Length of Examination: 50 mins
- Passing score: 700 / 1000
What Are the Exam Topics?
Core data concepts
This topic majorly addresses the following skills:
- Various data workloads – this involves an overview of the features of relational data as well as the description, similarities and differences between streaming data and batch data as well as.
- Main concepts of data analytics – data visualization, business intelligence (BI), analytics techniques (diagnostic, predictive, descriptive, cognitive, prescriptive) and basic chart types such as pie charts and bar charts are the main concepts addressed in this category. Also, data processing techniques are covered along with ETL processing.
NEW QUESTION 72
DRAG DROP
Match the types of activities to the appropriate Azure Data Factory activities.
To answer, drag the appropriate activity type from the column on the left to its Data Factory activity on the right. Each activity type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
Answer:
Explanation:
Section: Describe an analytics workload on Azure
Explanation/Reference:
https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities#data-transformation- activities
NEW QUESTION 73
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.
Answer:
Explanation:
NEW QUESTION 74
You need to create a visualization of running sales totals per quarter as shown in the following exhibit.
What should you create in Power BI Desktop?
- A. a decomposition tree
- B. a waterfall chart
- C. a bar chart
- D. a ribbon chart
Answer: B
NEW QUESTION 75
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://mrpaulandrew.com/2019/09/25/azure-data-factory-pipeline-hierarchies-generation-control/
NEW QUESTION 76
Your company is designing a data store that will contain student data. The data has the following format.
Which type of data store should you use?
- A. graph
- B. object
- C. columnar
- D. key/value
Answer: C
Explanation:
Section: Describe how to work with non-relational data on Azure
NEW QUESTION 77
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 78
Match the Azure services to the appropriate requirements.
To answer, drag the appropriate service 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.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/data-factory/supported-file-formats-and-compression-codecs
NEW QUESTION 79
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 80
You need to gather real-time telemetry data from a mobile application.
Which type of workload describes this scenario?
- A. streaming
- B. batch
- C. Online Transaction Processing (OLTP)
- D. massively parallel processing (MPP)
Answer: A
Explanation:
Section: Describe an analytics workload on Azure
Explanation/Reference:
https://docs.microsoft.com/en-in/azure/azure-monitor/overview
NEW QUESTION 81
Which statement is an example of Data Definition Language (DDL)?
- A. SELECT
- B. DELETE
- C. INSERT
- D. DROP
Answer: D
Explanation:
Explanation
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
NEW QUESTION 82
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Explanation
A View
NEW QUESTION 83
Match the types of data to the appropriate Azure data services.
To answer, drag the appropriate data types from the column on the left to its service on the right. Each data type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Answer:
Explanation:
NEW QUESTION 84
What is a characteristic of a non-relational database?
- A. self-describ ing entities
- B. a fixed schema
- C. full support for Transact-SQL
Answer: C
NEW QUESTION 85
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION 86
Match the types of workloads to the appropriate scenarios.
To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/batch-processing
NEW QUESTION 87
Which statement is an example of Data Definition Language (DDL)?
- A. SELECT
- B. JOIN
- C. MERGE
- D. CREATE
Answer: D
Explanation:
Reference:
https://www.geeksforgeeks.org/difference-between-ddl-and-dml-in-dbms/
NEW QUESTION 88
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Box 1: Yes
Like IaaS, PaaS includes infrastructure - servers, storage, and networking - but also middleware, development tools, business intelligence (BI) services, database management systems, and more. PaaS is designed to support the complete web application lifecycle: building, testing, deploying, managing, and updating.
PaaS allows you to avoid the expense and complexity of buying and managing software licenses, the underlying application infrastructure and middleware, container orchestrators such as Kubernetes, or the development tools and other resources Box 2: Yes You manage the applications and services you develop, and the cloud service provider typically manages everything else.
Box 3: No
There really is no way to pause / stop billing for your Azure SQL Database.
Microsoft's official answer "Yes, you can export your database. Delete the Azure SQL database and that will pause billing. Then when you need it you can create a new database and import your previously exported DB."
NEW QUESTION 89
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
NEW QUESTION 90
What is a primary characteristic of a relational database?
- A. a large amount of duplicate data
- B. data is queried and manipulated by using a variant of the SQL language
- C. a flexible data structure
- D. a lack of dependencies between tables
Answer: B
NEW QUESTION 91
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Graphical user interface, text, application Description automatically generated
Box 1: No
You can duplicate a dashboard. The duplicate ends up in the same Power BI workspace.
There is no current functionality that allows you to move reports from one workspace to another.
Box 2: No
Box 3: Yes
NEW QUESTION 92
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Box 1: Yes
Batch processing refers to processing of high volume of data in batch within a specific time span. It processes large volume of data all at once. Batch processing is used when data size is known and finite. It takes little longer time to processes data.
Box 2: Yes
Stream processing refers to processing of continuous stream of data immediately as it is produced. It analyzes streaming data in real time. Stream processing is used when the data size is unknown and infinite and continuous.
Box 3: No
NEW QUESTION 93
Which statement is an example of Data Definition Language (DDL)?
- A. SELECT
- B. JOIN
- C. MERGE
- D. CREATE
Answer: D
Explanation:
Section: Describe how to work with relational data on Azure
Explanation/Reference:
https://www.geeksforgeeks.org/difference-between-ddl-and-dml-in-dbms/
NEW QUESTION 94
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Box 1: Yes
Azure Data Studio is a cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
You can use Azure Data Studio to connect to an Azure SQL Database server. You'll then run Transact-SQL (T-SQL) statements to create and query Azure SQL databases.
Box 2: No
SQL Server Management Studio is for configuring, managing, and administering all components within Microsoft SQL Server, not to create SQL notebooks.
Instead use Azure Data Studio to create SQL notebook.
Box 3: Yes
You can use the Azure Data Studio to restore databases.
NEW QUESTION 95
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/partitioning-overview
NEW QUESTION 96
......
Explain the Techniques Involved in Working with Relational Data on Microsoft Azure: 25-30%
- Explain the Query Methods for Data with the SQL Language: The learners should be capable of comparing the Data Manipulation Language with the Data Definition Language. They should also be able to query relational data within Azure Database for MySQL, Azure SQL Database, and Azure Database for PostgreSQL.
- Explain Relational Azure Data Services: The individuals should have the ability to explain and compare SaaS, PaaS, and IaaS solutions as well as Azure Synapse Analytics. They also need the knowledge of Azure SQL database services, Azure Database for PostgreSQL, Azure Database for MySQL, and Azure Database for MariaDB.
- Explain the Concepts of Relational Data Workloads: The examinees should be able to explain the structures of relational data and identify the appropriate data for relational workloads.
- Identify the Fundamental Management Tasks for Relational Data: The applicants should be able to explain the deployment and provisioning of relational data services. They also need to understand the techniques for deployment, such as Azure Resource Manager templates, Azure portal, Azure CLI, and Azure PowerShell. In addition, the students should be able to identify the fundamental connectivity issues and components of data security.
New DP-900 Test Materials & Valid DP-900 Test Engine: https://www.2pass4sure.com/Microsoft-Certified-Azure-Data-Fundamentals/DP-900-actual-exam-braindumps.html
DP-900 Updated Exam Dumps [2022] Practice Valid Exam Dumps Question: https://drive.google.com/open?id=1UtJvtr7Ufptt6wQwO3lqtYiOGi59Ruv6