NEW
Font size
WorksheetsTechnical Quiz & Challenge
Total questions: 22
Worksheet time: 11mins
After changing the default block size and restarting the cluster, to which data does the new size apply?
all data
no data
existing data
new data
Data node failure is handled by?
Replication-factor
Checkpointing
Block Report
Secondary NameNode
What will happen if the block size in Hadoop cluster is set to 4KB?
Under utilization of cluster.
Lesser number of blocks are created.
Over burdening of NameNode
Better parallelism will be achived.
Suppose, in Hadoop 2.0 we have a 750 MB of input file and there are 3 nodes in the cluster, with default replication factor, what will be the total number of blocks generated in HDFS for that file?
10
24
12
18
What kind of scaling does HDFS supports primarily?
Vertical
Horizontal
Adaptive
Diagonal
How NameNode gets to know if a data block is corrupted?
Heartbeat
Secondary NameNode sends Notification
Metadata
Block Report
What does Apache Spark provide?
storage + computation
all things whatever Hadoop core provides
Only computation
Only storage.
Command to rename a file
Hadoop fs -cp
Hadoop fs -mv
Hadoop fs -get
Hadoop fs -rename
What will this command do?
ls -ltr|tail
It will error out
display 10 oldest files/folders
display 10 newest files/folders
display 20 newest files/folders
How to find out how many lines in file contains the word hello?
ls file.txt|grep hello| wx -l
cat file.txt|grep hello| wc -l
grep hello| wc -l|cat file.txt
it will error out
In SQL Which is better truncate or delete?
truncate
delete
both truncate and delete have same performance.
Is there an error with this query? If so, which statement best describes the problem?
SELECT OrderID, SUM(LineTotal) AS SubTotal
FROM Sales
WHERE SUM(LineTotal) > 1000
GROUP BY OrderID
ORDER BY OrderID;
Yes, you cannot GROUP BY and ORDER BY the same field.
Yes, the WHERE clause should use the SubTotal alias.
No, there is nothing wrong with this query.
Yes, a WHERE clause cannot be used with an aggregate function.
In Telstra which Redundancy is maintained for prod b2b adls storage account.
LSR
ZRS
LA-GRS
GZRS
In Telstra B2B DH, what is the minimum number of nodes that will be used when ADF python activity is ran to load IDMS table using IDM linked service.
0
1
2
3
4
In Telstra B2B DH, what will be minimum number of worker nodes that will be used when ADF python activity is ran using single node linked service
0
1
2
3
4
In Telstra B2B DH, what will be maximum number of worker nodes that will be used when ADF python activity is ran using IDM linked service
3
4
5
6
DataLake supports updates and Delete.
True
False
What does BLOB in SQL stand for?
Binary Large object
big large object
Binary language for object
none
Why is the name node no longer a single-point of failure in Hadoop 2?
Replication-factor
Block Report
Heart Beat
Checkpointing
print(2**3 + (5 + 6)**(1 + 1))
129
8
121
12
Which answer is NOT a type of table index?
nonclustered
nonclustered
unique
heap
hash
Point out the correct statement.
Spark enables Apache Hive users to run their unmodified queries much faster
Spark interoperates only with Hadoop
Spark is a popular data warehouse solution running on top of Hadoop
All of the above
