AZURE HANDSON

////////// HANDS-ON 1 /////////////////

1) az network vnet create -g resourceaddressgiveninkatacoda -n myvnet

2) az network vnet delete -g resourceaddressgiveninkatacoda -n myvnet

////////// HANDS-ON 2 /////////////////

1) az network nsg create -g resourceaddressgiveninkatacoda -n mynetworknsg

2) az network nsg delete -g resourceaddressgiveninkatacoda -n mynetworknsg


////////// HANDS-ON 3 /////////////////

start writing from step 3:-

1) STORAGEACCT=$(az storage account create --resource-group "resourceaddressgiveninkatacoda" --name "mystorageacct17" --location eastus --sku Standard_LRS --query "name" | tr -d '"')

2) STORAGEKEY=$(az storage account keys list  --resource-group "resourceaddressgiveninkatacoda"  --account-name $STORAGEACCT  --query "[0].value" | tr -d '"')

3) az storage share create --account-name $STORAGEACCT  --account-key $STORAGEKEY  --name "myshare"

4) az storage directory create --account-name $STORAGEACCT --account-key $STORAGEKEY --share-name "myshare" --name "myDirectory"

5) az storage file upload --account-name $STORAGEACCT --account-key $STORAGEKEY --share-name "myshare" --source "/home/scrapbook/tutorial/php-docs-hello-world/index.php" --path "myDirectory/index.php"

////////// HANDS-ON 4 ////////////////////

1) az vm create -n myvm -g resourceaddressgiveninkatacoda --admin-username gaurav --image UbuntuLTS --generate-ssh-keys

2) az vm delete -g resourceaddressgiveninkatacoda -n myvm 

Agile quiz

Agile - Quiz

1) Product owner
2) It is used to measure how much work is left to be done
3) The consistency reduces complexity and overhead
4) You cannot say anything for sure
5) Planning should involve the whole team

GIT HANDS-ON

Merge handson
Step1
git branch
git checkout feature1

Step2
git checkout master
git merge feature1

Step3
git checkout feature2
git checkout master
git merge feature2

Step4
git status

Step5
git commit -a
In vim file write
status and commit the changes

Step6
git branch -d feature1
git branch -d feature2

Undoing changes handson

Step1
git log --oneline
cat hello.py

In vim write
print("Hello World")
git commit -am "updated print statement"


Step2
git diff HEAD
git checkout hello.py

Step3
git status
git diff --cached
git reset

Step4
git status
git reset --hard HEAD

Step5
git reset HEAD~1
git commit -am "commit to revert"
git log --oneline
git show HEAD
git revert HEAD

Step 6
git revert HEAD...HEAD~3 --no-edit
cat hello.py
git log --oneline
2nd handson
Step 1:
ls
git init
Step2:
git remote add origun /s/remote-repo
git remote -v

Step3
git push origin master

Step4
git pull origin master

Step5
git clone <url>

1st handson
Step3:
git add hello-world.js
Step4:
git commit -m "commit message"
Step5:
touch .gitignore
git add .gitignore


REBASE

    git clone /s/remote-project/chceknumber

    cd checkNumber

    cat check_number.py

    sed -i -e "\$aelse: \n print('{0} is Odd'.format(num))" check_number.py

    sed -i '1s/^.*$/#Checks whether number 4 is even or odd/' check_number.py

    cat check_number.py

    git add check_number.py

    git commit -m "<message>"

    git fetch origin master

    git diff master origin/master

    git pull --rebase origin master

    vim check_number.py

    >>#Read......or odd    //delete everything else from <<<<<HEAD to #blue comment

    git add check_number.py

    git rebase --continue

    git log

    git push origin master

OPS_RIO

Operations

Rio quiz

1.Discipline in execution+pursuit of excellnce+customer experience
2.consistent+proactive risk management,discipline or behaviour,operations excellence
3.prompt handling of all changes......
4.break glass
5.all of the above options

marks:(4/5)
45/50 with these answers in Ops_RiO final assessment
1. Means of production
2. Ruby
3. Shift management  (2005 texas city)
4. Project oath (support engineer)
5. Recipies (object used by chef)
6. Ansible (not puppet)
7. Test kitchen (chef Dev kit for ruby)
8. Business continuity plan (earthquake)
9. Right combination of technical and inter personnel skills
10. RCA requires... (woolworth supermarket)


