AsCEnD Advanced DotNet

DotNet Advanced Concepts Assessment

Q1. Number of threads that exists for each of the processes that occurs in the program

Answer: Atleast 1

Q2. Which of the following statement is correct?

Answer: Anonymous types are class types that derive directly from object.

Q3. We can create nested anonymous type

Answer: TRUE

Q4. Choose the namespace which supports multithreading program

Answer: System Threading

Q5. What is the correct statement about lambda expression?

Answer: The return type of lambda expression can be neglected in some cases

Q6. Which of these methods of Thread class is used to Suspend a thread for a period of time?

Answer: sleep()

Q7. Select the type of multitasking methods that exist

Answer: Process based and thread based

Q8. Choose the correct statement about process-based multitasking

Answer: Both

Q9. What types of Objects can you query using LINQ?

Answer: All of the above

Q10. LINQ is ____________.

Answer: Language Integrated Query

Q11. Which of the following supports LINQ queries?

Answer: All of the above

Q12. What LINQ expressions are used to shape results in a query

Answer: Group & Select

Q13. Correct syntax for declaring anonymous type

Answer: var Emp=new {ID=106,Name="Priya"};

Q14. Which LINQ keyword is used to categorize results in a query?

Answer: group

Game of Skills - SQL Warriors

SQL Warriors

Q1. As part of New ways of learning' Initiative. TCS engages candidates through Digital technologies, Hackathons and Biz Play

Answer: YES

Q2. You have missed the survey to provide location and date for proctored assessment. You would like to attend the upcoming assessment in the loan centre which is near to your home. You can attend the assessment if you have a copy of your offer letter.

Answer: NO

Q3. Back Ground check (BGC) is not applicable for all new joinees.

Answer: NO

Q4. You are allowed to take proctored assessments until you receive joining letter

Answer: YES

Q5. During proctored assessment, you noticed that your reference number in the allocated system is not right but name matches. It is ok to continue the exam as long as your name matches.

Answer: NO

Q6. If you clear proctored assessment with Boy and above, you will get readiness and competency Incentives

Answer: YES

Q7. Both, Readiness & Competency Incentive are recoverable from the Employee, the associate resigns & leaves service within 12 months

Answer: YES

Q8. Your friend and you got the TCS offer letter on the same day. Your friend has access to Xplore courses. She is really enjoying the courses and scaling up her knowledge. You have not yet accepted TCS offer letter, but would like to access xplore courses. Will it be possible?

Answer: NO

Q9. Is it mandatory to have PAN card before joining TCS?

Answer: YES

Q10. Your friend got offer from other organisation and he accepted it. He is y curious to know about TCS xplore program. He asked your credentials to check the courses. There is no harm in sharing login credentials as he is your best friend.

Answer: NO

TCS Xplore Hackathon Java - Hackerrank SQL

Unit - Hackerrank Activities - SQL

Q1. Employee Count in Each Department(Department wise)

Write the SQL query to display the name of the department along with the count of employees working in it.

Solution:
select Departments.deptName,COUNT(Employees.eDeptId) From departments LEFT Join Employees on Departments.deptId=Employees.eDeptId Group By Departments.deptId,Departments.deptName Order by count(Employees.eDeptId) Desc, departments.deptName;

Q2. Display Department Details

Write the SQL query to print the department id and name of the respective Department for all the departments which are located in Ground Floor

Solution:
select Dept_Id,Dept_Name from Department where Dept_Location='Ground Floor';

Q3.Display non-Programmer Department name

Write the SQL query to print the names of the departments which does not have any Programmers.

Solution:
select distinct Dept_name from Departments,Employees where Dept_ID=Emp_Dept_Id and Dept_name not in (select distinct Dept_name from Departments,Employees where Dept_id=Emp_Dept_Id and Emp_Skill like'Programmer');

AsCEnD Bigdata

AsCEnD Bigdata Assessment

Q1. Which of the following is component of Hadoop?

Answer: All Are Correct

Q2. Which of the following is a common reason to restart hadoop process?

Answer: All Are Correct

Q3. The output key of the Mapper must be identical to the Input key of the reducer.

Answer: FALSE

Q4. Which of the file contains the configuration settings for HDFS daemons?

Answer: All Are Connected

Q5. What is a combiner ?

Answer: Runs Locally on a single Mappers output

Q6. The archive file created in Hadoop has the exteNsion of ?

Answer: har

Q7. Which of the following is component of Hadoop?

Answer: All Are Correct

Q8. Which command is used to copy file or directories recursively in Hadoop?

Answer: dcp

Q9. Hadoop works in which model?

Answer: Master-slave fashion

Q10. Which of the following is a column-oriented database that runs on top of HDFS?

Answer: Hbase

Q11. The client reading the data from HDFS file system in Hadoop does which or the following?

Answer: Get only the block locations for the namenode

Q12. Secondary Name Node is the backup of Name Node?

Answer: FALSE

