Microsoft Azure Data Fundamentals - DP-900 Exam Practice Test
Select the answer that correctly completes the sentence.
Correct Answer:
See the answer in explanation below.
Explanation:
Answer below as:
Explanation:
Answer below as:
Match the job roles to the appropriate tasks.
To answer, drag the appropriate job role from the column on the left to its task on the right Each role may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
To answer, drag the appropriate job role from the column on the left to its task on the right Each role may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Correct Answer:
You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP).
Which Azure service should you use to support the application?
Which Azure service should you use to support the application?
Correct Answer: B
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
To complete the sentence, select the appropriate option in the answer area.
Correct Answer:
Reference:
https:// docs.micros oft.com/en-us/azure/data-factory/frequently-asked-questions
To complete the sentence, select the appropriate option in the answer area.
Correct Answer:
Explanation:
Box 1: simple lookups
A key/value store associates each data value with a unique key. Most key/value stores only support simple query, insert, and delete operations. To modify a value (either partially or completely), an application must overwrite the existing data for the entire value. In most implementations, reading or writing a single value is an atomic operation.
An application can store arbitrary data as a set of values. Any schema information mu st be provided by the application. The key/value store simply retrieves or stores the value by key.
Reference:
https://docs.microsoft.com/en- us/azure/architecture/guide/technology-choices/data-store-overview
Select the answer that correctly completes the sentence.
Correct Answer:
See the answer below:
Explanation:
Answer as below.
Explanation:
Answer as below.
Match the types of visualizations to the appropriate descriptions.
To answer, drag the appropriate visualization type from the column on the left to its description on the right.
Each visualization type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
To answer, drag the appropriate visualization type from the column on the left to its description on the right.
Each visualization type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Correct Answer:
Explanation:
Box 1: Tree map
Treemaps are charts of colored rectangles, with size representing value. They can be hierarchical, with rectangles nested within the main rectangles.
Box 2: Key influencer
A key influencer chart displays the major contributors to a selected result or value.
Box 3: Scatter
Scatter a nd Bubble charts display relationships between 2 (scatter) or 3 (bubble) quantitative measures -- whether or not, in which order, etc.
You need to recommend a non-relational data store that is optimized for storing and retrieving files, videos, audio stream, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file.
Which type of data store should you recommend?
Which type of data store should you recommend?
Correct Answer: B
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
Which statement is an example of Data Definition Language (DDL)?
Correct Answer: A
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
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.
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.
Correct Answer:
To complete the sentence, select the appropriate option in the answer area.
Correct Answer:
Explanation:
Disadvantages of non-relational databases include: Data Consistency - non-relational databases do not perform ACID transactions.
Note: Relational databases are optimized for writes. They are optimized for consistency and availability.
Advantages of relati onal databases include simplicity, ease of data retrieval, data integrity, and flexibility.
Reference:
https://towa rdsdatascience.com/choosi ng-the-right-database-c45cd3a28f77
What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
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?
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?
Correct Answer: D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
Match the data terms to the appropriate descriptions.
To answer, drag the term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
To answer, drag the term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Correct Answer:
Explanation:
