DP900 Flashcards
Name one service provided by Azure for big data processing.
Azure Synapse Analytics.
What type of data does Azure Cosmos DB primarily handle?
Non-relational data.
Multiple Choice: Which Azure service is used for data warehousing? A) Azure Blob Storage B) Azure SQL Database C) Azure Data Factory
B) Azure SQL Database.
What is the significance of data governance in DP900?
Data governance ensures data quality, privacy, and compliance.
What does ETL stand for in data processing?
Extract, Transform, Load.
Multiple Choice: Which of the following is NOT a type of data model?
A) Entity-Relationship Model
B) Document Model
C) Spreadsheet Model
C) Spreadsheet Model.
What type of analytics focuses on historical data?
Descriptive analytics.
What is the difference between structured and unstructured data?
Structured data is organized and easily searchable, while unstructured data is not organized and harder to analyze.
Multiple Choice: Which is a benefit of using a NoSQL database?
A) Fixed schema
B) High scalability
C) Complex queries
B) High scalability.
How is the data in relational table organized?
A) Rows and Columns
B) Header and Footer
C) Pages and Paragraphs
A) Rows and Columns
(structured data)
Which of the following is an example of unstructured data?
A) An Employee table with columns EmployeeID, Employee Name, Employee Designation
B) Audio and Video files
C) A table with SQL Server database
B) Audio and Video files
What of the following is and example of a streaming dataset?
A) Data from sensor feeds
B) Sales data for the past month
C) List of employees working for a company
A) Data from sensor feeds
Which one of the following tasks is a role of a database administrator?
A) Backing up and restoring databases
B) Creating dashboards and reports
C) Identifying data quality issues
A) Backing up and restoring databases
Which of the following tools is a visualization and reporting tool?
A) SQL Server Management Studio
B) PowerBI
C) SQL
B) Power BI
Which one of the follwoing roles is not a data job role?
A) SysAdmin
B) Data Analyst
C) Database Administrator
A) System administrator
Which one of the following statements is a characteristic of a relational database?
A) All data must be stored as character strings
B) A row in a table represents a single entity
C) Different rows in the same table can contain different columns
B) A row in a table represents a single entity
What is an index?
A) A structure that enables you to locate rows in a table quickly, using an indexed value
B) A virtual table based on the result set of a query
C) A structure comprising rows and columns that you use for storing data
A) A structure that enables you to locate rows in a table quickly, using an indexed value
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?
A) Increased day-to-day management costs
B) Increased scalability
C) Increased functionality
B) Increased scalability
Which of the following services should you use to implement a non-relational database?
A) Azure Cosmos DB
B) Azure SQL Database
C) The Gremlin API
A) Azure Cosmos DB
Which of the following is a characteristic of a non-relational databases?
A) Non-relational databases contain tables with flat fixed-column records
B) Non-relational databases require you to use data normalization techniques to reduce data duplication
C) Non-relational databases are either schema free or have relaxed sachems
C) Non-relational databases are either schema free or have relaxed sachems
What is data ingestion?
A) The process of transforming raw data into models containing meaningful information
B) Analyzing data for anomalies
C) Capturing raw data streaming from various sources and storing it
C) Capturing raw data streaming from various sources and storing it
Which one of the following visuals displays the major contributors to a selected result or value?
A) Key influencers
B) Column and bar chart
C) Matrix chart
A) Key influencers
Which type of analytics helps answer questions about what has happened in the past?
A) Descriptive analytics
B) Prescriptive analytics
C) Predictive analytics
A) Descriptive analytics
Which deployment requires the fewest changes when migrating an existing SQL server on-premises solution?
A) Azure SQL Database Managed Instance
B) SQL Server running on virtual machine
C) Azure SQL Database Single Database
B) SQL Server running on virtual machine
Which of the following statements is true about SQL Server running on a virtual machine?
A) You must install and maintain the software for the database management system yourself, but backups are automated.
B) Software installation and maintenance are automated, but you must do your own backup
C) You’re responsible for all software installation and maintenance, and performing back ups
C) You’re responsible for all software installation and maintenance, and performing back ups
Which of the following statement is true about Azure SQL Database?
A) Scaling up doesn’t take effect until you restart the database
B) Scaling out doesn’t take effect until you restart the database
C) Scaling up or out will take effect without restarting the SQL database
C) Scaling up or out will take effect without restarting the SQL database
When using an Azure SQL Database managed instance, what is the simplest way to implement backups?
A) Manual Configuration of the SQL server
B) Create a scheduled task to back up
C) Backups are automatically handled
C) Backups are automatically handled
What is the best way to transfer the data in a PostgreSQL database running on-prem into a database running Azure Database for PostgreSQL service?
A) Export the data from the on-premises database and import it manually into the database running in Azure
B) Upload a PostgreSQL database backup file to the database running in Azure
C) Use the Azure Database Migration Services
C) Use the Azure Database Migration Services
