Microsoft Azure Data Fundamentals
Last Update Apr 18, 2024
Total Questions : 289
We are offering FREE DP-900 Microsoft exam questions. All you do is to just go and sign up. Give your details, prepare DP-900 free exam questions and then go for complete pool of Microsoft Azure Data Fundamentals test questions that will help you more.
At which level in Azure Cosmos DB can you configure multiple write regions and read regions?
To complete the sentence, select the appropriate option in the answer area.
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?
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
To complete the sentence, select the appropriate option in the answer area.
What is required to provision Azure Data Lake Storage in an Azure Storage account?
Match the Azure services to the appropriate locations in the architecture.
To answer, drag the appropriate service from the column on the left to its location on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
You have structured data in tabular format.
What represents an individual instance of a data entity?
To complete the sentence, select the appropriate option in the answer area.
Match the Azure Data Lake Storage terms to the appropriate levels in the hierarchy.
To answer, drag the appropriate term from the column on the left to its level 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 complete the sentence select the appropriate option in the answer area.
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.
For each of the following statements, select yes if he statement is true, Otherwise select No.
NOTE: Each correct selection is worth one point.
To complete the sentence, select the appropriate option in the answer area.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
You are reviewing the data model shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point
A team of developers has computers Thai run Windows 10 and Ubuntu Desktop.
The developers need to connect to and query an Azure SQL database from the computers. The developers require code assistance features such as intellSense.
What should the developers use ?
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
What should you use to automatically delete blobs from Azure Blob Storage?
A bar chart showing year-to date sales by region is an example of which type of analytics?
To complete the sentence, select the appropriate option in the answer area.
Match the types of analytics that can be used to answer the business questions.
To answer, drag the appropriate analytics type from the column on the left to its question on the right. Each analytics type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?
To complete the sentence, select the appropriate option in the answer area.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
You have a SQL query that combines customer data and order data. The query includes calculated columns.
You need to create a database object that would allow other users to rerun the same SQL query.
What should you create?
Which Azure SQL offering provides near-IOO percent compatibility with on-premises Microsoft SQL Server instances, while providing automated updates,
backups, and maintenance tasks?
To complete the sentence, select the appropriate option in the answer area.
To complete the sentence, select the appropriate option in the answer area.
A bank has a system that manages financial transactions.
When transferring money between accounts, the system must never retrieve a value for the source account that reflects the balance before the transfer and a value for the destination account that reflects the balance after the transfer.
Of which ACID semantic is this an example?
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.
Match the job roles to the appropriate tasks.
To answer, drag the appropriate 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.
Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
To complete the sentence, select the appropriate option in the answer area.
To complete the sentence, select the appropriate option in the answer area.
Which component of Azure Data Factory enables you to define a sequence of activities including for each iterators?
Match the ACID terms to the Appropriate descriptions.
To answer, drag the appropriate 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 aft.
NOTE: Each correct match is worth one point.
Your company needs to design a database that shows how changes traffic in one area of a network affect other components on the network.
Which type of data store should you use?
You have the following JSON document.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document.
NOTE: Each correct selection is worth one point.
To complete the sentence, select the appropriate option in the answer area.
To complete the sentence, select the appropriate option in the answer area.
Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?
Your company if designing an application that will write a high volume of JSON data and will have an application-defined schema.
Which type of data store should you use?
Your company needs to ensure that in Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet. What should you use?
You have a table named Sales that contains the following data.
You need to query the table to return the average sales amount day. The output must produce the following results.
How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
To complement the sentence, select the appropriate option in the answer area.
You have a banking application that transfers money in to and out of accounts.
Of which type of solution is this is an example?
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
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.
Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?
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.
What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
You need to design and model a database by using a graphical tool that supports project-oriented offline
database development.
What should you use?
For each of the following statements, select Yes if the statement is true, Otherwise, select No.
NOTE: Each correct selection 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 use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse.
What should you use to query the files?