Soru 1: What command lets you create a connection between a local and remote repository?

• git remote add new
• git remote add origin
• git remote new origin
• git remote origin

Soru 2: How can you check your current git version?

• git –v
• git –option
• git –version
• git –current

Soru 3: Which of the following is true you when you use the following command?

git add -A

• All new and updated files are staged
• Files are staged in alphabetical order.
• Only updated files are staged
• All new files are staged

Soru 4: Your current project has several branches; master, beta, and push-notifications. You’ve just finished the notification feature in the push-notification branch, and you want to commit it to beta branch. How can you accomplish this?

• Checkout the beta branch and run git merge push-notification
• Checkout the push-notifications branch and run git merge beta
• Checkout the master branch and run git merge beta -> push-notification
• Delete the push-notification branch and it will be committed to the master branch automatically

Soru 5: Describe what the following git commands do to the commit history.

git reset --hard HEAD~5
(Reset the current branch to the commit just before the last 5)
git merge --squash HEAD@{1}
(HEAD@{1} is where the branch was just before the previous command. This command sets the state of the index to be as it would just after a merge from that commit)

• Reset the HEAD to the 5th commit in the repo, then merges to the master branch
• Delete the last 5 commits
• Reset the commit branch back before the last 5 commits, then squashes them into a single commit
• Merges the last 5 commits into a new branch

Soru 6: What will the following command print to the Terminal?

git remote -v

• A list of remote repositories you are connected to
• The current git version you’re running
• An inline editor for modifying remote repositories
• The last 5 git versions you’ve installed

Soru 7: What does the following command do to the git repository?

git reset --soft HEAD^

• Delete all previous commits and reset the repository history back to its initial state.
• Resets the working branch to the first commit.
• Undoes the last commit in the working branch and sets the HEAD back one commit.
• Keeps the HEAD at the current commit, but clears all previous commits.

Soru 8: Looking at the following commands, describe what is happening.

git checkout feature-user-location
git cherry-pick {kj2342134sdf090093f0sdgasdf99sdfo992mmmf9921231}

• The commit is being tagged for release on the feature-user-location-branch.
• The commit is being cherry picked as the new HEAD of the commit history
• A commit is being copied from its original branch over to the feature-user-location-branch
• A commit is being copies from the feature-user-location branch to the master branch

Soru 9: You find a bug in your project, but can’t locate where it was introduced in the commit history. How would you diagnose this problem?

• Manually backtrack through your commit history.
• Use git search -diff to compare all commits in your repository history.
• Use git bisect to compare the buggy commit to an early commit that works as expected.
• Run a git rebase to find the buggy commit.

Soru 10: Why would you use a pre-receive hook in your remote repository?

• You wouldn’t, you would use it in the local repository
• To execute a script when a remote receives a push that is triggered
  before any refs are updated
• To fire a script after updates are made to the remote repository
• To debug all commit tags and release versions

Soru 11: Why would the following command be used?

git rebase -i HEAD~10

• To run a comparative search of the last 10 commits for differences
• In order to locally cache the last 10 commits
• To delete the last 10 commits and reset the HEAD
• To list the last 10 commits and modify them with either the squash or fixup command

Soru 12: If you cloned an existing git repository, what would happen?

• Nothing, cloning is not a supported git function
• A new copy would overwrite the central repository
• A copy of the repository would be created on the hosting platform
• A copy of the repository would be created on your local machine

Soru 13: After checking your git status you get the following output, which shows the file beta-notes.js in the commit but also unstaged. How can this situation occur?

Change to be committed:

(use "git reset HEAD <file>..." to unstage)
modified: beta-notes.js
Changes not staged for commit:
(use "git add <file>..." to update what will be committed)
(use "git checkout --<file>..." to discard changes in working directory)

modified: beta-notes.js

• There were two copies of beta-notes.js but one was deleted.
• Beta notes.js was staged, then modified afterwards, creating two different versions of the file
• Two copies of beta-notes.js were created, but only one is being tracked
• There are two tracked copies of beta-notes.js, but one was removed from the commit.