Rio final quiz
1) It automation :- All of the above
2) Expectations of TCSer :- End to end
3) TCS opn day:- 24th july
4) Ron :- Ron should hv tested the script in pre production
5) Not an automation tool:- VR
6) Main obj of rio :- break free
7) Earthquake :- Buisness
8) Google :- kubernate
9) Saas platform :- Datadog
10) Software platform for VM :- Vagrant
11. Means of production
12. Ruby
13. Shift management  (2005 texas city)
14. Project oath (support engineer)
15. Recipies (object used by chef)
16. Ansible (not puppet)
17. Test kitchen (chef Dev kit for ruby)
18. Business continuity plan (earthquake)
19. Right combination of technical and inter personnel skills
20. RCA requires... (woolworth supermarket)

FINAL QUIZ DBMS SOFTWARE FOUNDATION PHASE 5

FINAL QUIZ DBMS SOFTWARE FOUNDATION PHASE 5
1. which among the following is a correct Syntax for raising the user defined exception
handlers?
- Both 1 and 2
2. Which SQL statement returns a numeric value?
- SELECT sysdate-hire_date FROM EMP;
3. when does the for loop terminate?
- When the index reaches the UPPER bound or is terminated early using EXIT statement
4. Table structure:
EmpID | EmpName | ProjId | MNGR-Id | Location | Designation
.
.
.
By referring to the above table structure, for which of the below questions, we would
require to apply the concept of SubQuery?
- All
5. Select an appropriate option for a ‘FUNCTION’ in PLSQL.
- Function can return result value.
6. The ____________ contains a set of tables and views that Oracle use as a reference to the
database
- Data Dictionary
7. What are defined as exceptions in PL/SQL?
- Run time errors
8. From the below table:
EmpId | EmpNAme | ProjId | ProjName | No.OfHoursWorked
…
What are the probable and decomposed tables after performing second normal form?
Let us assume that…..
- Table1:
EmpId | EmpName
Table2:
ProjId | ProjName
Table3:
EmpId | ProjId | No.OfHoursWorked
9. From the below table …….. What would be the primary key to get unique record from the
table? (Pls Confirm)
- EmpID and ProjId together
10. A column with regerence to a record in a table should not have multiple values.
Which normal form, Talks about the above statement?
- First
11. DELETE * FROM STUDENT
What will be the output?
- Deletes all rows from STUDENT table
12. What are the complications, when as exception occurs?
- All of these.
13. The formal classifications describing the level of database normalization in a model are
called normal forms.
- TRUE
14. We can use Transaction control statements in database triggers
- False
15. Select the suitable option from below to create an index on “job” column in emp table?
- Create index emp_ind on emp(job);
16. Which of the statements helps in terminating the PL/SQL LOOP?
- EXIT WHEN
17. Database trigger can be fired when the table is TRUNCATED?
- False
18. Types of SQL statements
- TCL
- DDL
- DML
19. In the below table:
EmpID | EmpName | ProjId
.
.
.
By referring the above table, Select a suitable query which gets all employees whose
project is same as project of ‘d’?
- SELECT * FROM EMP WHERE ProjId=(SELECT ProjId FROM EMP WHERE EMPNAME=’d’)
20. On which of the below statements, acts as trigger firing events?
- All of these
21. We can enable or disable a database trigger
- True
22. Which is the below statement is used to remove access or privileges on database object to
users?
- Revoke
23. A stored function will not allow any parameter to be passed
- False
24. DCL Commands are used to enforce database security in a multiple user environment
- True
25. DDL commands
- CREATE
- ALTER
- DROP
26. Which is the correct syntax for handling Exception handlers?
- WHEN ex_name THEN stmt
27. Which of the below constraints will make sure to allow, only the values of a column (in a
master) to the respective column of a child table?
- Foreign key
28. What does TRUNCATE statement do?
- Remove all rows from a table
29. Select the suitable statement for PLSQL
- Bringing Programming language features to SQL

30. Which of the following is true with respect to Referential Integrity?
- Every foreign key value must match primary key value in the associated table ie
Parent table
31. What is the grant statement to grant select, insert, delete privileges on table: Emp to user:
TestUser?
- Grant Select, Insert, Delete on Emp to TestUser
32. Table 1 : Emp
EmpId | EmpName | ProjId
…
Table2: Proj
ProjId | ProjName
…
By referring to the above table structure, select the query which would Fetch EMPID,
EMPNAME, ProjId, ProjName for each employee?
- Select A.EmpID, A.EmpNAme, A.ProjId, B.ProjName from EMP A, Proj B WHERE
A.ProjID = B.ProjID
33. Select the suitable option for SubQuery
- Inner query executes first…
34. Which Prefixes are available to Oracle triggers?
- Both :new and :old
35. Evaluate the set of SQL statements: CREATE TABLE dept(dept_id NUMBER(2) dname
VARCHAR2(14), Loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT. What is true about the
set?
- The DESCRIBE DEPT statement displays the structure of the DEPT table

DBMS FINAL HANDS ON

PL SQL FINAL HACKERRANK CODE ASSESSMENT

1)
SET SERVEROUTPUT ON;

