Question#1 ______ is build on top of Azure Blob Storage.
i) Azure data lake store gen 1
ii) Azure data lake store gen 2
iii) None of the options mentioned
Answer- Azure data lake store gen 2
Question#2 How may copies of the data does ADLS maintain for high availability of data provisioning.
i) 1
ii) 2
iii) 3
iv) 4
Answer- 3
Question#3 While creating ADLS Gen 1 using CLI which parameter ensures that the folder is to be created with the given name.
i) –folder
ii) –file
iii) –directory
iv) None of the options
Answer- –folder
Question#4 ADLS manages what form of data.
i) Semi-structured
ii) Unstructured
iii) Structured
iv) All of the options
Answer- All of the options
Question#5 ______ function writes the custom queries to bring the desired data-sets for the queries.
i) Table value function
ii) Procedures
iii) Database
iv) Views
Answer- Table value function
Question#6 ______ language is used to create a script that runs the job which query the data to generate output for analysis.
i) P-SQL
ii) SQL
iii) C#
iv) U-SQL
Answer- U-SQL
Question#7 ______ is not a build in Extractor in U-SQL
i) Extractors.Tsv
ii) Extractors.Csv
iii) Extractors.Text
iv) Extractors.Xlsv
Answer- Extractors.Xlsv
Question#8 In ADLS Schema of the data is required to be defined before data is loaded
i) True
ii) False
Answer- False
Question#9 ADLS Gen1 provides a command line tool, AdlCopy, to copy data from Azure Blob to ADLS and vice-versa.
i) True
ii) False
Answer- False
Question#10 Account management / Authorization in microsoft Azure is implemented by RBAC which is also a built in feature.
i) True
ii) False
Answer- True
Question#11 You can enable access to only trusted clients by specifying an IP address or defining a range of IP addresses by setting up the firewall rules to cut down access to your data lake analytics at network level.
i) True
ii) False
Answer- True
Question#12 What is the purpose of data lake store?
i) Optimized and dedicated storage for bigdata analytics workload
ii) General purpose object store for variety of storage scenarios
Answer- Optimized and dedicated storage for bigdata analytics workload
Question#13 _______is an analytics job service that writes queries and extracts valuable insights from any scale of data.
i) Azure data lake store
ii) Azure SQL database
iii) Azure data lake analytics
iv) None of the options
Answer- Azure data lake analytics
Question#14 ADLS Gen1 provides which command line tool to copy data ?
i) AdlCopy
ii) Azure Data Factory
iii) Azure copy
iv) All of the options
Answer- AdlCopy
Question#15 Which extractor parameter is used to specify column separator whose default value is comma?
i) rowDelimeter
ii) skipFirstNRows
iii) silent
iv) delimeter
Answer- delimeter
Question#16 Which of the following is not an operation performed by data lake store gen 1?
i) ngest
ii) Prepare
iii) Analyze
iv) Scripting queries
v) Store
Answer- Scripting queries
Question#17 The standard RBAC role is
i) Contributor
ii) Owner
iii) Reader
iv) All of the options
Answer- All of the options
Question#18 If you has not mentioned the –folder parameter while creating the storage account using cli, it creates _____ named folder at the root location?
i) myfolder
ii) newfolder
iii) mynewfolder
iv) emptyfolder
Answer- mynewfolder
Question#19 Key Capabilities of data lake store gen 2 include which of the following?
i) Cost effective
ii) Hadoop Compatiblity access
iii) A superset of POSIX permissions
iv) All of the options
Answer- All of the options
Question#20 From which menu of the azure data lake analytics you can explore the added data sources?
i) Data Extractor
ii) Data explorer
iii) New Job
iv) None of the options
Answer- Data explorer
Question#21 What is the cost per GB that azure incurs in order to store first 100 TB of data in your data lake storage gen 1 account?
i) 3.00 INR
ii) 2.45 INR
iii) 2.52 INR
iv) 2.58 INR
Answer- 2.58 INR
Question#22 What are the permissions required to append a file that is located in a folder.
i) Not required any permission
ii) Write and Execute
iii) Read and Write
iv) Read and Execute
Answer- Write and Execute
Question#23 Azure data lake store gen 2 uses which component to organize data files into a hierarchy of directories for efficient data access?
i) Diversified storage
ii) Hadoop compatible access
iii) Hierarcial namespace
iv) None of the options
Answer- Hierarcial namespace
Question#24 _______ object is used to encapsulate the code that performs certain tasks regularly?
i) View
ii) Table value function
iii) Procedures
iv) Table
Answer- Procedures
Question#25 Data Operations – Authentication in ADLS is based on
i) Azure active directory
ii) Account access keys
iii) Shared access key
iv) All of the options
Answer- Azure active directory
Question#26 _________ is used for managing clusters after ingesting large volume of data clusters by extending various open sources such as hadoop, spark, pig, hive etc…
i) Analytics service
ii) HDInsight
iii) Diversified storage
iv) All of the options
Answer- HDInsight
Question#27 What is the account type that needs to be selected while creating an azure data lake storage gen 2 instance?
i) Storage gen 2
ii) General Account
iii) StorageV1
iv) StorageV2
Answer- StorageV2
Question#28 _________ helps in creating service alerts and control the cost of Azure data lake implementation.
i) Security mechanism
ii) Log analytics
iii) Azure data lake analytics
iv) None of the options
Answer- Log analytics
Question#29 Key Capabilities of data lake store gen 1 include which of the following?
i) Built for Hadoop
ii) Enterprise ready and highly available
iii) Unlimited storage
iv) All of the options
Answer- All of the options
Question#30 What is the file size limit imposed to be stored in ADLS ?
i) No limit
ii) 100TB
iii) 500TB
iv) 50GB
Answer- No limit
Question#31 Data Storage and analytics jobs combined performed in which layer of the streamed data management?
i) Data generation
ii) Storage
iii) Data processing
iv) None of the options
Answer- Storage
Question#32 Organizing data into larger files than many small files decreases the performance of the data lake store.
i) True
ii) False
Answer- False
