Question: What are some of the essential components of Azure SQL data warehouse?
Master node
Replicas
Storage
MPP
Ans:-
Storage
MPP
Question: Specify some of the characteristics of Sharding using Hash algorithms.
The number of table rows per distribution are different
Each row in the data table belongs to a single distribution
Each row in the data table has their respective individual distributions
The number of table rows per distribution are the same
Ans:-
The number of table rows per distribution are different
Each row in the data table belongs to a single distribution
Question: What are some of the critical business factors that can affect the Data Warehouse design?
Business strategy
Organizational management reshuffle
Business analysis
Market growth trend
Ans:-
Business strategy
Market growth trend
Question: Which of the following Data modelling techniques can we adopt in our Data Warehouse implementations?
Tabular model
Snowflakes
ER model
EP model
Ans:-
Snowflakes
ER model
Question: Identify some of the essential command that we can use when creating Gen 2 SQL data warehouses.
New-sqlserver
New-AzureRmSqlServer
Add-AzureRmAccount
New-AzureRmSqlDW
Ans:-
New-AzureRmSqlServer
Add-AzureRmAccount
Question: Which of the following elements are requirement to connect to a data warehouse using SSMS?
Server name
Windows authentication
SQL authentication
Store name
Ans:-
Server name
SQL authentication
Question: Specify some of the prominent types of tables that we can derive from the perspective of Data storage.
Permanent table
Regular table
Permanent table
External table
Ans:-
Regular table
External table
Question: Which of the statements are valid SQL statements that we can use when creating a table?
Create Table Table_Name
Create Table Table_Name Column_Name
Create NewTable Table_Name
Column1_Name Column1_datatype Column1_Nullability
Ans:-
Create Table Table_Name
Column1_Name Column1_datatype Column1_Nullability
Question: Specify some of the essential differences between an SQL server and SQL Data warehouse.
SQL servers support full text search while SQL Data warehouses don’t
SQL servers supports Geo-replication while SQL Data warehouses don’t
SQL Data warehouses supports Distributed transactions while SQL servers don’t
SQL Data warehouses supports Service brokers while SQL servers don’t
Ans:-
SQL servers support full text search while SQL Data warehouses don’t
SQL servers supports Geo-replication while SQL Data warehouses don’t
Question: Which of the following approaches can we adopt to distribute tables in a SQL Data warehouse?
Election
Replication
Hash algorithms
Duplication
Ans:-
Replication
Hash algorithms
Question: Specify some of the essential Azure resources that we need in order to create SQL data warehouses.
Domain
Server
Application string
Resource group
Ans:-
Server
Resource group
Question: Define some of the essential principles of designing SQL data warehouses.
We must design the data warehouse for transaction
We must design the data warehouses for operations
We must design data warehouse from the perspective of the customers’ requirements
When designing data warehouses we must consider the best data store
Ans:-
We must design the data warehouses for operations
When designing data warehouses we must consider the best data store
Question: Which of the following patterns should we consider when designing Azure SQL data warehouse?
Monolithic persistence
Synchronous I/O
Circuit breaker
Backends for front-ends
Ans:-
Circuit breaker
Backends for front-ends
Question: Which of the following statements are true for SQL data warehouse state management?
We cannot load data to the instances that are in an online state
We can connect to the paused instances
We need to ensure that the SQL data warehouse is in an online state in order to process queries
We cannot connect to the paused instances
Ans:-
We can connect to the paused instances
We cannot connect to the paused instances
Question: What are some of the important elements that we must include in the PowerShell command when we are loading data into SQL Data warehouses using PowerShell?
Column name
SQL Database server
Table name
SQL Database location
Ans:-
SQL Database server
Table name
Question: What are some of the important elements that we must configure when we want to load data to SQL Data warehouses using Azure Data Factory?
Destination data store
Source file schema
Destination data model
Source data store
Ans:-
Destination data store
Source data store
Question: Which of the following types of Source Connection managers can we use when loading data to SQL Data Warehouses using SSIS?
Hadoop
File
SQL server
Azure SQL managed instances
Ans:-
Hadoop
File
Question: Which of the following scaling factors are valid options that we can use when scaling Azure SQL data warehouses?
Gen 4
Gen 10
Gen 0
Gen 2
Ans:-
Gen 4
Gen 2
Question: What are some of the essentials steps involved in implementing ELT for SQL data warehouses?
Deleting the expressions
Configuring data sources
Evaluating the ingestion mechanism
Configuring the data destinations
Ans:-
Configuring data sources
Configuring the data destinations
Question: Which type of Microsoft Azure cloud resource is required for Azure VPN connectivity?
Virtual network gateway
Storage account
Ans- Virtual network gateway
Question: Which PowerShell cmdlet is used to create PKI certificates?
New-Certificate
New-SelfSignedCertificate
Ans- New-SelfSignedCertificate
Question: Which is required prior to generating PKI certificates in the Microsoft Azure cloud?
VNet
Key vault
Ans- Key vault
Question: What must be done prior to protecting personally identifiable information?
Data archiving
Data classification
Ans- Data classification
Question: Which PKI key is used to encrypt messages?
Symmetric
Public
Ans- Public
Question: How does NoSQL database storage differ from relational SQL database storage?
NoSQL is designed for big data storage
NoSQL uses a more rigid schema
NoSQL uses a less rigid schema
SQL is designed for big data storage
Ans- NoSQL is designed for big data storage
NoSQL uses a less rigid schema
Question: Which of the following are the most common types of VPN authentication methods?
LDAP
Kerberos
PKI certificate
RADIUS
Ans- PKI certificate
RADIUS
Question: Which term describes rule sets that control resource data access?
RBAC
Access control list
Ans- Access control list
Question: You are creating a key in a Microsoft Azure key vault. What are the available key type options?
Blowfish
EC
SHA
RSA
Ans- EC
RSA
Question: Which term refers to tags added to data for classification purposes?
Policies
Metadata
Ans- Metadata
