Authors create tension in a story so the reader will be wondering what's going to happen, and might relate more to the story depending on where the tension is. If it's between two characters, or if the author will have one characters POV (point of view) about to have something really bad/good happen, and then change to a different POV so the reader keeps wondering what's going to happen, until it changes to the other POV again.
“Why do authors create tension in a story?” An author usually builds tension in his/her book because a book would be very predictable if the book did not have tension. The tension in a book causes a reader to stay attached to the book to see what events happen next.