Q13. You have the following key value pairs as output from your Map task
(the t)
(fox 1)
(faster 1)
(than 1)
(the 1)
(dog 1)
How many keys will be passed to the Reducer ?

Answer: 5

Q14. Zero reducers are allowed in Map Reduce?

Answer: TRUE

Q15. What is Replication Factor?

Answer: Replication factor controls how many times each individual block can be replicated

AsCEnD Devops

AsCEnD Devops Assessment

Q1. DevOps is focused on ________.

Answer: Test Automation

Q2. Which automation practice helps in quick identification of any problem in production environment

Answer: Continuous Deployment

Q3. In DevOps, How often you should deploy your code to production environment

Answer: Daily

Q4. In DevOps, which team gets priority ?

Answer: Development

Q5. The process of frequently merging of codes automatically is called

Answer: Continuous Integration

Q6. Continuous Delivery is the process of __________.

Answer: Frequent deployment to production

Q7. CICD stands for ___________.

Answer: Continuous Integration, Continuous Delivery

Q8. Infrastructure As A Code (IAAS) refers to

Answer: Managing Infrastructure As Code using Automation

Q9. The Benefit of CI

Answer: Early Detection of Bugs

Q10. The key pain area prior to DevOps was

Answer: Collaboration between Development and Operation

Q11. DevOps is a ___________.

Answer: Culture

Q12. DevOps Stands for _________________.

Answer: Development Operations

Q13. Jenkins is a _________.

Answer: CI Tool

Q14. DevOps is an extension of ________.

Answer: Agile

TCS Xplore Hackathon Java - Hackerrank Unix

Unit - Hackerrank Activities - Unix

1. Unix : Count occurrence of word

Write the unix command to count the occurrence of the word "Unix" in a given file.

The file will be given as command line argument while the script containing your command will be run.

Note : The search for "Unix"  should be case-insensitive.

For example,

If the input file contains the following lines
Unix is an multi-user,multi-tasking system.
It is a command based operating system.
We will learn unix  architecture and the unix commands in  this module.

Then the output will be,
3

Solution: grep -o -i unix | wc -l

2. Unix : Word Count

Write the unix command to count the number of words in the first 3 lines of a file.

The file will be given as a command line argument when the script containing your command will run.

For example,

If the input file contains the following lines

Unix is a command based operating system.

We will learn unix in this module.

This is a test file.

We are using this file to practice some commands.

We have reached the end of the file.

The output will be,

19

Solution: head -3|wc -w

3. Unix: Find sum of even numbers

Write a shell script to find the sum of all even numbers from a list of given numbers. The script should first of all take the count of numbers to be added as user input followed by the numbers one by one.

The output should print the following :

Total = <Sum>

Console Input:

The input needs to be provided as -

The first line contains the count of numbers to be added.

The second line contains the 1st number to be added.

The third line contains the 2nd number to be added. and so on.

For example,

if we want to provide 10, 20 and 30 as the numbers then provide the input as

3

10

11

30

The output for this  example will be 

Total = 40

Solutions:

read n

awk '

    BEGIN {

        sum=0;

        }

     { if ( $0%2==0 ){

        sum+=$0;

      }

      }

     END { print "Total","=",sum}'

4. Unix: Highest Score

​Student details are stored in a file in the following order with space as the delimiter:

RollNo Name Score

Write a unix command to find the name of the Student who has the highest score.

The file will be given as a command line argument when the script containing your command will run.

For example,

If the input file has the below content

RollNo Name Score

234 ABC 70

567 QWE 12

457 RTE 56

234 XYZ 80

456 ERT 45

The output will be

XYZ

Solution: sort -k3,3 -rn -t" " | head -n1 | awk '{print $2}'

5. Unix: Average Salary

Employee Details are stored in a file in the following format:
EmpID;EmpName;Salary

Write a shell script to find the count of employees whose salary is less than the average salary of all employees.

The file with the employee details will be given as a command line argument when your script will run.
For example,
If the input file contains the following employee records
EmpID;EmpName;Salary
100;A;30000
102;B;45000
103;C;15000
104;D;40000

The output will be,
2

Solutions:

lim=10

max=0

salary=0

read

n=0

#count the avg plus store in array

for i in $(seq $lim)

do

read line

num=$(echo "$line"|cut -d ";" -f3)

if [ $num -gt 0 ];

then 

salary=$((salary+num))

arr[n]=$num

n=$((n+1))

fi 

done;

avg=$((salary/n))

#count now 

count=0

for val in ${arr[@]}

do

if [ $val -lt $avg ];

then

count=$((count+1))

fi

done;

echo "$count"

(or)

awk 'BEGIN {FS = ";"} ; {s += $3; ++c;a[$3] += $3;k[$1] += $1}  END{ for (i in a) if(i<s/(c-2)) p+=1;for (j in k);if(j == 5) {print(p+1)} else if(j == 6) {print(p)} else {print(p-1)}}'

AsCEnD Datawarehouse

AsCEnD Dataware house Assessment

Q1. Interactive computer based systems intended to help decision makers utilize data and solve problems to make faster decisions