Soru 14: Where are files stored before they are committed to the local repository?

• Saved files
• git documents
• git cache
• Staging area

Soru 15: In a situation where you have several commits for a single task, what is the most efficient way to restructure your commit history?

• Cherry pick the related commits to another branch.
• Squash the related commits together into a single coherent commit.
• Delete the task commits and recommit with a new message.
• Stash the related commits under a new hash.

Bonus: What commands would you use to force an overwrite of your local files with the master branch?

• Option 1

git pull --all
git reset --hard origin/master

• Option 2

git pull -u origin master
git reset --hard master

• Option 3

git pull origin master
git reset --hard origin/myCurrentBranch

• Option 4

git fetch --all
git reset --hard origin/master

Soru 1: What is the best way to explain what this script does?

if (!$_SESSION['myusername'])
{
    header('locaton: /login.php');
    exit;
}

• This script times out the session for myusername.
• This script is on a page that requires the user to be logged in. It checks to see if the user has a valid session.
• Cookies are starting to be stored as a result of this script.
• This script validates the username and password.

Soru 2: Which operator would you use to find the remainder after division?

• /
• %
• //
• DIV

Soru 3: What is the purpose of adding a lowercase “u” as a modifier after the final delimiter in a Perl-compatible regular expression?

• It makes the dot metacharacter match anything, including newline characters.
• It makes the pattern match uppercase letters.
• It inverts the greediness of the quantifiers in the pattern so they are not greedy by default.
• Both the pattern and subject string are treated as UTF-8.

Soru 4: What is the value of $total in this calculation?

$total = 2 + 5 * 20 - 6 / 3

• 44
• 138
• 126
• 100

Soru 5: Which value equates to true?

• 0
• NULL
• -1
• ”

Soru 6: What is a key difference between GET and POST?

• GET is used with the HTTP protocol. POST is used with HTTPS.
• GET displays the submitted data as part of the URL. During POST, this information is not shown, as it’s encoded in the request body.
• GET is intended for changing the server state and it carries more data than POST.
• GET is more secure than POST and should be used for sensitive information.

Soru 7: Which are valid PHP error handling keywords?

• try, throw, catch, callable
• try, throw, catch, finally
• try, yield, catch, finally
• yield, throw, catch, finally

Soru 8: The _ operator is useful for sorting operations. It compares two values and returns an integer less than, equal to, or greater than 0 depending on whether on whether the value on the ___is less than, equal to, or greater than the other.

• greater-than; right
• equality; right
• spaceship; left
• comparison; left

Soru 9: In the following script, which line(s) will cause an error(s)?

<?php
       $count = 0
       $_xval = 5
       $_yval = 1.0
       $some_string = "Hello there!";
       $some_string = "How are you?";
       $will i work = 6;
       $3blindmice = 3;
 ?>

• Line 6 will cause an error because you can’t reassign a new value to a variable that has already been set.
• Line 5 will cause an error because some_string should be someString.
• Line 3 and 4 will cause an error because a variable cannot start with an underscore(_).
• Line 7 and 8 will cause an error. Line 7 has whitespace in $will i work and should be $will_i_work. Line 8 cannot start with a number befcause it is a variable.

Soru 10: What does this script do?

$email = filter_input(INPUT_POST, 'email', FILTER_VALIDATE_EMAIL);
if ($email === false) {
  $emailErr = "Please re-enter valid email";
}

• It makes sure the email address is a good and functioning address
• It makes an email safe to input into a database
• It assigns an email to a variable and then removes all illegal characters from the $email variable
• It verifies that an email address is well formed.

Soru 11: Which code snippet uses the correct syntax for creating an instance of the Pet class?

• $dog = new Pet;
• $horse = (new Pet);
• $cat = new Pet();
• All of these answers

Soru 12: Which is the correct format for adding a comment to a PHP script?

