Microsoft

Microsoft DP-900

306+ kostenlose Übungsfragen mit KI-verifizierten Antworten

Microsoft Azure Data Fundamentals

Alle Fragen & Antworten kostenlos

Detaillierte Erklärung

Der echten Prüfung am nächsten

306+ Fragen durchsuchen

KI-gestützt

Dreifach KI-verifizierte Antworten & Erklärungen

Jede Microsoft DP-900-Antwort wird von 3 führenden KI-Modellen kreuzverifiziert, um maximale Genauigkeit zu gewährleisten. Erhalte detaillierte Erklärungen zu jeder Option und tiefgehende Fragenanalysen.

GPT Pro

Claude Opus

Gemini Pro

Erklärungen zu jeder Option

Tiefgehende Fragenanalyse

Konsensgenauigkeit durch 3 Modelle

Prüfungsbereiche

Describe Core Data ConceptsGewichtung 28%

Identify Considerations for Relational Data on AzureGewichtung 24%

Describe Considerations for Working with Non-relational Data on AzureGewichtung 19%

Describe an Analytics Workload on AzureGewichtung 29%

Übungsfragen

Frage 1

Your company is designing a data store that will contain student data. The data has the following format. StudentNumber | StudentInformation 7634634 First name: Ben Last: Smith Preferred Name: Benjamin 7634634 First Name: Dominik Last Name: Paiha Email Address: dpaiha@contoso.com MCP ID: 931817 7634636 First Name: Reshma Last Name: Patel Phone number: 514-555-1101 7634637 First Name: Yun-Feng Last Name: Peng Which type of data store should you use?

Möchtest du alle Fragen unterwegs üben?

Lade Cloud Pass kostenlos herunter – mit Übungstests, Fortschrittsverfolgung und mehr.

Übungstests

Practice Test #4

Weitere Microsoft-Zertifizierungen

Microsoft AI-102

Associate

PL-300: Microsoft Power BI Data Analyst

Microsoft AI-900

Fundamentals

Microsoft SC-200

Associate

Jetzt mit dem Üben beginnen

Lade Cloud Pass herunter und erhalte kostenlosen Zugang zu allen Microsoft DP-900-Übungsfragen.

Möchtest du alle Fragen unterwegs üben?

Kostenlose App holen

Lade Cloud Pass kostenlos herunter – mit Übungstests, Fortschrittsverfolgung und mehr.

Frage 3

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

Frage 4

You have a transactional application that stores data in an Azure SQL managed instance. When should you implement a read-only database replica?

Frage 5

You manage an application that stores data in a shared folder on a Windows server. You need to move the shared folder to Azure Storage. Which type of Azure Storage should you use?

Frage 6

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:

Teil 1:

A Microsoft Power BI dashboard is associated with a single workspace.

Teil 2:

A Microsoft Power BI dashboard can only display visualizations from a single dataset.

Teil 3:

A Microsoft Power BI dashboard can display visualizations from a Microsoft Excel workbook.

Frage 7

Which command-line tool can you use to query Azure SQL databases?

Frage 8

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:

Teil 1:

You can use Azure Data Studio to query a Microsoft SQL Server big data cluster.

Teil 2:

You can use Microsoft SQL Server Management Studio (SSMS) to query an Azure Synapse Analytics data warehouse.

Teil 3:

You can use MySQL Workbench to query Azure Database for MariaDB databases.

Frage 10

You need to design and model a database by using a graphical tool that supports project-oriented offline database development. What should you use?

Frage 11

DRAG DROP - Match the security components to the appropriate scenarios. To answer, drag the appropriate component from the column on the left to its scenario on the right. Each component may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place:

Teil 1:

______ Prevent access to an Azure SQL database from another network.

Teil 2:

______ Support Azure Active Directory (Azure AD) sign-ins to an Azure SQL database.

Teil 3:

______ Ensure that sensitive data never appears as plain text in an Azure SQL database.

Frage 12

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:

Teil 1:

Azure Table storage supports multiple read replicas.

Teil 2:

Azure Table storage supports multiple write regions.

Teil 3:

The Azure Cosmos DB Table API supports multiple read replicas.

Teil 4:

The Azure Cosmos DB Table API supports multiple write regions.

Frage 14

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?

Frage 15

What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

Frage 16

Your company is designing a database that will contain session data for a website. The data will include notifications, personalization attributes, and products that are added to a shopping cart. Which type of data store will provide the lowest latency to retrieve the data?

Fragenanalyse

Core concept: This question tests selecting the most appropriate non-relational (NoSQL) data model for a session-state workload where the primary requirement is extremely fast reads/writes (lowest latency). Session data typically includes per-user/per-session attributes such as notifications, personalization settings, and shopping cart contents. Why the answer is correct: A key/value store provides the lowest latency retrieval pattern for session data because access is typically done by a single known key (for example, sessionId or userId). Key/value databases are optimized for O(1)-style lookups, minimal query parsing, and simple data access paths. They are commonly implemented with in-memory or memory-optimized architectures and support very fast point reads and updates—ideal for session state and shopping carts where you frequently read/modify a single session record. Key features and best practices: Key/value stores excel at: - Point reads/writes by key (sessionId) with predictable performance - Simple scaling (partitioning/sharding by key) - TTL/expiration policies (critical for session cleanup) - High throughput and low operational overhead In Azure, this pattern is commonly implemented using Azure Cache for Redis (in-memory key/value) for ultra-low latency, or a key/value-like NoSQL approach in Azure Cosmos DB when durability and global distribution are needed. From an Azure Well-Architected Framework perspective, key/value supports Performance Efficiency (low latency), Reliability (replication options), and Cost Optimization (store only what you need, expire automatically). Common misconceptions: Document stores can also store session objects (JSON) and are flexible, so they may seem like the best fit for “notifications and cart items.” However, document databases are optimized for richer queries and indexing; they can be low-latency, but the simplest and typically lowest-latency retrieval for session state is key/value, especially when backed by memory and TTL. Graph stores are for relationship traversal (friends-of-friends, recommendations). Columnar stores are for analytics and aggregations, not transactional session lookups. Exam tips: For DP-900, map workload to data model: - Session state, caching, shopping cart by sessionId => key/value - Complex JSON with querying/filtering => document - Relationship-heavy queries => graph - Large-scale analytics/OLAP => columnar When the question emphasizes “lowest latency to retrieve” and the access pattern is by a single identifier, choose key/value.

Frage 17

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

Frage 18

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?

Frage 19

DRAG DROP - 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. Select and Place:

Teil 1:

Select the correct answer(s) in the image below.

question-image