Answer: Business Intelligence

Q2. A temporary area where data is stored after extraction from the source

Answer: Staging area

Q3. Railway Reservation is an example of which system

Answer: OLTP

Q4. Dimension tables can be connected via foreign key in which of these schemas

Answer: Star

Q5. Database Tables in a star schema are typically denormalized

Answer: TRUE

Q6. Data marts in top down approach are called

Answer: Top down data marts

Q7. The data warehouse approach in which EDW is built first and data marts are derived from it later is called

Answer: Top down approach

Q8. Which of the following is not an ETL tool

Answer: Tableau

Q9. Critical metrics for measuring performance of a business

Answer: Ad Hoc reports

Q10. Data from a single source only can be moved to a data warehouse

Answer: FALSE

Q11. A dimension without any associated attribute is called

Answer: Degenerate dimension

Q12. Datastore used to analyse near real-time data

Answer: ODS

Q13. R in ROLAP stands for __________.

Answer: Relational

Q14. Miniature data warehouse that supports the requirement of a particular department or business process

Answer: DSS

Q15. ________ is a process that transforms raw data into meaningful and useful information for business purpose

Answer: Business Intelligence

Q16. Overall management of the availability, usability integrity and security of the data employed in an enterprise...

Answer: Duta Governance

Q17. The dimensions which contribute to the grain are called

Answer: Primary dimension

Q18.Fact table which has dimension keys but no measures is called

Answer: Factless fact table

Q19. Which of the following are the types of facts

Answer: Additive facts

Q20. Systems used to handle complex queries to discover trends and patterns

Answer: OLAP

AsCEnD Azure Cloud

AsCEnD Azure Assessment

Q1. The ________ cloud model offers organizations the most ownership and control.

Answer: private

Q2. When should you 'scale up' your deployment?

Answer: When your application or service requires a more powerful CPU or more memory to run faster

Q3. Which of the following Azure services is NOT part of the compute services?

Answer: Virtual Networks

Q4. ________ is owned and operated by the organization that uses the resources from that cloud.

Answer: Private cloud

Q5. __________ refers to the practice of paying up-front for a product or service (ie infrastructure) your tax bill over time.

Answer: Operational expenditure

Q6. What does it mean if a service is in Private Preview mode?

Answer: You have to apply to get selected to use that service

Q7. Which of the following is an example of an Azure application platform?

Answer: Azure App Service

Q8. __________ is used primarily to allow multiple organizations to share its resources and services.

Answer: Public cloud

Q9. What does it mean if a service is in General Availability (GA) mode?

Answer: Anyone can use the service for any reason

Q10. Why is Azure App Services considered Platform as a Service?

Answer: You give Azure the code and the configuration, and you have no access to underlying hardware

Q11. Which of the following ensures data-residency and compliance needs are met for customers who need to keep...

Answer: Geographies

Q12. Azure claims there are approximately 54 regions. But when I create my account, I can only see 30 of 54. So...

Answer: Some regions like Azure Germany, Azure China and Azure Government require separate accounts to access.

Q13. A service or solution that experiences little to no downtime for an extended period of time is considered to be...

Answer: highly available

Q14. Leveraging cloud services allows organizations to take advantage of ________.

Answer: All of the above

Q15. Where do you find virtual machine images provided by third party companies within the Azure Portal?

Answer: In the Azure Marketplace

Q16. Financially speaking, one of the benefits of using cloud computing over hosting applications yourself on services...

Answer: the tax and cash flow benefits of using Operational Expenditure (OpEx) instead of Capital Expenditure (CapEx).

Q17. Which of Azure's architectural components allows you to specify exactly which data center in a region a virtual...

Answer: Availability Zones

Q18. Even without paying for support, you can still open a support ticket if you encounter a problem such as...

Answer: TRUE

Q19. Deploying an app can be done directly to what level of physical granularity?

Answer: Region

Q20. How many minutes per month of downtime is 99.99% availability?

Answer: 4 minutes

Q21. What is the principle of Economies of Scale?

Answer: Scaling (upscaling/downscaling) allows you to save money compared with always having way more resources

Q22. Which cloud computing model does a virtual machine fall into?

Answer: IAAS

Q23. _______ allows an organization to run its application either in the cloud or on-prem.

Answer: Hybnd cloud

Q24. What does the term 'application availability mean?

Answer: The overall time that a system is functional and working

Q25. What are Azure Availability Zones?

Answer: A feature of Azure that lets you to manually specify into which data centre your virtual machines are...

Q26. What is it that makes it public versus private, in terms of public cloud?

Answer: Anyone with a credit card can sign up for the public cloud computing. There is generally no restriction

Q27. Microsoft Office 365 is an example of

Answer: SAAS

Q28. Azure charges for bandwidth used 'inbound' to Azure.

Answer: FALSE

Q29. When you deploy multiple resources that are part of a single solution AND share the same lifecycle...

Answer: Resource Group

Q30. The _________ cloud model offers organizations the most flexibility.

Answer: hybrid