Quiz
DP-900 part2
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (39)
1An extract, load, and transform (ELT) process requires
- Aa separate transformation engine.
- Ba target data store powerful enough to transform data.
- Cdata that is fully processed before being loaded to the target data store.
- Da data pipeline that includes a transformation engine
2You need to create an Azure resource to store data in Azure Table storage. Which command should you run?
- Aaz storage share create
- Baz storage account create
- Caz Cosmosdb create
- Daz storage container create
3The Azure Cosmos DB __ API enables the use of SELECT statements to retrieve documents from Azure Cosmos DB
- ACore (SQL)
- BGremlin
- CMongoDB
- DTable
4You need to modify a view in a relational database by adding a new column. Which statement should you use>
- AMERGE
- BALTER
- CINSERT
- DUPDATE
5Extract, transform, and load (ETL) can reduce the transfer of sensitive data to destination systems.
- ATrue
- BFalse
6Extract, load, and transform (ELT) transforms data by using a compute resource independent of the source system and destination system.
- ATrue
- BFalse
7Extract, load, and transform (ELT) minimizes the time it takes to copy large volumes of data to destination systems.
- ATrue
- BFalse
8PostgreSQL on Azure VMs
- AIaaS
- BPaaS
- CSaas
9Azure Database for PostgreSQL
- AIaaS
- BPaaS
- CSaaS
10__ natively support the analysis of relationships between entities
- AColumn family databases
- BDocument databases
- CGraph databases
- DKey-value stores
11Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?
- AAzure Table Storage
- BAzure Data Lake Storage
- CAzure Queue storage
- DAzure Files
12Relational data is stored in
- Aa file system as unstructured data.
- Ba hierarchal folder structure.
- Ca tabular form of rows and columns.
- Dcomma-separated value (CSV) files.
13__ physically sorts the data in a table based on the values in a specified column.
- AA view
- BA clustered index
- CA stored procedure
- DA non-clustered index
14A block of code that runs in a database is called
- Aa stored procedure.
- Ba table.
- Ca view.
- Dan index.
15Why did sales increase last month?
- ACognitive
- BDiagnostic
- CDescriptive
- DPredictive
- EPrescriptive
16Provide specific guidance on how to allocate current budget to buy different inventory items.
- ACognitive
- BDiagnostic
- CDescriptive
- DPredictive
- EPrescriptive
17Detect images of the company's logo included in PDF documents.
- ACognitive
- BDiagnostic
- CDescriptive
- DPredictive
- EPrescriptive
18__ presents content defined by a query.
- AA heap
- BA stored procedure
- CA view
- DAn index
19Which type of database is Azure Database for PostgreSQL?
- APaaS
- BIaaS
- CMicrosoft SQL Server
- Don-premises
20Which storage solution supports access control lists (ACLs) at the file and folder level?
- AAzure Data Lake Storage
- BAzure Queue storage
- CAzure Blob storage
- DAzure Cosmos DB
21A __ is a chart of coloured rectangles. The size of the rectangles represent the relative value of each item. The chart can be hierarchical, displaying data as a set of rectangles within the main rectangle.
- Aline chart
- Bmatrix
- Cscatter
- Dtreemap
22what is a characteristic of batch processing?
- AThe data ingested during batch processing must be processed as soon as the data is received
- BLarge datasets must be split into batches of less than 1 GB before the data can be processed.
- CThere is a noticeable time delay between ingesting data and obtaining the data processing results.
- DBatch processing can only process data is structured.
23In a SQL statement, __ are examples of aggregate functions.
- AFROM and WHERE
- BGROUP BY and ORDER BY
- CJOIN and MERGE
- DMAX and MIN
24A job that processes sales data once daily is an example of a batch workload.
- ATrue
- BFalse
25A job that calculates a rolling average temperature reading is an example of a streaming workload
- ATrue
- BFalse
26A job that calculates average revenue per product for the last month is an example of a streaming workload.
- ATrue
- BFalse
27In a relational database, each row in a table has
- Aa different set of columns
- Ba key-value pair
- Cthe same set of columns
- Dunstructured data
28Normalizing a database increases the throughput of writing transactions.
- ATrue
- BFalse
29Analytics systems are more normalized than transactional systems.
- ATrue
- BFalse
30Normalizing a database results in queries that require more joins.
- ATrue
- BFalse
31__ natively support the analysis of relationships between entities.
- Acolumn family databases
- BDocument databases
- CGraph databases
- DKey-Value stores
32A key/value data store is optimised for
- Aenforcing constraints.
- Bsimple lookups.
- Ctable joins.
33In an infrastructure as a service (IaaS) instance of __ that hosts SQL Server Microsoft SQL Server on Azure, you manage the __ that hosts SQL Server
- Aelastic pool
- BMySQL server
- CPostgreSQL server
- Dvirtual machine
34Varying fields for each entity in a JSON document is an example of
- Arelational data.
- Bsemi-structured data.
- Cstructured data.
- Dunstructured data.
35A JSON document is an example of
- Agraph data.
- Brelational data.
- Csemi-structured data.
- Dunstructured data.
36Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?
- Aatomicity
- Bisolation
- Cdurability
- Dconsistency
37When you create an Azure SQL database, which account can always connect to the database?
- AThe Azure Active Directory (Azure AD) account that created the database
- BThe server admin login account of the logical server
- CThe Azure Active Directory (Azure AD) administrator account
- DThe SA account
38You need to query a table named Products in an Azure SQL database.
Which three requirements must be met to query the table from the internet?- AYou must be assigned the Reader role for the resource group that contains the database.
- BYou must have SELECT access to the Products table.
- CYou must have a user in the database.
- DYou must be assigned the Contributor role for the resource group that contains the database.
- EE. Your IP address must be allowed to connect to the database.
39Your company needs to ensure that an Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet.
What should you use?- AAzure Application Gateway
- BAzure Traffic Manager
- CAzure DNS
- DAzure Private Link
Information
- Description
- Quiz on DP-900 part2, created by Annika LAIRD on 28/11/2022.
- Author
- Annika LAIRD
- Language
- English
- Views
- 17
- Rating
- No ratings yet Rate this quiz