Index: Ringtoets/Piping/test/Ringtoets.Piping.IO.Test/Builders/SoilDatabaseQueryBuilderTest.cs
===================================================================
diff -u -re1a8e98d60853beefbdb8c84e70f14165680ad7b -r0fbb881c5c82f540f01772234b3c1faadfab07f9
--- Ringtoets/Piping/test/Ringtoets.Piping.IO.Test/Builders/SoilDatabaseQueryBuilderTest.cs	(.../SoilDatabaseQueryBuilderTest.cs)	(revision e1a8e98d60853beefbdb8c84e70f14165680ad7b)
+++ Ringtoets/Piping/test/Ringtoets.Piping.IO.Test/Builders/SoilDatabaseQueryBuilderTest.cs	(.../SoilDatabaseQueryBuilderTest.cs)	(revision 0fbb881c5c82f540f01772234b3c1faadfab07f9)
@@ -107,9 +107,24 @@
         }
 
         [Test]
-        public void GetSegmentNamesUniqueQuery_Always_ReturnsExpectedValues()
+        public void GetCheckVersionQuery_Always_ReturnsExpectedValues()
         {
             // Setup
+            const string expectedQuery = "SELECT Value " +
+                                         "FROM _MetaData " +
+                                         "WHERE Key = 'VERSION' AND Value = @Value;";
+
+            // Call
+            string query = SoilDatabaseQueryBuilder.GetCheckVersionQuery();
+
+            // Assert
+            Assert.AreEqual(expectedQuery, query);
+        }
+
+        [Test]
+        public void GetSoilModelNamesUniqueQuery_Always_ReturnsExpectedValues()
+        {
+            // Setup
             const string expectedQuery =
                 "SELECT [All].nameCount == [Distinct].nameCount as AreSegmentsUnique " +
                 "FROM(SELECT COUNT(SSM_Name) nameCount FROM StochasticSoilModel) AS [All] " +
@@ -123,15 +138,15 @@
         }
 
         [Test]
-        public void GetCheckVersionQuery_Always_ReturnsExpectedValues()
+        public void GetStochasticSoilProfileProbabilitiesDefinedQuery_Always_ReturnsExpectedValues()
         {
             // Setup
-            const string expectedQuery = "SELECT Value " +
-                                         "FROM _MetaData " +
-                                         "WHERE Key = 'VERSION' AND Value = @Value;";
+            const string expectedQuery = "SELECT COUNT(Probability) == 0 as HasNoInvalidProbabilities " +
+                                         "FROM StochasticSoilProfile " +
+                                         "WHERE Probability NOT BETWEEN 0 AND 1 OR Probability ISNULL;";
 
             // Call
-            string query = SoilDatabaseQueryBuilder.GetCheckVersionQuery();
+            string query = SoilDatabaseQueryBuilder.GetStochasticSoilProfileProbabilitiesValidQuery();
 
             // Assert
             Assert.AreEqual(expectedQuery, query);