Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
171 Cards in this Set
- Front
- Back
|
What occurred in the past |
|
|
No, Yes Yes |
|
|
Data that is fully processed... |
|
|
The same set of columns |
|
|
Yes, No, Yes |
|
|
Graph databases |
|
|
Virtual Machine |
|
|
Semi-structured |
|
|
Semi-structured |
|
|
A |
|
|
C |
|
|
A |
|
|
Data engineer |
|
|
B |
|
|
Table, view, index |
|
|
D |
|
|
D |
|
|
SSMS, DATA STUDIO, SSDT |
|
|
Yes, no, yes |
|
|
A |
|
|
Yes, yes, yes |
|
|
Yes, yes, yes |
|
|
Yes, yes, yes |
|
|
Table, column |
|
|
No, no, yes |
|
|
D |
|
|
Yes, no, yes |
|
|
C |
|
|
A,D |
|
|
Select, group by |
|
|
B |
|
|
D |
|
|
C |
|
|
B |
|
|
B |
|
|
Server level firewall |
|
|
A |
|
|
Firewall, authentication, encryption |
|
|
A |
|
|
Strong consistency guarantees are required |
|
|
Keys |
|
|
A view |
|
|
BCE |
|
|
D |
|
|
A |
|
|
Azure synapse analytics |
|
|
Clustered index |
|
|
Primary key |
|
|
A view |
|
|
C |
|
|
Latency |
|
|
Cognitive |
|
|
Diagnostic, prescriptive, cognitive |
|
|
Root obj, nested obj, nested array |
|
|
Star schema, dimension |
|
|
A |
|
|
Clustered index |
|
|
Transactional writes |
|
|
Yes, yes, yes |
|
|
CRM, DWH, DWH |
|
|
Treemap, key influencers, scatter |
|
|
B, D |
|
|
Yes, no, no |
|
|
C |
|
|
B |
|
|
Simple lookups |
|
|
Image, relationship, key pairs |
|
|
Dataset, linked, pipeline |
|
|
Batch, streaming, batch |
|
|
CRM, DWH, DWH |
|
|
A |
|
|
D |
|
|
Cognitive |
|
|
Descriptive |
|
|
D |
|
|
Core |
|
|
B |
|
|
Yes, no, yes |
|
|
Iaas, Paas |
|
|
B |
|
|
Rows +columns |
|
|
Stored procedure |
|
|
Diagnostic, prescriptive, cognitive |
|
|
A |
|
|
A |
|
|
Treemap |
|
|
C |
|
|
Max and Min |
|
|
Yes, yes, no |
|
|
API which can be changed |
|
|
Key, object, graph |
|
|
A,C |
|
|
D |
|
|
B |
|
|
A |
|
|
A as uses json |
|
|
Gremlin, mongo, table |
|
|
Hierarchical namespaces |
|
|
Nodes and edges using gremlin |
|
|
B |
|
|
D |
|
|
A |
|
|
Yes, Yes, Yes |
|
|
Cosmos, files |
|
|
Account |
|
|
B |
|
|
Cosmos DB |
|
|
Enable the hierarchical namespaces |
|
|
Graph |
|
|
File |
|
|
Columnar |
|
Columnar is good for.... data. analytical or transactional |
Transactional |
|
|
Azure files |
|
|
N,Y,N |
|
|
Document |
|
|
Object |
|
|
Time series- large data for real time use |
|
|
Y,Y,Y |
|
|
Graph |
|
|
Y,N,Y |
|
|
Self describing entities |
|
|
Streaming |
|
|
Pause the pool |
|
|
A trigger |
|
|
OLAP |
|
When a data warehouse is mentioned for processing what processing is used? |
Online analytical processing |
|
|
Movement, transformation, control |
|
|
B,D,F |
|
|
A,B |
|
|
A control flow |
|
|
A report |
|
|
Synapse, HDInsight, Databricks |
|
|
OLAP- data warehouse analysis as there is no transaction that can happen from a warehouse |
|
|
A,C,E |
|
What is a JSON format in terms of data type? |
Semi-structured |
|
|
Y,N,Y |
|
|
An integration runtime |
|
|
Paginated report |
|
|
A,C |
|
|
Polybase |
|
What is polybase? |
Used to access external data in blob storage/lake via T-SQL |
|
|
Y,N,Y |
|
|
B,D,F |
|
|
A |
|
|
Data factory, Synapse |
|
|
Batch,Batch, Streaming |
|
|
From multi to single location |
|
|
N,Y,Y |
|
|
Analytics, storage, Database |
|
|
Y,Y,N |
|
|
Builder |
|
ETL VS ELT |
ETL: raw material transformed into goods before shipping. ELT: raw material stored and transformed when needed during shipping. |
|
What is azure synapse analytics? |
Analyzes large amount of data, ingesting, managing for use in businesses. |
|
What is Analysis services? |
Provides business reports for powerBI |
|
What is CosmosDB? |
Doesn't use SQL data instead, Supports doc, key-value graph, column family models, low latency. |
|
|
Data factory -> synapse |
|
OLAP VS OTAP? |
OLAP: for data analytics e.g. data warehouse. OTAP: for transactions e.g. bookings |
|
|
C |
|
|
B |
|
|
A |
|
|
No, yes, no |
|
|
The database to protect data at rest |
|
|
D |
|
|
Single, MI, Single |
|
|
Descriptive |
|
|
Account, container |
|
|
B,D |
|
|
YES, NO, YES, YES |
|
|
Y,N,Y,Y |
|
|
Polybase |
|
What is Table storage? |
NO-SQL key value store, scalable, cost effective and can use unstructured data |