Newt Global Interview Questions and Answers

Use Azure Data Factory to move data from on-premise Oracle server to Azure cloud.

• Create a linked service to connect to the on-premise Oracle server

• Create a linked service to connect to the Azure cloud storage

• Create a pipeline with a copy activity to move data from on-premise to cloud

• Schedule the pipeline to run daily

• Monitor the pipeline for any errors or issues

Designing/implementing database solutions in the cloud involves selecting appropriate cloud service, data modeling, security, and scalability.

• Select the appropriate cloud service (e.g. Azure SQL Database, Cosmos DB, etc.) based on the requirements of the application

• Design the data model to optimize for the cloud environment (e.g. denormalization, partitioning, etc.)

• Implement security measures such as encryption, access control, and auditing

• Ensure scalability by using features...read more

Knowledge of RDBMS and current databases is essential for an Associate Consultant.

• Understanding of relational database management systems (RDBMS) like MySQL, Oracle, SQL Server

• Knowledge of database design, normalization, indexing, and querying

• Familiarity with NoSQL databases like MongoDB, Cassandra

• Awareness of current database trends and technologies

• Experience with data modeling and database optimization

Black box testing is a software testing technique where the tester tests the software without knowing its internal structure.

• Tests the functionality of the software without knowing the internal code

• Focuses on the inputs and outputs of the software

• Uses techniques like equivalence partitioning and boundary value analysis

• Examples include GUI testing, regression testing, and acceptance testing

Static testing is a technique of verifying software without executing it.

• It involves reviewing documents, code, and specifications to find errors and defects.

• Static testing can be done manually or with the help of tools.

• Examples include code reviews, walkthroughs, and inspections.

• It helps to identify defects early in the development cycle, reducing costs and improving quality.