최신 DP-900 무료덤프 - Microsoft Azure Data Fundamentals
Hotspot Question
To complete the sentence, select the appropriate option in the answer area.
To complete the sentence, select the appropriate option in the answer area.
정답:
Explanation:
https://docs.microsoft.com/en-us/azure/cosmos-db/create-graph-gremlin-console
You need to gather real-time telemetry data from a mobile application.
Which type of workload describes this scenario?
Which type of workload describes this scenario?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
Which command-line tool can you use to query Azure SQL databases?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)
Which statement is an example of Data Manipulation Language (DML)?
정답: A
Hotspot Question
Select the answer that correctly completes the sentence.
Select the answer that correctly completes the sentence.
정답:
A team of developers has computers that run Windows 10 and Ubuntu Desktop.
The developers need to connect to and query an Azure SQL database from each of their computers.
The developers require code assistance features such as IntelliSense.
What should the developers use?
The developers need to connect to and query an Azure SQL database from each of their computers.
The developers require code assistance features such as IntelliSense.
What should the developers use?
정답: D
What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
NOTE: Each correct selection is worth one point.
정답: A,C,F
설명: (DumpTOP 회원만 볼 수 있음)
Drag and Drop Question
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.
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.
정답:
Explanation:
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-windows- firewall-for-database-engine-access?view=sql-server-ver15
https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview
https://docs.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-certificate-store- configure
Hotspot Question
Select the answer that correctly completes the sentence.
Select the answer that correctly completes the sentence.
정답:
Explanation:
An aggregate function performs a calculation on a set of values, and returns a single value. The following are aggregate functions:
* APPROX_COUNT_DISTINCT
* AVG
* CHECKSUM_AGG
* COUNT
* COUNT_BIG
* GROUPING
* GROUPING_ID
* MAX
* MIN
* STDEV
* STDEVP
* STRING_AGG
* SUM
* VAR
* VARP
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/functions/aggregate-functions-transact-sql?view=sql- server-ver15
Hotspot Question
For each of the following statements, select yes if he statement is true, Otherwise select No.
NOTE: Each correct selection is worth one point.
For each of the following statements, select yes if he statement is true, Otherwise select No.
NOTE: Each correct selection is worth one point.
정답:
Explanation:
Box 1: Yes
Azure Databricks can consume data from SQL Databases using JDBC and from SQL Databases using the Apache Spark connector.
The Apache Spark connector for Azure SQL Database and SQL Server enables these databases to act as input data sources and output data sinks for Apache Spark jobs.
Box 2: Yes
You can stream data into Azure Databricks using Event Hubs.
Box 3: Yes
You can run Spark jobs with data stored in Azure Cosmos DB using the Cosmos DB Spark connector. Cosmos can be used for batch and stream processing, and as a serving layer for low latency access.
You can use the connector with Azure Databricks or Azure HDInsight, which provide managed Spark clusters on Azure.
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
Drag and Drop Question
Match the types of workloads the appropriate scenario.
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.
Match the types of workloads the appropriate scenario.
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.
정답:
You need to store event log data that is semi-structured and received as the logs occur.
What should you use?
What should you use?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)
Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?
정답: C
설명: (DumpTOP 회원만 볼 수 있음)
Which type of database is Azure Database for PostgreSQL?
정답: C
설명: (DumpTOP 회원만 볼 수 있음)
Which clause should you use in a select statement to combine rows in one table with rows in another table?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
What should you use to automatically delete blobs from Azure Blob Storage?
정답: C
설명: (DumpTOP 회원만 볼 수 있음)
Hotspot Question
Select the answer that correctly completes the sentence.
Select the answer that correctly completes the sentence.
정답:
Explanation:
Semi-structured data is information that has some structure, but which allows for some variation between entity instances. For example, while most customers may have an email address, some might have multiple email addresses, and some might have none at all.
One common format for semi-structured data is JavaScript Object Notation (JSON). The example below shows a pair of JSON documents that represent customer information. Each customer document includes address and contact information, but the specific fields vary between customers.
https://learn.microsoft.com/en-us/training/modules/explore-core-data-concepts/2-data-formats
Hotspot Question
Select the answer that correctly completes the sentence.
Select the answer that correctly completes the sentence.
정답:
Explanation:
SQL Server on Azure VM falls into the industry category Infrastructure-as-a-Service (IaaS) and allows you to run SQL Server inside a fully managed virtual machine (VM) in Azure.
The most significant difference from SQL Database and SQL Managed Instance is that SQL Server on Azure Virtual Machines allows full control over the database engine. You can choose when to start maintenance/patching, change the recovery model to simple or bulk-logged, pause or start the service when needed, and you can fully customize the SQL Server database engine.
With this additional control comes the added responsibility to manage the virtual machine.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is- overview?view=azuresql