DECLARE
    CURSOR C1 IS SELECT * FROM EMPLOYEES;
    E EMPLOYEES%ROWTYPE;
    GRADE VARCHAR2(40);
BEGIN
    OPEN C1;
    LOOP
        FETCH C1 INTO E;
        EXIT WHEN C1%NOTFOUND;
        IF ( E.SALARY >= 30000 ) THEN
            GRADE := 'Senior manager';
        ELSIF ( E.SALARY >= 25000 ) THEN
            GRADE := 'Middle manager';
        ELSIF ( E.SALARY >= 20000 ) THEN
            GRADE := 'Junior manager';
        ELSE
            GRADE := 'Team member';
        END IF;

        dbmsoutput.putline(E.NAME || ' ' || GRADE);
    END LOOP;
END;
/


2)
SET SERVEROUTPUT ON;

DECLARE
    CURSOR C1 IS SELECT * FROM SCORES WHERE SCORE < 100;
    LINE SCORES%ROWTYPE;
    total NUMBER := 0;
    num NUMBER;
    flag NUMBER;

BEGIN
    OPEN C1;
    LOOP
        flag :=1;
        FETCH C1 INTO LINE;
        EXIT WHEN C1%NOTFOUND;
        num := LINE.SCORE;
        FOR i IN 2..sqrt(num)
        LOOP
            IF ( mod(num, i) = 0 ) THEN
                flag := 0;
                exit;
            END IF;
        END LOOP;
        IF ( flag=1 ) THEN
            total := total + LINE.SCORE;
        END IF;
    END LOOP;
    dbmsoutput.putline('Total=' || total);
END;
/


SQL CODE ASSESSMENT

1) DEPARTMENT WHIHC DOES NOT CONTAIN PROGRAMMER POEPLE

SELECT DISTINCT D.DEPTNAME FROM EMPLOYEES E JOIN DEPARTMENTS D ON E.DEPTID=D.DEPTID WHERE E.DEPTID NOT IN (SELECT E.DEPTID FROM EMPLOYEES E JOIN DEPARTMENTS D ON E.DEPTID=D.DEPTID WHERE E.EMPSKILL LIKE 'Programmer');

2) SOME OTHER QUESTION

SELECT DISTINCT D.DEPTNAME, E.EMPSKILL FROM EMPLOYEES E JOIN DEPARTMENTS D ON E.DEPTID = D.DEPTID;

INFORMATION MANAGEMENT AND INTEGRATION

INFORMATION MANAGEMENT AND INTEGRATION
REACT API
SKILLSOFT SOLUfTION:
1. Promote self contained components, merges js and html
2. Npm
3. Connect()
4. Rendered in js, added to projects
5. Render()
6. {This.props.heading}
7. Gruntfile, package json
8. Install grunt init
Install gruntplugin template
Run gruntinit gruntplugin in an empty directory
Run npm install

META DATA MANAGEMENT
SKILLSOFT SOLUTION:

PART 1
1. To connect to external  data sources
2. STORE customer INTO customer. Qvd;
3. LOAD * FROam product.qvd(qvd);
4. Mapping load
5. It's a third party, installed locally
6. Supports incremental loading, supports confirmed dimensions, reuse of extraction data

PART 2
1. XML
2. Server, complexity, lineage, objects
3. Descriptive, structural, administrative
4. It improves security of data, accuracy of data, increases consistency of data
5. Turnof basic metadata collection for server, avoid complex metadata creation processes, use a practical and pragmatic methodology
6. Tag field #measure with '$measure's, '$numeric';
7. RENAME = fields using rename_ mapping;
8. To many configuration of data governance dashboard
9. All except 'go accept independent  user driven method'

DATA ANALYTICS
SKILLSOFT SOLUTION:
1. Data source accuracy
2. SQL uses ss
3. Information is organized data and info stems from data
4. Create
5. The design  can be used to generate a db structure
6. TOGAF
7. PCI DSS
8. Clustered db analytical enginer
9. Each item can store different types of data and Dynamo db is a no SQL solution
10. 1433
11. ACL