• #This is a comment
• /* This is a comment /*
• // This is a comment
• All of these answers

Soru 13: What is missing from this code, which is supposed to create a test cookies?

1 $string_name = " testcookie";
2 $string_value = "This is a test cookie";
3 $expiry_info = info()+259200;
4 $string_domain = "localhost.localdomain";

• The $_REQUEST is missing.
• The call to setcookie() is missing.
• The $_COOKIES array is missing.
• The cookie session is missing.

Soru 14: All variables in PHP start with which symbol?

• &
• %
• _
• $

Soru 15: In a conditional statement, you want to execute the code only if both value are true. Which comparison operator should you use?

• ||
• &&
• &
• <=>

Soru 1: Which database is a NoSQL database type that can quickly store and retrieve key-value pairs?

• DynamoDB
• Neptune
• ORDS for MySQL
• Aurora

Soru 2: What does it cost to launch an EC2 instance from the AWS Marketplace?

• All images in the AWS Marketplace incur additional hourly fees in addition to the charges from the instance size you select.
• Each image has its own pricing that could either be free, or include charges for software licensing costs. You will also pay for the instance the image runs on
• You can only launch images that were created by other users on your AWS account, so you pay only for the instance size you select and the S3 storage costs for the base image
• All images in the AWS Marketplace contain only open-source software with no additional fees and are created by other AWS users. You will pay only for the instance size you select.

Soru 3: What in-memory caching server is not supported by ElastiCache?

• Redis 5
• Memcached
• Elasticsearch
• Redis 3

Soru 4: You have a large amount of files on your network-attached storage array that must be archived and maintained for a period of 10 years due to industry regulations. This data will be infrequently accessed but must be kept What is the best AWS service for storing this data?

• EFS
• Snowball
• OEBS
• S3 Glacier

Soru 5: Which AWS service complies with the standards outlined in Payment Card Industry Data Security Standard (PCI DSS) Level 1 for the handling and transmission of credit card data?

• API Gateway
• Simple Queue Service (SOS)
• Kinesis Data Streams
• All of these answers

Soru 6: What AWS services can help you automate your development pipeline for continuous integration and continuous deployment?

• CodePipeline
• CodeDeploy
• All of these answers
• CodeBuild

Soru 7: How do you architect a solution for an SQL Server database to be replicated across AWS regions in an active-active architecture?

• Use RDS for SQL Server and create the same instance in two different regions. Use Database Migration Service to keep each database in sync.
• Use a VPN or VPC peering to establish a connection between the VPCs in each region. Install SOL Server Enterprise Edition on EC2 instances in each region and configure an Always On availability group.
• Use RDS for SQL Server 2016 or 2017 Enterprise Edition. Enable Multi-AZ support and select the Mirroring/Always On option. Select another region for the mirroring option
• You can not set up an active-active architecture for SQL Server that spans geographic regions.

Soru 8 : Your database is an RDS instance running SQL Server with Multi-AZ replication and you have several older .NET console utilities that perform database operations every 15 seconds. When the cluster has to switch the primary database server to the secondary AZ, the .NET utilities start to report connection failures to the database although other applications are able to access the database. How do you correct this problem?

• .NET application will retain the IP address of a connection string until the host machine is rebooted.
• The NET utilities need to change the SQL Server endpoint in the connection strings to read from the secondary database server using a try/catch.
• Use the RDS console to force a reboot of the database instance so that the primary server becomes the master server again.
• The server running the .NET utilities is caching the DNS lookup on the database cluster address. Flush the DNS cache of the server and force the C# utilities to open new connections to the database.

Soru 9: You are creating a DynamoDB table to store all movies that have been released since 1938. Your application will allow users to search by movie title and see the details of that film. Given the sample below showing the movie data that you will be importing, what is the best set of keys to apply to this table?

    {
        "title":"The Avengers",
        "year": 2012,
        "cast" : ["Mark Ruffalo", "Robert Downey, Jr."],
        "genres" : ["Action"]
    }

• The primary key should be a partition key of the title field.
• The primary key should be the title field and the partition key should be the genres field.
• The primary key should be a composite key comprised of a partition key on the title field and a sort key on the year field.
• The primary key should be created as a completely unique value, such a sequential numerical list of movie IDs. The partition key should be title field for fast lookup.

Soru 10: What data store provides a simple and quick way of storing basic user attributes in an object-based format?

• ORDS for Oracle
• Redshift
• Neptune
• DynamoDB

Soru 11: You need a schemaless database. Which Amazon database service provides that solution?

• ORDS
• DynamoDB
• Aurora
• Redshift

Soru 12: Which communication channel does SNS not support natively?

• OSMS text message
• Automated phone call
• Push notification
• Email

Soru 13: You created a Windows EC2 instance with a public IP address and installed SQL Server. When attempting to connect to SQL Server from SQL Server Enterprise Manager on your local computer, the Windows EC2 instance is unable to establish a connection to the server. What is the first thing you should check?

• Check the routing tables for the VPC.
• Verify that the assigned security groups allow TCP port 1433 traffic from your current IP address.
• Check the policies within Windows Firewall
• Verify that you are connecting to the instance using a user that is not sa.

Soru 14: You are hosting an application configured to stream media to its clients on TCP ports 3380-3384, 3386-3388, and 3390. The Inbound tab below shows three incoming security group policies attached to this instance. Which policy should you use?

• Verify that the AWS account owners actually control the entire CIDR C block for 12.228.11.0-255 and these are secured IPs for RDP access into this instance.
• The rule that exposes TCP ports 3380-3390 would also publicly expose port 3389 (RDP) to the entire internet. Write separate rules to only expose the needed ports.
• The first security group rule allows all traffic into this instance. Exposing your entire instance to the whole internet leaves the server open to various attacks of the other services running on different port numbers.
• There are no recommendations to make.

Soru 15: A principle of DevOps is to view infrastructure as code. Which AWS service allows you to script your AWS infrastructure?

• CloudTrail
• CloudFormation
• AWS Config
• AWS Service Catalog

Soru 1: When using Goal Seek, you can find a target result by varying _ at most.

• one input
• two inputs
• three inputs
• four inputs

Soru 2: Which two functions check for the presence of numerical or nonnumerical characters in cells?

• ISVALUE AND ISNUMBER
• ISNUMBER and ISALPHA
• ISNUMBER and ISTEXT
• ISVALUE and ISTEXT

Soru 3: If you drag the fill handle (lower-right corner) of cell A2 downward into cells A3, A4, and A5, what contents will appear in those cells?

• Jan, Jan, Jan
• Feb, Mar, blank cell
• Feb, Mar, Apr
• FEB, MAB, APR

Soru 4: If cell A3 contains the text THE DEATH OF CHIVALRY, what will the function =PROPER(A3) return?

• the death of chivalry
• The death of Chivalry
• THE DEATH OF CHIVALRY
• The Death Of Chivalry

Soru 5: If the worksheet below, you want to use Data > Subtotal to show a subtotal value per sport. What must you do BEFORE applying the Subtotal function?

• Sort by the data in Column E.
• Format the data in Column D.
• Sort by the data in Column D.
• Format the data in Column E.

Soru 6: When editing a cell, what do you press to cycle between relative, mixed, and absolute cell references?

• Alt+F4 (Windows) or Option+F4 (Mac)
• The F4 (Windows) or Command+T (Mac)
• Ctrl+Shift+4 (Windows) or Command+Shift+4 (Mac)
• Alt+Shift+4 (Windows) or Option+Shift+4 (Mac)

Soru 7: You need to add a line chart showing a sales trends over the last 12 months and you have only a little space to work with. How can you convey the required information within a single cell?

• Add an image of the chart to a comment.
• Add a hyperlink to another worksheet that displays a chart when clicked.
• Add a sparkline, a graphic that summarizes data visually within a single worksheet cell.
• Add an image of the chart to the worksheet.

Soru 8: What is the best way to activate the Excel Help system?

• Right-click anywhere and select Help.
• Press F10.
• all of these answers.
• Press F1 or click the Help tab in the ribbon.

Soru 9: Which format will display the value 27,500,000 as 27.5?

• ##,###,,
• ###.0,,
• 999.9,,
• ###,###.0,

Soru 10: Some of your data in Column C is displaying as hashtags (#) because the column is too narrow. How can you widen Column C just enough to show all the data?

• Double-click the vertical boundary between columns C and D.
• Right-click column C and select Best-Fit.
• Double-click column C.
• Right-click column C, select Format Cells, and then select Best-Fit.

Soru 11: A cell contains the value 7.877 and you want it to display as 7.9. How can you accomplish this?

• Use the ROUND() function.
• Click the Decrease Decimal button twice.
• In the cells group on the Home tab, click Format > Format Cells. Then cick the Alignment tab and select Right Indent.
• Click the Decrease Decimal button once.

Soru 12: In the image below, which option(s) can you select so that the appropriate field headers appear in cells A4 and B3 instead of the terms Row Labels and Column Labels, respectively?

• Show in Tabular Form
• Show in Compact Form
• Show in Compact For or Show in Outline Form
• Show in Tabular Form or Show in Outline Form

Soru 13: The AutoSum formulas in the range C9:F9 below return unexpected values. Why is this?

• The AutoSum formulas refer to the column to the left of their cells.
• The AutoSum formulas include the year at the top of each column in the calculation.
• The AutoSum formulas exclude the bottom row of data.
• The AutoSum formulas include their own cells, creating a circular reference.

Soru 14: Which function returns the largest value in the range H2:H30?

• =MAX(H2:H30)
• =MAXIMUM(H2:H30)
• =LARGE(H2:H30,29)
• =UPPER(H2:H30,1)

Soru 15: Which formula returns the value in cell A1 of the worksheet named MySheet?

• =MySheet_A1
• =MySheet&A1
• =MySheet!A1
• =MySheet@A1

Soru 16: Which formula correctly counts the number of numeric values in both B4:E4 and G4:I4?

• =COUNT(B4:E4&G4:I4)
• =COUNT(B4:E4,G4:I4)
• =COUNT(B4:I4)
• =COUNT(B4:E4 G4:I4)

Soru 17: You want to apply subtotals per sport in the data below. What should you do before applying subtotals?

• Format the data in column E.
• Sort the data in column E.
• Format the data in column D.
• Sort the data in column D.

Soru 18: Which format setting does not change the background appearance of a cell?

• Cell style
• Fill color
• Pattern style
• Font color

Soru 19: You need to determine the commission earned by each Sales Rep, based on the Sales amounts in B3:B50 and the Commission rate specified in cell A1. You want to enter a formula in C3 and copy it down to C50. Which formula should you use?

• =$A1*B3
• =$A$1*B3
• =A1*$B3
• =A1*B3

Soru 20: Your worksheet has the value 27 in cell B3. What value is returned by the function =MOD (B3,6)?

• 4
• 3
• 1
• 5

Soru 21: Which format setting does not change the background appearance of a cell?

• Fill color
• Font Color
• Pattern Style
• Cell Style

Soru 1: To protect a document from accidental changes, which option should you select from the Protect Document (Windows) or Protect (Mac) menu?

• Mark as Final
• Always Open Read-Only
• Add a Digital Signature
• Encrypt with Password

Soru 2: Which feature allows you to copy attributes of selected text and apply them to another selection?

• Merge Formatting command
• Copy and Paste Styles command
• Copy and Paste Attributes command
• Format Painter tool

Soru 3: How do you insert the content of an existing Word document into your current Word document?

• Click Layout > Text > Text from File.
• Click Insert > Text > Building Blocks Organizer.
• Click Insert > Text > Text from File.
• Click Insert > Media

Soru 4: You are finalizing a two-page memo. Rather than having Word decide where page 1 ends, you want the next paragraph to begin on the top of page 2. How do you achieve this?

• Change the bottom margin to your current location.
• Insert a page break.
• Press Shift + Enter (Shift + Return).
• Insert a column break.

Soru 5: You want to set a wider inside margin to accommodate binding a document where pages are printed in both sides. Which option should you choose in the Page Setup dialog box

• Book Fold
• Different Odd & Even Pages
• Mirror Margins
• Landscape

Soru 6: Which feature lets you place a ghosted logo or text behind the regular text on your document?

• Background
• Watermark
• Imagemark
• Overlay

Soru 7: Where do you select the paper size for a document?

• Layout > Size.
• Design > Size.
• File > Page Setup.
• Layout > Margins.

Soru 8: Which option lets you mark your favourite templates for quick reuse in the future?

• Pin to list.
• Add to chooser.
• Drag to Home tab.
• Mark as favourite.

Soru 9: If you want to add a caption to a table, where should you look?

• Insert tab.
• Design tab.
• References tab.
• Layout tab.

Soru 10: How can you change the appearance of an entire table in a single step?

• Apply a table style.
• Apply a graphic style.
• Right-click a table and choose a new style.
• Apply a cell style.

Soru 11: Which option does the Find and Replace feature NOT support?

• Whole Word Only.
• Replace All.
• Match Case.
• Check Spelling.

Soru 12: Which statement best describes how a bookmark is used in a Word document?

• A bookmark is a hyperlink where the label is automatically generated.
• A bookmark works in conjuction with hyperlinks to allow you to quickly jump to a specific location in your document.
• A bookmark is a link in your document that can goive you quick access to webpages, files and other locations within your document.
• A bookmark is a color-coded graphic that appears in the navigation pane for easy access to a specific location in your document.

Soru 13: What is NOT an option when inviting a colleague to collaborate on a document?

• including a personalized message
• giving the collaborator the option to edit a document
• setting the collaborator’s access to view only
• granting administrator access

Soru 14: You split a document into three sections. What happens if you change the margins in the first section?

• The document reverts back to a single section with the new margin settings.
• The new margin settings are applied to all of the sections.
• The new margin settings are applied to the second and third sections.
• The new margin settings are applied to just the first section.

Soru 15: Which ribbon tab includes commands to add various types of objects or media to your document?

• Design
• File
• Layout
• Insert

Soru 16: What type of page is useful at the front of a large document, to identify the document title, author, and other metadata?

• cover page
• blank page
• master page
• table of contents page

Soru 17: What happens in this SmartArt object when you press the Delete key?

• The boxes resize to maintain the same overall height.
• The object is deleted and a hole is left behind.
• The text merges with the second box.
• The gaps between the boxes close and the boxes remain the same size.

Soru 18: Which command builds an overview of document contents based on applied headings styles?

• Manage Sources
• Cross-Reference
• Insert Index
• Table of Contents

Soru 19: Which statistic does the Word Count feature NOT collect?

• page breaks
• lines
• paragraphs
• characters (no spaces)

Soru 20: What is the default view when you open a document or create a new document?

• Print Layout view
• Draft view
• Edit view
• Web Layout view

Soru 21: You are working on a local copy of a document when Word unexpectedly closes. After you relaunch Word, how can you find the most recently saved version of the document?

• Click Open > Recent and select Recover Unsaved Documents.
• Click File > Options > Recover Unsaved Documents.
• Click File > Open > Recent > Documents.
• Click File > Recent > Recover Unsaved Documents.

Soru 22: What can you NOT insert into a Word document from the Insert tab?

• a sketch
• a symbol
• a 3D model
• an equation

Soru 23: What Microsoft Word feature lets you capture a portion of your screen to be used as an image in your document?

• Screen Clipping
• Screen Grab
• Screen Capture
• none of these answers

Soru 24: You want to create a shortcut that replaces an acronym that you type with the acronym’s full text-for example, replacing "/mt" with "Microsoft Teams". What Word feature do you use to create this shortcut?

• Replace All
• AutoFormat As You Type
• Find and Replace
• AutoCorrect Options

Soru 25: Your document contains two columns of content with a vertical line between the columns, as shown. From where can you delete the line?

• Insert > Text
• Columns dialog box
• Insert > Line > Vertical
• Insert > Line > Remove

Soru 26: How can you quickly move an insertion point to the start of the previous paragraph?

• Ctrl + Page Up
• Ctrl + Up Arrow
• Alt + Ctrl + Up Arrow
• Alt + Ctrl + Page Up