HomeMicrosoft Exams PracticeDP-900 Exam Questions | Microsoft Azure Data Fundamentals DP-900 Exam Questions | Microsoft Azure Data Fundamentals Microsoft Azure Data Fundamentals Quiz Welcome to Microsoft Azure Data Fundamentals Quiz that has been extracted from Microsoft Learn and is considered a complete and helpful summary for the Microsoft Azure Data Fundamentals learning path that would help you to prepare for DP-900 Exam. The total number of questions is 171 Questions. Time expected to finalize this quiz is 30~50 Minutes. Please, provide your Full Name and Email to get started! Please, enter your Full Name Please, enter your Email 1. Data can be only classified as structured, and unstructuredTrueFalse2. ................ is typically tabular data that is represented by rows and columns in a database.Semi-Structured dataStructured dataUnstructured data3. Databases that hold tables are called ...............Graph databasesKey-value databasesRelational databases4. The mathematical term relation refers to an organized set of data held as a .............TableContainerFileEntity5. What's kind of Power BI chart that used to show a running total TreemapWaterfall ChartRibbon ChartScatter6. You need to migrate a 8 Tera MangoDB to Azure CosmosDB, Which tool should you use?Azure Cosmos DB Data Migration toolAzure Data FactoryAzure App Migration Tool7. Which details you must provide when creating Azure Cosmos Account Location Tags Backup Policy Account Name Networking8. ................ is information that doesn't reside in a relational database but still has some structure to it.Structured dataUnstructured dataSemi-Structured data9. JSON file is an example of Semi-structured dataFalseTrue10. A ................ stores data as a single collection without structure or relation.Graph databasesKey-value databasesRelational databases11. In Graph database, Nodes refer to information aboutRelationship between ObjectsObjectsNo Nodes in graph databases12. In Graph database, Edges refer to information aboutNo Edges in graph databasesObjectsRelationship between Objects13. The act of setting up the database server is called ...................DecommissionConfiguringProvisioning14. Audio file is an example of Semi-structured dataTrueFalse15. Blob is an acronym for ....................Binary Large ObjectBase Large ObjectBinary Long Object16. You can use Azure Blob storage to store ...........Structure DataUnstructured DataSemi-Structured Data17. If you want to store semi-structured data such as documents, you can use a service such as ....................Azure SQL DatabaseSQL ServerAzure Cosmos DB18. .................. means the users can read data but can't modify any existing data or create new data.Read-only accessOwner privilegeRead/write access19. You can use a .................... to store and query information about complex relationships.Relational databasesKey-value databasesGraph databases20. .................. gives users the ability to view and modify existing data.Read-only accessRead/write accessOwner privilege21. .................. gives full access to the data including managing the security like adding new users and removing access to existing users.Read/write accessRead-only accessOwner privilege22. Which level of access Data analysts and data managers will have to manage the access of other users and administer the system?Owner privilegeRead-only accessRead/write access23. In ................,The data being processed has to be accessible very quickly.Analytical systemsTransactional systems24. The work performed by transactional systems is often referred to as ................Online Transferred Processing (OLTP).Online Analytical Processing (OLAP).Online Transactional Processing (OLTP).25. Splitting tables out into separate groups of columns like this is called ...................Normalization.Split outDenormalization.26. Normalization can enable a transactional system to cache much of the information required to perform transactions in memory, and speed throughput.FalseTrue27. ........................... is designed to support business users who need to query data and gain a big picture view of the information held in a database.Transactional systemsAnalytical systems28. ........................ is the process of capturing the raw data.Data TransformationData VisualizationData IngestionData Querying29. After data is ingested into a data repository, you may want to do some cleaning operations and remove any questionable or invalid data, this task is called ....................Data QueryingData VisualizationData TransformationData Ingestion30. After data is ingested and transformed, you can query the data to analyze it, this task is called ..............Data IngestionData QueryingData TransformationData Visualization31. You can categorize data in many different ways, depending on ...............How the data is structured.How the data is structured and used.How the data is used.32. A narrow table is a table with many columns.FalseTrue33. Non-relational databases provide probably the most well-understood model for holding data.FalseTrue34. Non-relational databases enable you to store data in a format that more closely matches the original structure.TrueFalse35. A transaction is a sequence of operations that are atomic.TrueFalse36. ....................... guarantees that each transaction is treated as a single unit, which either succeeds completely, or fails completely.DurabilityIsolationConsistencyAtomicity37. ....................... ensures that a transaction can only take the data in the database from one valid state to another.ConsistencyIsolationAtomicityDurability38. ....................... ensures that concurrent execution of transactions leaves the database in the same state that would have been obtained if the transactions were executed sequentially.ConsistencyIsolationAtomicityDurability39. ....................... guarantees that once a transaction has been committed, it will remain committed even if there's a system failure such as a power outage or crash.DurabilityAtomicityConsistencyIsolation40. A distributed database is a database in which data is stored in a single physical location.FalseTrue41. Eventual consistency is ideal where the application requires ordering guarantees.TrueFalse42. ..................... are typically read-only systems that store vast volumes of historical data or business metrics, such as sales performance and inventory levels.Analytical workloadsTransactional workloads43. Processing data as it arrives is called ................BufferingStreamingBatching44. Buffering and processing the data in groups is called ................Buffer processingBatch processingStream processing45. Process data based on a scheduled time interval is an example for ........................Batch processingStream processingBuffer processing46. An example of effective batch-processing would be to transfer small amounts of real-time data, such as a financial stock-ticker.TrueFalse47. Batching handles data in real time.FalseTrue48. Stream processing is ideal for time-critical operations that require an instant real-time response.TrueFalse49. ................................. is suitable for handling large datasets efficiently.Batch processingStream processing50. You typically use ...................... for performing complex analytics.Stream processingBatch processing51. .................... typically occurs immediately, with latency in the order of seconds or milliseconds.Stream processingBatch processing52. How is data in a relational table organized?Pages and ParagraphsHeader and FooterRows and Columns53. Which of the following is an example of unstructured data?JSON filesAudio and Video filesAn Employee table with columns Employee ID, Employee Name, and Employee Designation54. What of the following is an example of a streaming dataset?Sales data for the past monthList of employees working for a companyData from sensors and devices55. ....................... manage databases, assigning permissions to users, storing backup copies of data and restore data in case of any failures.Data ScientistsData AnalystsData EngineersDatabase Administrators56. ....................... are vital in working with data, applying data cleaning routines, identifying business rules, and turning data into useful information.Data ScientistsData AnalystsData EngineersDatabase Administrators57. ....................... explore and analyze data to create visualizations and charts to enable organizations to make informed decisions.Data ScientistsData AnalystsDatabase AdministratorsData Engineers58. A ........................ primary job is to ensure that data is available, protected from loss, corruption, or theft, and is easily accessible as needed.Data Analyst'sData Scientist'sDatabase administrator'sData Engineer's59. Some of the most common roles and responsibilities of a database administrator include: Generating various reports by querying from database as per need. Installing and upgrading the database server and application tools. Developing, constructing, testing, and maintaining databases and data structures. Planning for backup and recovery of database information. Making large or complex data more accessible, understandable, and usable.60. Some of the most common roles and responsibilities of a data engineer include: Using programming languages and tools to examine the data. Aligning the data architecture with business requirements. Planning for backup and recovery of database information. Installing and upgrading the database server and application tools. Developing, constructing, testing, and maintaining databases and data structures.61. The primary functions of a data analyst usually include the following: Developing, constructing, testing, and maintaining databases and data structures. Delivering information in a useful and appealing way to users by creating rich graphical dashboards and reports. Planning for backup and recovery of database information. Transforming, improving, and integrating data from many sources, depending on the business requirements. Finding hidden patterns using data.62. Which of the following tools is a visualization and reporting tool?Power BIAzure Data StudioSQL Server Management Studio63. ........................... is a cross-platform database administration tool that provides a graphical user interface for managing many different database systems. It currently provides connections to on-premises SQL Server databases, Azure SQL Database, PostgreSQL, Azure SQL Data Warehouse, and SQL Server Big Data Clusters, amongst others.pgAdminMySQL WorkbenchSQL Server Management StudioAzure Data Studio64. ........................... provides a graphical interface, enabling you to query data, perform general database administration tasks, and generate scripts for automating database maintenance and support operations.MySQL WorkbenchAzure Data StudiopgAdminSQL Server Management Studio65. You can use Azure portal for increasing the database size, creating a new database, and deleting an existing database.TrueFalse66. Database Administrator role is a highly technical position, requiring experience and skills in areas like programming, mathematics, and computer science.TrueFalse67. ...................... is key to presenting large amounts of information in ways that are universally understandable or easy to interpret and spot patterns, trends, and correlations.Data TransformationData visualizationData modelingData ingestion68. ................... is a powerful visualization platform, to create rich, graphical dashboards and reports over data that can vary dynamically.Microsoft Power BIAzure Data StudioSQL Server Management StudiopgAdmin69. Which one of the following tasks is a role of a database administrator?Backing up and restoring databasesCreating dashboards and reportsIdentifying data quality issues70. Which one of the following roles is not a data job role?Data AnalystSystems AdministratorDatabase Administrator71. One of the main benefits of computer databases is that they make it easy to store information so it's quick and easy to find.FalseTrue72. In a relational database, you model collections of entities from the real world as tables.TrueFalse73. You design a relational database by creating a ...................Data DesignData StructureData model74. A foreign key uniquely identifies each row in a table.FalseTrue75. A primary key references rows in another, related table.TrueFalse76. All data in non-relational database is tabularFalseTrue77. In relational database, you can filter data by using a ............ clause.SELECTUPDATEGROUPBYWHERE78. In relational database, You can combine the data from multiple tables in a query using a ................... operation.GROUPBYUPDATEJOINWHERE79. Relational databases are commonly used in social networking sitesFalseTrue80. Examples of OLTP applications that use relational databases are: Online retail applications Flight reservation systems Banking solutions Social networking sites81. A ................... is a virtual table based on the result set of a query.IndexFunctionStored ProcedureView82. You can only create one index on a table.FalseTrue83. If a table is queried infrequently, but subject to a large number of inserts, updates, and deletes then creating indexes on that table can improve query performance.FalseTrue84. In database management systems that support clustered indexes, a table can only have a single clustered index.TrueFalse85. Hosting a relational database on cloud requires that an enterprise not only purchases the database software, but also maintains the necessary hardware on which to run the database.FalseTrue86. Which two options you have when moving your operations and databases to the cloud?IaaS or SaaSIaaS or PaaSPaaS or SaaS87. Which one of the following statements is a benefit of using a PaaS service, instead of an on-premises system, to run your database management systems?Increased functionalityIncreased scalabilityIncreased day-to-day management costs88. Non-relational databases are highly suitable for the following scenarios: Retail and marketing IoT and telematics Gaming89. When data needs to be ingested very quickly, or the query is unknown and unconstrained, a relational database can be more suitable than a non-relational database.TrueFalse90. Non-relational data generally falls into two categories:Structured and non-structuredSemi-structured and non-structuredStructured and semi-structured91. ............. is data that contains fields. The fields don't have to be the same in every entityNon-structuredSemi-structuredStructured92. ............... organizes data into columns rather than rows that contains stripes of data.ParquetOCRAVROJSON93. ............... is a row-based format. It was created by Apache.JSONOCRAVROParquet94. ............... is another columnar data format. It was created by Cloudera and Twitter, contains row groups.ParquetOCRJSONAVRO95. ............... format used by JavaScript applications to store data in memory, but can also be used to read and write documents to and from files.ParquetAVROJSONOCR96. ............. is data that doesn't naturally contain fields. Examples include video, audio, and other media streams.Structured dataSemi-structured dataNon-structured data97. ....................... is the simplest (and often quickest) type of NoSQL database for inserting and querying data.A key-value storeA document databaseA column family databaseA graph database98. ..................... is the process by which you transform and map raw data into a more useful format for analysis.QueryIngestionWranglingModel99. ..................... is the process of obtaining and importing data for immediate use or storage in a database.Data explorationData ingestionData processing100. ..................... occurs after the data has been collected and takes the data in its raw form, cleans it, and converts it into a more meaningful formatData ingestionData processingData exploration101. ELT is suitable for systems that only require simple models, with little dependency between itemsFalseTrue102. ETL is more suitable for constructing complex models that depend on multiple items in the database, often using periodic batch processing.TrueFalse103. ...................... helps answer questions about what has happened, based on historical data.Cognitive analyticsDiagnostic analyticsDescriptive analyticsPredictive analyticsPrescriptive analytics104. ...................... helps answer questions about why things happened.Diagnostic analyticsCognitive analyticsPredictive analyticsPrescriptive analyticsDescriptive analytics105. ...................... helps answer questions about what will happen in the future.Prescriptive analyticsPredictive analyticsDiagnostic analyticsDescriptive analyticsCognitive analytics106. ...................... helps answer questions about what actions should be taken to achieve a goal or target.Descriptive analyticsPredictive analyticsPrescriptive analyticsDiagnostic analyticsCognitive analytics107. ...................... attempts to draw inferences from existing data and patterns, derive conclusions based on existing knowledge bases, and then add these findings back into the knowledge base for future inferencesCognitive analyticsPredictive analyticsDiagnostic analyticsDescriptive analyticsPrescriptive analytics108. ELT requires ............Data must be fully processed to be loaded into data store.The data target is a relational databaseThe target system is powerful enough to transform the dataMatching schema in the data source and data target109. ETL requires ............Data must be fully processed to be loaded into data store.The data target is a relational databaseMatching schema in the data source and data targetThe target system is powerful enough to transform the data110. In batch processing, .............Data is processed in real timeHigh latency is expectedCan only executed serially111. The massively parallel processing (MPP) engine of Azure Synapse AnalyticsRedirect client connection a cross compute nodes.Distribute processing a cross compute nodes.Distribute processing a cross control nodes.112. ...................... sort and store the data rows in the table or view based on their key values.Foreign KeyNon-Clustered IndexStore ProcedureClustered Index113. The relational database is appropriate for scenarios that involve a high volume ofTransactional WritesChanges between relationship between entitiesWrites that have varying Data Structure114. Which analytic is example for a visualization that shows the current student enrollment versus the current capacityPredictivePrescriptiveDescriptiveDigonisticCognitive115. Which statement is an example of Data Manipulation Language (DML)?REVOKEINSERTCREATEDROP116. A key/value data store is optimized for ...............TransactionsSimple LookupsTable Joins117. In Azure Data Factory, the ............... is a representation of data structure within data storePipelineDatasetData FlowLinked Service118. In Azure Data Factory, the information used to connect to external resources is ...............DatasetData FlowPipelineLinked Service119. In Azure Data Factory, ............. is a logical grouping of activities that together perform a unit of work and can be scheduled.Data FlowPipelineLinked ServiceDataset120. ................... is a cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOSAdd description here!Azure CLIAzure Data StudioMicrosoft SQL Server Management Studio121. You need to modify a view in a relational database by adding a new column. Which statement should you use?AlterCreateUpdateMerge122. Which type of analysis is shown in the 2016 and 2017?Cognitive analyticsPrescriptive analyticsDiagnostic analyticsDescriptive analyticsPredictive analytics123. Which API enable the use of SELECT statement to retrive documents from Azure CosmosDBGremlinCassandraCore (SQL)MongoDB124. .................. natively support the analysis of relationship between entitiesColumn family databaseGraph databasesKey-value storeDocument database125. Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?Azure Table storageAzure FilesAzure Data Lake Storage Gen2126. Relational data is stored inTabular form of rows and columnsFile system as unstructured dataCSV fileFolder Structure127. Which tool should you use to embed documents and query results into a SQL notebook?Azure CLIAzure Data StudioMicrosoft SQL Server Management Studio128. ...................... a database object that holds dataIndexViewTable129. ...................... a database object whose content is defined by queryTableViewIndex130. ...................... a database object that helps improve the speed of data retrievalIndexViewTable131. You must apply operating system updates to Azure SQL regularlyTrueFalse132. You need a Microsoft 365 subscription to create Azure SQL DatabaseTrueFalse133. You can use SQL Server licenses with Software Assurance or qualifying subscription licenses to pay a reduced base rate for Azure SQL DatabaseFalseTrue134. Which statement is an example of Data Definition Language (DDL)?CREATEMERGESELECTINSERT135. SQL Server Management Studio enables users to create and use SQL notebooksTrueFalse136. You can use the Azure Data Studio to restore databasesFalseTrue137. What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? In-database machine learning services Reduced administrative effort for managing the server infrastructure Complete control over backup and restore processes Access to the latest features138. Complete the below SQL query---------------- Date, Count(Amount) from Sales ----------------- DateOrder by DateInsert Into, WhereCreate, Group BySelect, HavingSelect, Group By139. Which account can always connect to the database, When you create an Azure SQL database?SA accountServer admin login account of the logical serverAzure Active Directory account that created the databaseAzure Active Directory administrator account140. You have a transactional application that stores data in an Azure SQL managed instance. When should you implement a read-only database replica?You need to implement high availability in the event of a regional outageYou need to improve the recovery point objectiveYou need to generate reports without affecting the transactional workloadYou need to audit the transactional application141. Relational database must be used whenDynamic Schema is requiredData will be stored as key/value pairsStrong consistency guaranties are required142. Which three requirements must be met to query a table named Sales in an Azure SQL database from the internet? Your IP address must be allowed to connect to the database. You must have SELECT access to the Products table. You must be assigned the Contributor role for the resource group that contains the database. You must be assigned the Reader role for the resource group that contains the database. You must have a user in the database.143. Which type of data stores used for Application users and their default languagesObjectKey/valueGraphShared files144. Which type of data stores used for Medical images and their associated metadataKey/valueShared filesGraphObject145. Which type of data stores used for Employees data that shows the relationship between employeesObjectGraphKey/valueShared files146. 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?GraphObjectKey/valueDocument147. Which Azure Cosmos DB API appropriate for Graph dataTable APIGremlin APICassandra APIMongoDB API148. Which Azure Cosmos DB API appropriate for JSON DocumentsGremlin APITable APIMongoDB APICassandra API149. Which Azure Cosmos DB API appropriate for Key/Value dataMongoDB APICassandra APIGremlin APITable API150. Which Azure Cosmos DB API appropriate for column-oriented schemaCassandra APIMongoDB APIGremlin APITable API151. To create Azure Storage account for Data Lake Storage to support security at the folder level and atomic directory manipulation,You must enable hierarchal namespace.You must set performance to premiumYou must set account kind to BLOBstorage152. Azure Synapse Analytics scales storage and compute independentlyTrueFalse153. Azure Synapse Analytics can be paused to reduce compute costsTrueFalse154. Azure Synapse Analytics data warehouse has a fixed storage capacityFalseTrue155. What are three characteristics of an OLTP workload? Light writes and heavy reads Heavy writes and moderate reads Normalized data Denormalized data Schema defined in a database156. Which Azure Data Factory component provides the compute environment for activities?SSIS packagesControl flowIntegration runtimePipeline157. What are two uses of data visualization? Represent trends and patterns over time Communicate the significance of data Implement machine learning to predict future values Enforce business logic across reports158. Which three objects can be added to a Microsoft Power BI dashboard? Visualization from a report PowerPoint slide Report page Text box Dataflow159. Which two activities can be performed entirely by using the Microsoft Power BI service without relying on Power BI Desktop? Data acquisition and preparation Report sharing and distribution Report and dashboard creation Data modeling160. Which setting can only be configured during the creation of an Azure Cosmos DB account?Production or non-production account typeMulti-region writesAPIGeo-redundancy161. Which type of data store should you use for an application that will write a high volume of JSON data and will have an application-defined schema?DocumentKey/valueGraphObject162. Which type of data store should you use to design a database that illustrates the relationships between utilization levels of individual network devices across a local area network?Key/valueDocumentGraphColumnar163. Azure Table Storage supports multiple read replicasTrueFalse164. Azure Table Storage supports multiple write regionsTrueFalse165. Azure Cosmos DB Table API supports multiple read replicasFalseTrue166. Azure Cosmos DB Table API supports multiple write regionsFalseTrue167. When using Azure Cosmos DB Gremlin API, the container resource type is projected asTableDocumentGraph168. When create an Azure Cosmos DB .................... you need to specify which type of API you will use.AccountContainerItem169. Copying data to Azure Data lake Storage from another region results in extra costsTrueFalse170. You can use file, blob, table storage in the same Azure Storage AccountFalseTrue171. To implement Azure Data Lake Storage, you must create an Azure Storage AccountTrueFalse36 out of 35Are you sure, you would like to submit your responses on DP-900 Exam Questions and view your results? Time is Up! Related