DATA GOVERNANCE
SKILLSOFT SOLUTION:
1. The way in which it's used
2. Behavior
3. Domain
4. Access your data
5. Skills
6. Data
7. Tools
8. Expect a mix of technical and business expertise
9. 60% up time
10. A better understanding of behavior
11. Isolate different types
Information management – final quiz
1) What are the Benefits of using ELT process in QlikView?
Ans: Reuse data, support conformed dimension, support incremental loading
2) What is success status code?
Ans: 201
3) You are extracting data from customer table and store
Ans: STORE customer INTO customer.qvd;
4) You want to tag #measure field in your data with $measure and $numeric tags
Ans: TAG Field #measure With ‘measure’,’$numeric’;
5) Data Governance Dashboard tabs:
Ans: Server, Lineage, Objects, Complexity
6) To transform your sales data and map
Ans: Mapping LOAD
7) Identify whether the following statement is true or false. A URN can be a URL, and both are always URIs
Ans: True
8) An info governance program can’t be implemented without IT
Ans: Planning collaborately with IT early in process
9) Communication are point to point and randomized in governance
Ans: True
10) Having successfully extracted and transformed data
Ans: LOAD * FROM product.qvd (QVD);
11) What are the characteristics of Governance?
Ans: consistency, accuracy, security
12) Which of the following is not valid REST method
Ans: UPDATE
13) Which Statement accurately describes QlikView?
Ans: third party tool, installed locally
14) Which statement accurately describes primary purpose of QlikView Database?
Ans: To connect to external data sources
15) Which definition best describes power of data analytics:
Ans:
16) In fetch method of using API, response must be returned before use (T/F)
Ans: True
17) Finding critical data is critical to analyst not a great way to accomplish
Ans:
18) What is pattern frequency in Data Analytics:
Ans: Finding Reoccurring Transactional data
19) We can get to know whether the given app is built on developer tool chrome tab named as React (T/F)
Ans: True
20) Basic info of data governance includes all except:
Ans:
21) Biggest advantage of using Axios:
Ans: it enables automatic transformation of JSON data
22) Which two statement apply to analytics of risk decision:
Ans:
23) What is the use of OPTIONS request?
Ans:
24) Which of the following is correct? (JSON)
Ans: We can use JSON data directly in axios
25) Which request is triggered on refresh, forward/backward?
Ans: Get
26) What is one of the surprising but effective way of info governance?
Ans: Choose an integral rank-and-file employee and profile their world before and after implementing information governance.
27) What is the first thing you check on building data query:
Ans: Workflow diagrams
28) PUT can be used to modify collection of resources :( T/F)
Ans: True
29) Which of the following is not true when pasting chart in PowerPoint:
Ans: It pastes as an image
30) What is major function of data analytics?
Ans:
31) Identify whether the following statement is true or false. PUT can be used to modify collection of resources.
Ans: TRUE
32) What is the significance of status code – 405?
Ans: Method not allowed
33) What use “PUT” call in an API to
Ans: Update data
34) Finding existing data is critical to an Analyst. What is not a great way to accomplish this?
Ans: Start Completely Scratch
35) The standard referred to predict both form and content in Meta data is
Ans: Federal Geographic Data Committee
36) Which definition best describes the true power of data analytics
Ans: Produces automated decision making
37) What is the major functions of data analytics?
Ans: Building dashboards, Automated decision making, Data Visualization
38) Which of the following command will be used to create React project named as “MyApp”?
Ans: create-react-app MyAPP
39) When considering the next step after identifying information governance problem in the enterprise, it’s best to turn those into actionable projects…
Ans: as quickly as u can
40) Which request can be used to work with collection of resources?
Ans: Patch
41) What is Axios?
Ans: A promise based HDP library to make API call.
42) Which statement accurately describes the primary purpose of using profiles in the Data Governance Dashboard?
Ans: To manage the Organizations extract, transform and load process
43) We can “POST” call for
Ans:  add new data
44) Best practices in the management of data is known as Data Governance?
Ans: it increases consistency of data, it improves accuracy of data, it improves security of data.
45) Which command is used to start the React project after the required dependency installed?
Ans: $npm start
46) RESTful API work on which protocol?
Ans: HTTP
47) When working with data sets that are built for us, they may often have _____________ Data
Ans: Redundant
48) Which two statements apply to the analytics of risk decisions?
Ans: Compare against regional and local economic data, collects sales and inventory transactions
49) Data Analysts engage in all of the following activities except
Ans: Changing data values
50) When collecting and managing metadata, which statement accurately describe the best approach?
Ans: Turn off basic metadata collection for server, use a practical and pragmatic methodology, avoid complex metadata creation processes
51) A decision making monitoring and enforcement body that has authority over data management is called ___________
Ans: Data governance
52) What is the command used for installing axios?
Ans: npm install –save axios
53) Creating a formal governance plan or document is an unnecessary part of getting an information governance program off the ground.
Ans: False
54) What is the status code returned when a new resource is created by POST request?
Ans: 201
55) Point out the correct statement.
Ans: Raw data is original source of data
56) Valued metadata elements in the FGDC metadata content standard take the form:
Ans: Element_Name: Element Type