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:
A clustered index defines the order in which data is physically stored in a table. Table data can be sorted in only way, therefore, there can be only one clustered index per table. In SQL Server, the primary key constraint automatically creates a clustered index on that particular column.
Reference:
https://www.sqlshack.com/what-is-the-difference-between-clustered-and-non-clustered-indexes- in-sql-server
Hotspot Question
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
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:
False. The default access tier of an Azure Storage account is the Hot access tier.
False. Append blobs are optimized for sequential write operations, not random read and write operations.
True. Retrieving data from the Archive access tier may take several hours to complete, depending on the size of the data and the retrieval options chosen.
Hotspot Question
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
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:
Box 1: Yes
You can reduce transfer sensitive data with transformations on data source.
Box 2: No
ELT use the compute resource from destination system.
Box 3: Yes
ELT minimizes time with transformations are going realizaded on target data destination systems.
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl
Drag and Drop Question
Match the Azure SQL services to the appropriate use cases. To answer, drag the appropriate service from the column on the left to its use case on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Match the Azure SQL services to the appropriate use cases. To answer, drag the appropriate service from the column on the left to its use case on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
正解：
Explanation:
Box 1: Azure SQL Database single database
Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns.
Scenarios well suited for serverless compute
Single databases with intermittent, unpredictable usage patterns interspersed with periods of inactivity, and lower average compute utilization over time.
Single databases in the provisioned compute tier that are frequently rescaled and customers who prefer to delegate compute rescaling to the service.
New single databases without usage history where compute sizing is dificult or not possible to estimate prior to deployment in SQL Database.
Box 2: Azure SQL Managed Instance
Azure SQL Managed Instance is the intelligent, scalable cloud database service that combines the broadest SQL Server database engine compatibility with all the benefits of a fully managed and evergreen platform as a service.
Box 3: Azure SQL Database elastic pool
Azure SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a single server and share a set number of resources at a set price. Elastic pools in SQL Database enable software as a service (SaaS) developers to optimize the price performance for a group of databases within a prescribed budget while delivering performance elasticity for each database.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/serverless-tier- overview?view=azuresql
https://docs.microsoft.com/en- us/azure/azure-sql/database/elastic-pool-overview?view=azuresql
https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql- managed-instance- paas-overview
Hotspot Question
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
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:
Box 1: Yes
For read access to the secondary region, configure your storage account to use read-access geo- redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS).
Box 2: No
Box 3: Yes
Box 4: Yes
Azure Cosmos DB supports multi-region writes.
Reference:
https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy
https://manojchoudhari.wordpress.com/2019/12/16/azure-cosmos-db-enable-multi-region-writes
Hotspot Question
Select the answer that correctly completes the sentence.
Select the answer that correctly completes the sentence.
正解：
Explanation:
hierarchical namespace
https://docs.microsoft.com/en-us/azure/storage/blobs/create-data-lake-storage-account